1string Name = @"C:\Documents and Settings\kaa8823\My Documents\Visual Studio 2005\Projects\Classes\Solution\LabelPrinter\LabelMaker1\bin\Debug\Database\Data.dat";
2 string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Name;
3
4 string sSQL = "SELECT ITEMNUM, LOCATION, CATALOGCODE, ISSUEUNIT, DESCRIPTION from MATERIAL ORDER BY ITEMNUM";
5 OleDbDataReader dr;
6 OleDbConnection oCnn = new OleDbConnection(ConnectionString);
7 OleDbCommand oCmd = oCnn.CreateCommand();
8
9 DataTable mTable = new DataTable();
10 DataRow mLine;
11 mTable.Columns.Add(new DataColumn("ITEMNUM", typeof(string)));
12 mTable.Columns.Add(new DataColumn("LOCATION", typeof(string)));
13 mTable.Columns.Add(new DataColumn("CATALOGCODE", typeof(string)));
14 mTable.Columns.Add(new DataColumn("ISSUEUNIT", typeof(string)));
15 mTable.Columns.Add(new DataColumn("DESCRIPTION", typeof(string)));
16
17 oCnn.Open();
18 oCmd.CommandText = sSQL;
19 dr = oCmd.ExecuteReader();
20 while (dr.Read())
21 {
22 mLine = mTable.NewRow();
23 mLine["ITEMNUM"] = dr["ITEMNUM"].ToString();
24 mLine["LOCATION"] = dr["LOCATION"].ToString();
25 mLine["CATALOGCODE"] = dr["CATALOGCODE"].ToString();
26 mLine["ISSUEUNIT"] = dr["ISSUEUNIT"].ToString();
27 mLine["DESCRIPTION"] = dr["DESCRIPTION"].ToString();
28
29 mTable.Rows.Add(mLine);
30 }
31 dr.Close();
32 oCnn.Close();
33
34 this.dataGridView1.DataSource = mTable;