Merging DataTable(s) Column by Column

Question

I want to merge two or more DataTables Colum by Column. I am developing C# Windows Application. My use case is below:

I have empty data grid in my application.
user will drag and drop one column from available column list box into data grid. The data grid will start displaying data for that column.
Now, I will drag another column into data grid and now grid should get populated data of two columns.
This will repeat till user feels that he has dropped all necessary columns.

What is best way to do this? Is there any performance hits with large number of rows typically 1 million?

Please help.

Thanks, Omky

Arsen Mkrtchyan · Accepted Answer · 2011-01-29 07:23:03Z

1

use DataTable.Merge if you really want to marge datasets

keep empty datatable with id, and each time user add new column, marge first datatable with new datatable containing id and new column

But in your case, I think it will be better to bind full datatable to grid, and change visible of or add remove datagrid column depending user action

edited Jan 29, 2011 at 7:23

answered Jan 29, 2011 at 7:15

Arsen Mkrtchyan

50.9k33 gold badges155 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Omkar Over a year ago

Yes that is true!!! but my requirement is I want to fetch the data for that particular column when user drag and drop the column. BTW is there any constraint that merging should be based upon primary keys of two tables?

Arsen Mkrtchyan Over a year ago

yes, for margin constraint is needed, see msdn.microsoft.com/en-us/library/fk68ew7b.aspx example, you can add column to that datatable,and fill them from first one manually

Collectives™ on Stack Overflow

Merging DataTable(s) Column by Column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related