1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
   | using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
 
namespace UserManagementApplication
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            FillData();
        }
 
        void FillData()
        {
            // Ouvrir une connexion
            using (SqlCeConnection c = new SqlCeConnection(
                Properties.Settings.Default.UserDataConnectionString))
            {
                c.Open();
                // Creer un nouveau DataAdapter
                using (SqlCeDataAdapter a = new SqlCeDataAdapter("SELECT * FROM Users", c))
                {
                    // Remplir la DataTable
                    DataTable t = new DataTable();
                    a.Fill(t);
 
                    // Afficher les donnees dans l'ecran
                    dataGridView1.DataSource = t;
                }
            }
        }
    }
} |