How to Merge Two Data Table in One DataTable in C#

Question

Dear, I want to Merge Two or Three DataTable in one DataTable with one Row but problem is i am trying below code for merge its working but data is coming like below. dtPOS.Merge(dtTGT,false,MissingSchemaAction.Add); dtPDA.Merge(dtIPOD,false,MissingSchemaAction.Add); dtAll.Merge(dtPOS, false, MissingSchemaAction.Add); dtAll.Merge(dtPDA, false, MissingSchemaAction.Add); dtAll.AcceptChanges(); dataGridView7.DataSource = dtAll; Result:

Ravishankar N · Answer

Hi Feroz Khan, I hope this will helps you https://www.c-sharpcorner.com/UploadFile/b182bf/how-to-add-two-datatable-in-single-datatable-in-C-Sharp/

Rajneesh Chaubey · Answer

Hi, You want data like this? If so then you have to use inner join from backend and then get your data into datatable. Or you have to it like this: static void Main( string [] args) { Program p = new Program(); DataTable dt1= p.Get1(); DataTable dt2 = p.Get2(); DataTable dt3 = p.Get3(dt1, dt2); } public DataTable Get1() { DataTable dt1 = new DataTable(); dt1.Columns.Add( "Name" ); dt1.Rows.Add( "IBM-78" ); dt1.Rows.Add( "IBM-78" ); dt1.Rows.Add( "TOSHIBA" ); dt1.Rows.Add( "TOSHIBA" ); return dt1; } public DataTable Get2() { DataTable dt2 = new DataTable(); dt2.Columns.Add( "Name1" ); dt2.Rows.Add( "Motorola" ); dt2.Rows.Add( "Motorola" ); return dt2; } public DataTable Get3(DataTable dt1,DataTable dt2) { dt1.Columns.Add( "Name1" ); for ( int i = 0; i { dt1.Rows[i][ "Name1" ] = dt2.Rows[i][ "Name1" ]; } return dt1; } Hope it helps. Thanks.

Packiaraj Santhiyagu · Answer

Hi try this dtAll = dtOne.Copy(); dtAll.Merge(dtTwo)

James Axsom · Answer

HI Feroz, Use DataTabe.Merge(DataTable) not DataTable.Merge(DataTable, bool, MissingSchemaAction.Add). Here is what is happen when you used Missing Schema Action. The merge process treats the column in the source tables as not existing in the target table. dtAll adds dtPOS’s column and dtAll adds dtPDA’s column. Once the columns are added it merges the rows per the new column created, thus you get rows where there are null values in the added columns in each row. Because dtPOS, dtPDA and dtALL have similar or same data schema (i.e. one column with varchar, nvarchar or string type) then use the DataTable.Merge(DataTable). This will append rows into a single column. You can do something like this instead of daisy chaining tables: dtAll.Merge(dtTGT); dtAll.Merge(dtPOD); dtAll.AcceptChanges(); dataGridView.DataSource = dtAll; Hope this helps.