1 DataTable table = new DataTable(); //Create a new Table
2 DataColumn colID = new DataColumn("ID",System.Type.GetType("System.Int32"));//ID
3 DataColumn colName = new DataColumn("Name",System.Type.GetType("System.String"));//名称
4 DataColumn colNum = new DataColumn("Num", System.Type.GetType("System.Int32"));//数量
5 DataColumn colPrice = new DataColumn("Price", System.Type.GetType("System.Double"));//进货价格
6 DataColumn colPlace = new DataColumn("Place", System.Type.GetType("System.String"));//供货商
7 DataColumn colDescription = new DataColumn("Description", System.Type.GetType("System.String"));//备注
8 table.PrimaryKey = new DataColumn[] { table.Columns["ID"] };
9 //add all the define column
10 table.Columns.AddRange(new DataColumn[] { colID, colName, colNum, colPlace, colPrice, colDescription });
11
12 //Add a line of data
13 DataRow row = table.NewRow();
14 row[colID] = 1;
15 row[colName] = "ThinkPad-E420";
16 row[colNum] = 10;
17 row[colPrice] = 4000;
18 row[colPlace]="南京苏创";
19 row[colDescription]= "测试数据";
20 table.Rows.Add(row);
21
22 //查询
23 DataRow[] searchRows = table.Select();
24 DataRow[] searchRows1 = table.Select("ID=1");
25 //取值
26 Console.WriteLine(searchRows[0][0].ToString());