DataSet ds = new DataSet("tb");
DataTable dt = new DataTable();
ds.Tables.Add(dt);
DataColumn dc = new DataColumn();
dc.ColumnName = "id";
dc.DataType = typeof(int);
DataColumn dc1 = new DataColumn();
dc1.ColumnName = "name";
dc1.DataType = typeof(string);
dt.Columns.Add(dc);
dt.Columns.Add(dc1);
dt.PrimaryKey = new DataColumn[] { dc };
DataRow dr = dt.NewRow();
dr[0] = 1;
dr[1] = "zhangsan";
DataRow dr1 = dt.NewRow();
dr1[0] = 2;
dr1[1] = "lisi";
dt.Rows.Add(dr);
dt.Rows.Add(dr1);
DataTable dt = new DataTable();
ds.Tables.Add(dt);
DataColumn dc = new DataColumn();
dc.ColumnName = "id";
dc.DataType = typeof(int);
DataColumn dc1 = new DataColumn();
dc1.ColumnName = "name";
dc1.DataType = typeof(string);
dt.Columns.Add(dc);
dt.Columns.Add(dc1);
dt.PrimaryKey = new DataColumn[] { dc };
DataRow dr = dt.NewRow();
dr[0] = 1;
dr[1] = "zhangsan";
DataRow dr1 = dt.NewRow();
dr1[0] = 2;
dr1[1] = "lisi";
dt.Rows.Add(dr);
dt.Rows.Add(dr1);
本文详细介绍了如何使用DataSet创建数据集,并通过代码实例展示了数据集的基本操作,包括添加表、定义列类型、设置主键和插入数据。
1607

被折叠的 条评论
为什么被折叠?



