[.Net] DataTable添加列和行的三種方法

標籤：des   style   blog   io   ar   color   sp   資料   on   

#region 方法一:DataTable tblDatas =new DataTable("Datas");DataColumn dc =null;dc = tblDatas.Columns.Add("ID", Type.GetType("System.Int32"));dc.AutoIncrement =true;//自動增加dc.AutoIncrementSeed =1;//起始為1dc.AutoIncrementStep =1;//步長為1dc.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);#endregion

 

#region 方法二:DataTable tblDatas =new DataTable("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(newobject[] { null, "a", "b", "c" });tblDatas.Rows.Add(newobject[] { null, "a", "b", "c" });tblDatas.Rows.Add(newobject[] { null, "a", "b", "c" });#endregion

 

#region 方法三：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 ="price * 0.0862";//設定該列得運算式，用於計算資料行中的值或建立彙總列// 建立table的第三列DataColumn totalColumn =new DataColumn();totalColumn.DataType = System.Type.GetType("System.Decimal");totalColumn.ColumnName ="total";totalColumn.Expression ="price + tax";//該列的運算式，是第一列和第二列值得和// 將所有的列添加到table上table.Columns.Add(priceColumn);table.Columns.Add(taxColumn);table.Columns.Add(totalColumn);//建立一行DataRow row = table.NewRow();table.Rows.Add(row);//將此行添加到table中//將table放在視圖中DataView view =new DataView(table);//綁定到DataGriddg.DataSource = view;dg.DataBind();#endregion

[.Net] DataTable添加列和行的三種方法