如果多個tatable沒有主外鍵的,只是想合併到最後的話,都是以下這個方式 dt3.Merge(dt2); dt3.Merge(dt4); dt3.Merge(dt5); dt3.Merge(dt6);
DataTable dt1 = new DataTable(); dt1.Columns.Add("ID ", typeof(int)); dt1.Columns.Add("Name ", typeof(string)); dt1.Rows.Add(1, "Age "); dt1.Rows.Add(2, "Apple "); DataTable dt2 = new DataTable(); dt2.Columns.Add("ID ", typeof(int)); dt2.Columns.Add("Name ", typeof(string)); dt2.Rows.Add(1, "Age "); dt2.Rows.Add(2, "Apple "); DataTable dt3 = new DataTable(); dt3.Columns.Add("ID ", typeof(int)); dt3.Columns.Add("Name ", typeof(string)); dt3.Rows.Add(1, "Age "); dt3.Rows.Add(2, "Apple "); dtnew=dt1.Clone(); dtnew.Merge(dt1); dtnew.Merge(dt2); dtnew.Merge(dt3); dtnew.Merge(dt4);
DataTable dt1 = new DataTable(); dt1.Columns.Add("ID ", typeof(int)); dt1.Columns.Add("Name ", typeof(string)); dt1.PrimaryKey = new DataColumn[] { dt1.Columns[0] }; dt1.Rows.Add(1, "Age "); dt1.Rows.Add(2, "Apple "); dt1.Rows.Add(3, "Orange "); DataTable dt2 = new DataTable(); dt2.Columns.Add("ID ", typeof(int)); dt2.Columns.Add("Price ", typeof(decimal)); dt2.PrimaryKey = new DataColumn[] { dt2.Columns[0] }; dt2.Rows.Add(1, 10); //dt2.Rows.Add(2, 6); dt2.Rows.Add(3, 7); DataTable dt3 = dt1.Copy(); dt3.Merge(dt2);
16,722
社区成员
110,526
社区内容
加载中
试试用AI创作助手写篇文章吧