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 42 43 44 45 46 47 48 49 50 51 52 53 54
|
#region Commandes
private System.Data.DataTable CreerTestDataTable()
{
DataTable testDataTable = new DataTable("Test");
DataColumn columnId;
DataColumn columnLibelle;
columnId = new DataColumn("Id", typeof(int), null, MappingType.Element);
testDataTable.Columns.Add(columnId);
columnLibelle = new DataColumn("Libelle", typeof(string), null, MappingType.Element);
testDataTable.Columns.Add(columnLibelle);
return testDataTable;
}
private OleDbConnection CreerTestOleDbConnection()
{
//OleDbConnection testOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rezgui mohamed\\Desktop\\agent\\test1.mdb");
OleDbConnection testOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb");
return testOleDbConnection;
}
private System.Data.OleDb.OleDbDataAdapter CreerTestOleDbDataAdapter(OleDbConnection oleDbConnection)
{
OleDbDataAdapter testOleDbDataAdapter = new OleDbDataAdapter();
testOleDbDataAdapter.SelectCommand = new OleDbCommand();
testOleDbDataAdapter.SelectCommand.CommandText = "select Id, Libelle from Test";
testOleDbDataAdapter.SelectCommand.Connection = oleDbConnection;
return testOleDbDataAdapter;
}
private void AlimenterTestDataTable()
{
this.testOleDbDataAdapter.Fill(this.testDataTable);
}
private void ParcourirTestDataTable()
{
foreach (DataRow dataRow in this.testDataTable.Rows)
{
string caption = this.testDataTable.TableName;
string texte = string.Empty;
texte += "Colone 1: " + dataRow.ItemArray[0].ToString() + Environment.NewLine;
texte += "Colone 2: " + dataRow.ItemArray[1].ToString() + Environment.NewLine;
MessageBox.Show(texte, caption);
}
}
private void EnregistrerTestDataTable()
{
this.testOleDbDataAdapter.Update(this.testDataTable);
}
#endregion Commandes |
Partager