1: private void btnReadTable_Click(object sender, EventArgs e){
2: //fill the datatable
3: using (SqlConnection sqlConn= new SqlConnection
4: (@"Database=Northwind2k5;Server=.\sqldev2k5;" +
5: "Integrated Security=True"))
6: {
7:
8: SqlCommand sqlCmd = new SqlCommand
9: ("Select * From Customers", sqlConn);
10:
11: sqlConn.Open();
12:
13: SqlDataReader sqlDr = sqlCmd.ExecuteReader();
14: DataTable dtCust = new DataTable();
15:
16: dtCust.Load(sqlDr); sqlDr.Close();
17:
18: //read the content of the datatable
19: //with the way in ado.net 1.x version:
20: foreach (DataRow aRow in dtCust.Rows)
21: {
22: Console.WriteLine(aRow["CustomerID"].ToString());
23: }
24:
25: //read the content of the datatable
26: //with the new alternative way
27: //provided in ado.net 2.0 version:
28: DataTableReader dtReader;
29: dtReader = dtCust.CreateDataReader();
30: while (dtReader.Read())
31: {
32: Console.WriteLine(dtReader["CustomerID"].ToString());
33: }
34: dtReader.Close();
35: }
36: }