
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()
应该是向DataSet中的DataTable中添加一行吧?DataRow dr = ds.Tables[ "test "].NewRow()dr[ "test_id "] = "0 "
dr[ "test_name "] = "测试 "
ds.Tables[ "test "].Rows.InsertAt(dr, 0)
上面是插入,如果是在后面添加,这样
ds.Tables[ "test "].Rows.Add(dr)
删除数据后,要重新绑定数据源
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)