复制DataTable的到新的DataTable

DataTable数据复制技术详解

最新推荐文章于 2025-03-18 23:57:34 发布

原创最新推荐文章于 2025-03-18 23:57:34 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string

一.

DataTable.Copy();

二.

/// <summary> /// 复制datatable /// </summary> /// <param name="copydt">数据源</param> /// <param name="tablename">新datatable名称</param> /// <returns>复制后的datatable</returns> private DataTable copydatatable(DataTable copydt, string tablename) { DataTable dt = new DataTable(tablename); foreach (DataColumn columm in copydt.Columns) { dt.Columns.Add(columm.ColumnName, columm.DataType); } foreach (DataRow row in copydt.Rows) { dt.BeginInit(); dt.ImportRow(row); dt.EndInit(); } return dt; } /// <summary> /// 复制datatable /// </summary> /// <param name="copydt">数据源</param> /// <param name="tablename">新datatable名称</param> /// <returns>复制后的datatable</returns> private DataTable copydatatable(DataTable copydt) { //DataTable dt = new DataTable(tablename); foreach (DataColumn columm in copydt.Columns) { NewData.Columns.Add(columm.ColumnName, columm.DataType); } foreach (DataRow row in copydt.Rows) { NewData.BeginInit(); NewData.ImportRow(row); NewData.EndInit(); } return NewData; }