Code666 (代码贴、代码片段)

[C#] c#的DataTable中添加列和行的方法 →→→→→进入此内容的聊天室

来自 , 2019-11-19, 写在 C#, 查看 101 次.
URL http://www.code666.cn/view/283085d3
  1. ==========  方法一
  2.  
  3. DataTable  tblDatas = newDataTable("Datas");
  4. DataColumn dc = null;
  5.  
  6. //赋值给dc，是便于对每一个datacolumn的操作
  7. dc =tblDatas.Columns.Add("ID",Type.GetType("System.Int32"));
  8. dc.AutoIncrement= true;//自动增加
  9. dc.AutoIncrementSeed = 1;//起始为1
  10. dc.AutoIncrementStep = 1;//步长为1
  11. dc.AllowDBNull = false;//
  12.  
  13. dc = tblDatas.Columns.Add("Product",Type.GetType("System.String"));
  14. dc = tblDatas.Columns.Add("Version",Type.GetType("System.String"));
  15. dc = tblDatas.Columns.Add("Description",Type.GetType("System.String"));
  16.  
  17. DataRow newRow;
  18. newRow = tblDatas.NewRow();
  19. newRow["Product"] = "大话西游";
  20. newRow["Version"] = "2.0";
  21. newRow["Description"] = "我很喜欢";
  22. tblDatas.Rows.Add(newRow);
  23.  
  24. newRow = tblDatas.NewRow();
  25. newRow["Product"] = "梦幻西游";
  26. newRow["Version"] = "3.0";
  27. newRow["Description"] = "比大话更幼稚";
  28. tblDatas.Rows.Add(newRow);
  29.  
  30.  
  31. ==========  方法二
  32.  
  33. DataTable tblDatas = newDataTable("Datas");
  34. tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));
  35. tblDatas.Columns[0].AutoIncrement = true;
  36. tblDatas.Columns[0].AutoIncrementSeed = 1;
  37. tblDatas.Columns[0].AutoIncrementStep = 1;
  38.  
  39. tblDatas.Columns.Add("Product",Type.GetType("System.String"));
  40. tblDatas.Columns.Add("Version",Type.GetType("System.String"));
  41. tblDatas.Columns.Add("Description",Type.GetType("System.String"));
  42.  
  43. tblDatas.Rows.Add(newobject[]{null,"a","b","c"});
  44. tblDatas.Rows.Add(newobject[] { null, "a", "b", "c" });
  45. tblDatas.Rows.Add(new object[] { null, "a", "b", "c" });
  46. tblDatas.Rows.Add(new object[] { null, "a", "b", "c" });
  47. tblDatas.Rows.Add(new object[] { null, "a", "b", "c" });
  48.  
  49.  
  50. ==========  方法三
  51.  
  52. DataTable table = new DataTable ();
  53.  
  54. //创建table的第一列
  55. DataColumn priceColumn = new DataColumn();
  56. //该列的数据类型
  57. priceColumn.DataType = System.Type.GetType("System.Decimal");
  58. //该列得名称
  59. priceColumn.ColumnName = "price";
  60. //该列得默认值
  61. priceColumn.DefaultValue =50;
  62.  
  63. // 创建table的第二列
  64. DataColumn taxColumn = new DataColumn();
  65. taxColumn.DataType = System.Type.GetType("System.Decimal");
  66. //列名
  67. taxColumn.ColumnName = "tax";
  68. //设置该列得表达式，用于计算列中的值或创建聚合列
  69. taxColumn.expression_r_r = "price *0.0862";
  70. // Create third column.
  71. DataColumn totalColumn = new DataColumn();
  72. totalColumn.DataType = System.Type.GetType("System.Decimal");
  73. totalColumn.ColumnName = "total";
  74. //该列的表达式，值是得到的是第一列和第二列值得和
  75. totalColumn.expression_r_r = "price + tax";
  76.  
  77. // 将所有的列添加到table上
  78. table.Columns.Add(priceColumn);
  79. table.Columns.Add(taxColumn);
  80. table.Columns.Add(totalColumn);
  81.  
  82. //创建一行
  83. DataRow row = table.NewRow();
  84. //将此行添加到table中
  85. table.Rows.Add(row);
  86.  
  87. //将table放在试图中
  88. DataViewview = new DataView(table);
  89. dg.DataSource = view;
  90.  
  91. dg.DataBind();
  92.  

回复 "c#的DataTable中添加列和行的方法"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666