110,533
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("id");
dt1.Columns.Add("age");
dt1.Columns.Add("name");
dt1.Rows.Add("a1", "x", "x");
dt1.Rows.Add("b1", "x", "x");
DataTable dt2 = new DataTable();
dt2.Columns.Add("id");
dt2.Columns.Add("age");
dt2.Columns.Add("name");
dt2.Rows.Add("a1", "x", "x");
dt2.Rows.Add("c1", "x", "x");
dt2.Rows.Add("d1", "x", "x");
dt1.Merge(dt2);
dt1.TableName = "test";
DataRow[] dr = dt1.Select("id='a1' or id='b1' or id='c1' ", "id asc").Clone() as DataRow[];
DataTable temp = new DataTable();
temp = dt1.Clone();
for (int i = 0; i < dr.Length; i++)
{
temp.Rows.Add(dr[i].ItemArray);//如果要去重的话,需要在此遍历temp,此处省略
}
GridView gv = new GridView();
gv.DataSource = temp;
gv.DataBind();
Form.Controls.Add(gv);
}
}