merge data table from one to another

Question

i have two data table i want to copy one of data table column data copy into second data table with already existing row c#

Mukesh Kumar · Answer

Hi, First Way The datatype in the same columns name must be equals. dataTable1.Merge(dataTable2); After that the result is: dataTable1 = dataTable1 + dataTable2 Second Way DataTable table1 = GetData(); //get Rows in 1st Data Table DataTable table2 = GetData(); //get Rows in 2nd Data Table foreach (DataRow item in table2.Rows) //Iterate through each row of 2nd data table { table1.ImportRow(item); //Import the row in 1st data table } http://www.c-sharpcorner.com/UploadFile/0c1bb2/merging-multiple-datatables-into-single-datatable-using-asp/ Hope this will help you. thanks

Jignesh Trivedi · Answer

Hi, To do this we have two option use datatable.merge Please refer https://msdn.microsoft.com/en-us/library/fk68ew7b(v=vs.110).aspx else copy one by one rows hope this will help you.

Kiran K · Answer

I am trying to type a question, why I can't post a question?

merge data table from one to another

Answers (3)