DataTable添加列和行的三种方法.docVIP

#region 方法一: DataTable tblDatas = new DataTable(Datas); DataColumn dc = null; 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); #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(new object[] { 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 }); tblDatas.Rows.Add(new object[] { 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()