请教,,动态创建DATATABLE,并动态新建列...

[cookies10wen]

如题,,如何动态创建一个表,,新建两列名为Id,Count...然后循环写入行数据...谢谢..

[bsetsail]

        DataTable dt = new DataTable();
        dt.Columns.Add("Id");
        dt.Columns.Add("Count");

        for (int i = 0; i < 5; i++)
        {
            DataRow dr = dt.NewRow();
            dr["Id"] = i.ToString();
            dr["Count"] = i.ToString();
            dt.Rows.Add(dr);
        }

[xingzhiasa]

[Quote=引用 1 楼 bsetsail 的回复:]
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("Count");

for (int i = 0; i < 5; i++)
{
DataRow dr = dt.NewRow();
dr["Id"] = i.ToString();
dr["Count"] = i.ToString();
dt.Rows.Add(dr);
}
[/Quote]

1L的仁兄已经写了……只好帮顶支持下了……

[LYH_OHYES]

  DataTable table = new DataTable("TableName");
        table.Columns.Add("ID",typeof(string));
        table.Columns.Add("Count", typeof(int));

        for (int i = 0; i <= 7; i++)
        {
            DataRow row = new DataRow();
            row["ID"] = "xxx";
            row["Count"] = i;
      
            table.Rows.Add(row);
        }

[bw555]

给你个例子

'创建表 
Dim name As DataTable = New DataTable("Customers")
name.Columns.Add("字段名称", Type.GetType("System.String"))
name.Columns.Add("字段类型", Type.GetType("System.String"))

            
'添加行
Dim s As DataRow
s = name.NewRow
s("字段名称") = "ss"
s("字段类型") = "n"
name.Rows.Add(s)

[ljhcy99]

DataSet dataset = new DataSet ();
DataTable table = new DataTable();
DataColumn col1 = new DataColumn("Id");
DataColumn col2 = new DataColumn("Count");
table.Columns.Add(col1);
table.Columns.Add(col2);
for(int i =0;i<10;i++)
{
DataRow row = table.NewRow();
row[0] = i+10;
row[1] = i+20;
table.Rows.Add(row);
}
dataset.Tables.Add(table);

还可以写很多表上的约束，比如Unique 约束，显示设置字段的数据类型等等，
看看
http://msdn.microsoft.com/zh-cn/library/system.data.datatable(VS.80).aspx