方法一
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条)