Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/1/30 1:31:43
动态生成DataTable代码_[Asp.Net教程]

动态生成DataTable代码_[Asp.Net教程]
private DataTable CreateTable()
{
DataTable dt = new DataTable("dirName");
#region table column
DataColumn columnID = new DataColumn(); //创建一列
columnID.DataType = System.Type.GetType("System.Int32"); //数据类型
columnID.ColumnName = "ID"; //列名
columnID.AutoIncrement = true; //自动递增ID号
dt.Columns.Add(columnID); //添加到table
DataColumn columnName = new DataColumn();
columnName.DataType = System.Type.GetType("System.String");
columnName.ColumnName = "Name";
dt.Columns.Add(columnName);
DataColumn fullName = new DataColumn();
fullName.DataType = System.Type.GetType("System.String");
fullName.ColumnName = "fullName";
dt.Columns.Add(fullName);
DataColumn cTime = new DataColumn();
cTime.DataType = System.Type.GetType("System.String");
cTime.ColumnName = "CreateDate";
dt.Columns.Add(cTime);
DataColumn type = new DataColumn();
type.DataType = System.Type.GetType("System.String");
type.ColumnName = "type";
dt.Columns.Add(type);
DataColumn exName = new DataColumn();
exName.DataType = System.Type.GetType("System.String");
exName.ColumnName = "exName";
dt.Columns.Add(exName);
DataColumn size = new DataColumn();
size.DataType = System.Type.GetType("System.Int32");
size.ColumnName = "size";
dt.Columns.Add(size);
#endregion
//设置主键
DataColumn[] keys = new DataColumn[1];
keys[0] = columnID;
dt.PrimaryKey = keys;
for (int i = 0; i < 3; i++)
{
DataRow row;
row = dt.NewRow();
row["Name"] = "陈yu**";
row["fullName"] = "陈**";
row["exName"] = "";
row["CreateDate"] = System.DateTime.Now.ToShortDateString();
row["type"] = "1";
row["size"] = 0;
dt.Rows.Add(row);
}
return dt;
}

赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759