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
            // open 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
                    DataSet t = new DataSet();
                    a.Fill(t);

                    // Afficher les donnees dans l'ecran
                    dataGridView1.DataSource = t;
                }
            }
        }
    }
}