Simplest program on database access using ADO

Accessing database is pretty simple job using C# and ADO. In this sample code, I access an access database.

Accessing database is pretty simple job using C# and ADO. In this sample code, I access an access database mcTest.mdb, which has a table called "Developer". I display contents of the table in a listbox. 

Just add a list box to the form and the following code to the form load. Don't forget to add reference to System.Data and System.Data.OleDb namespaces.

private void Form1_Load(object sender, System.EventArgs e)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mcTest.MDB";
string strSQL = "SELECT * FROM Developer" ;
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter( strSQL, myConn );
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );
DataTable dTable = dtSet.Tables[0];
foreach( DataRow dtRow in dTable.Rows )
{
listBox1.Items.Add( dtRow["Name"].ToString());
listBox1.Items.Add( dtRow["Address"].ToString());
}
}