天涯之外

导航

DataTable的Merge方法和添加datatable到dataset

Merge方法是将两个结构相似的datatable合并成一个datatable:
  实例代码:
//create table1 DataTable dt1 = new DataTable(); dt1.Columns.Add("id"); dt1.Columns.Add("name"); dt1.Columns.Add("pwd"); for (int i = 0; i < 5; i++) { dt1.Rows.Add(new object[] { i.ToString(), "name" + i.ToString(), "**" }); } //create table2 DataTable dt2 = new DataTable(); dt2.Columns.Add("id"); dt2.Columns.Add("name"); dt2.Columns.Add("pwd"); for (int i = 5; i < 10; i++) { dt1.Rows.Add(new object[] { i.ToString(), "name" + i.ToString(), "**" }); } //Merge two tables DataTable dt3 = null; dt3 = dt1.Clone(); if (dt3 != null) { dt3.Merge(dt1); dt3.Merge(dt2); this.dataGridView1.DataSource = dt3; }
  将datatable添加到dataset里面
DataTable dt = new DataTable(); dt.Columns.Add("id"); dt.Columns.Add("name"); dt.Columns.Add("pwd"); for (int i = 0; i < 10;i++ ) { dt.Rows.Add(new object[] {i.ToString(),"name"+i.ToString(),"**"}); } DataSet ds = new DataSet(); ds.Tables.Add(dt); this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

posted on 2009-03-26 15:31  天涯之外  阅读(514)  评论(0编辑  收藏  举报