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

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.

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/ 

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: