AI时代，找源码已成为过去式，纪念我过去的十年0(回)
69天前
还有人吗2(回)
87天前会python真的可以为所欲为0(回)
567天前
这里还有人吗2(回)
752天前这里还有人吗0(回)
752天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
977天前========== 方法一 |
|
DataTable tblDatas = newDataTable("Datas"); |
DataColumn dc = null; |
|
//赋值给dc，是便于对每一个datacolumn的操作 |
dc =tblDatas.Columns.Add("ID",Type.GetType("System.Int32")); |
dc.AutoIncrement= true;//自动增加 |
dc.AutoIncrementSeed = 1;//起始为1 |
dc.AutoIncrementStep = 1;//步长为1 |
dc.AllowDBNull = false;// |
|
dc = tblDatas.Columns.Add("Product",Type.GetType("System.String")); |
dc = tblDatas.Columns.Add("Version",Type.GetType("System.String")); |
dc = tblDatas.Columns.Add("Description",Type.GetType("System.String")); |
|
DataRow newRow; |
newRow = tblDatas.NewRow(); |
newRow["Product"] = "大话西游"; |
newRow["Version"] = "2.0"; |
newRow["Description"] = "我很喜欢"; |
tblDatas.Rows.Add(newRow); |
|
newRow = tblDatas.NewRow(); |
newRow["Product"] = "梦幻西游"; |
newRow["Version"] = "3.0"; |
newRow["Description"] = "比大话更幼稚"; |
tblDatas.Rows.Add(newRow); |
========== 方法二 |
|
DataTable tblDatas = newDataTable("Datas"); |
tblDatas.Columns.Add("ID", Type.GetType("System.Int32")); |
tblDatas.Columns[0].AutoIncrement = true; |
tblDatas.Columns[0].AutoIncrementSeed = 1; |
tblDatas.Columns[0].AutoIncrementStep = 1; |
|
tblDatas.Columns.Add("Product",Type.GetType("System.String")); |
tblDatas.Columns.Add("Version",Type.GetType("System.String")); |
tblDatas.Columns.Add("Description",Type.GetType("System.String")); |
|
tblDatas.Rows.Add(newobject[]{null,"a","b","c"}); |
tblDatas.Rows.Add(newobject[] { null, "a", "b", "c" }); |
tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); |
tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); |
tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); |
|
========== 方法三 |
DataTable table = new DataTable (); |
|
//创建table的第一列 |
DataColumn priceColumn = new DataColumn(); |
//该列的数据类型 |
priceColumn.DataType = System.Type.GetType("System.Decimal"); |
//该列得名称 |
priceColumn.ColumnName = "price"; |
//该列得默认值 |
priceColumn.DefaultValue =50; |
|
// 创建table的第二列 |
DataColumn taxColumn = new DataColumn(); |
taxColumn.DataType = System.Type.GetType("System.Decimal"); |
//列名 |
taxColumn.ColumnName = "tax"; |
//设置该列得表达式，用于计算列中的值或创建聚合列 |
taxColumn.expression_r_r = "price *0.0862"; |
// Create third column. |
DataColumn totalColumn = new DataColumn(); |
totalColumn.DataType = System.Type.GetType("System.Decimal"); |
totalColumn.ColumnName = "total"; |
//该列的表达式，值是得到的是第一列和第二列值得和 |
totalColumn.expression_r_r = "price + tax"; |
|
// 将所有的列添加到table上 |
table.Columns.Add(priceColumn); |
table.Columns.Add(taxColumn); |
table.Columns.Add(totalColumn); |
|
//创建一行 |
DataRow row = table.NewRow(); |
//将此行添加到table中 |
table.Rows.Add(row); |
//将table放在试图中 |
DataViewview = new DataView(table); |
dg.DataSource = view; |
|
dg.DataBind(); |
by: 发表于：2018-01-24 10:54:58 顶(0) | 踩(0) 回复
??
回复评论