private void CopyDataTable(DataTable myDataTable){ // Create an object variable for the copy. DataTable copyDataTable; copyDataTable = myDataTable.Copy(); // Insert code to work with the copy. }
insert into NewTable select * from OldTable--如果结构完全一样就行
// Create an object variable for the copy.
DataTable copyDataTable;
copyDataTable = myDataTable.Copy();
// Insert code to work with the copy.
}
select * from OldTable--如果结构完全一样就行
DataRow dr2 = dataset2.table2.NewRow();
dr2.ItemArray = dr.ItemArray;
dataset2.table2.Rows.Add(dr2);
tb_new.key1=tb.key1 and
tb_new.key2=tb.key2
...................