for (int i = 0; i < dataTable.Rows.Count; i++)
{
for (int j = 0; j < dataTable.Columns.Count; j++)
{
Console.WriteLine(dataTable.Rows[i][j].ToString());
}
}
using System.Data;//添加引用
DataTable dt = new DataTable();
dt.Columns.Add("product_id",typeof(int));
dt.Columns.Add("product_name", typeof(string));
DataRow dr = dt.NewRow();//创建与该表具有相同结构的DATAROW
dr["product_id"]=1;
dr["product_name"]="产品名称";
dt.Rows.Add(dr);
DataTable tblDatas = newDataTable( "Datas" ); |
dc =tblDatas.Columns.Add( "ID" ,Type.GetType( "System.Int32" )); |
dc.AutoIncrementSeed = 1; |
dc.AutoIncrementStep = 1; |
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" )); |
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 (); |
DataColumn priceColumn = new DataColumn(); |
priceColumn.DataType = System.Type.GetType( "System.Decimal" ); |
priceColumn.ColumnName = "price" ; |
priceColumn.DefaultValue =50; |
DataColumn taxColumn = new DataColumn(); |
taxColumn.DataType = System.Type.GetType( "System.Decimal" ); |
taxColumn.ColumnName = "tax" ; |
taxColumn.expression_r_r = "price *0.0862" ; |
DataColumn totalColumn = new DataColumn(); |
totalColumn.DataType = System.Type.GetType( "System.Decimal" ); |
totalColumn.ColumnName = "total" ; |
totalColumn.expression_r_r = "price + tax" ; |
table.Columns.Add(priceColumn); |
table.Columns.Add(taxColumn); |
table.Columns.Add(totalColumn); |
DataRow row = table.NewRow(); |
DataViewview = new DataView(table); |