1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| private void Form1_Load(object sender, EventArgs e)
{
string ch = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="".\famille.mdb"";User ID=Admin; ";
OleDbConnection connec = new OleDbConnection(ch);
string requete = "select * from Enfants";
OleDbDataAdapter da = new OleDbDataAdapter(requete, connec);
DataSet ds = new DataSet();
da.Fill(ds, "enfants");
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(da);
for (int i = 0; i < ds.Tables["enfants"].Rows.Count; i++)
{
dataGridView1.DataSource = ds.Tables["enfants"];
listBox1.DataSource = ds.Tables["enfants"];
listBox1.DisplayMember = "Nom";
} |
