DataTable详细使用方法

最新推荐文章于 2022-07-11 11:36:25 发布

weixin_30436101

最新推荐文章于 2022-07-11 11:36:25 发布

阅读量104

点赞数

原文链接：http://www.cnblogs.com/cnjava/archive/2012/02/26/2368914.html

版权

 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());