private void btnNouveau_Click(object sender, EventArgs e)
{
string connectionString = "provider=Microsoft.JET.OLEDB.4.0;" + "database source =c:\\ADC.mdb;User Id=admin;Password=;";
string commandString = "Select Tel, Fax from tblArchs";
OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString);
DataSet DataSet = new DataSet();
DataAdapter.Fill(DataSet, "tblArchs");
DataTable DataTable = DataSet.Tables[0];
foreach (DataRow DataRow in DataTable.Rows)
{
listBox1.Items.Add(DataRow["Tel"] + "(" + DataRow["Fax"] + ")");
}
}
Partager