如何将一个dataTable中指定的列拷贝到另外一个dataTable中

Question

如题所述

Answer 1

DataTable newdt = new DataTable();
DataSet da = new DataSet();
foreach (DataColumn dc in da.Tables[0].Columns)
{
newdt.Columns.Add(dc.ColumnName,dc.DataType);
}
DataRow drNew=newdt.NewRow();
foreach (DataColumn dc in da.Tables[0].Columns)
{

drNew[dc.ColumnName]=da.Tables[0].Rows[i][dc.ColumnName].ToString();

}
newdt.Rows.Add(drNew);

newdt.AcceptChanges();