How do you combine two datatable and then display it in one gridview in vb?

Question

this is the code for merging the two datatable : dt_merged.Merge(dt)

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

In C# is: (Just convert to VB Syntax)

dt1 = new DataTable();
dt2 = new DataTable();
dt1.Merge(dt2);

grid.DataSource = dt1;

Replace the dt1 and dt2 by loading from your database.

This might be duplicated, you can check in this link: Merging 2 data tables in vb.net

edited May 23 '17 at 12:13

Community

answered Jun 23 '15 at 06:24

Roger Oliveira

1

i tried this but this error comes up Both DataSource and DataSourceID are defined. i cant seem to figure out how to combine both – ANNE Jun 23 '15 at 06:29
@ANNE try this link: http://www.codeproject.com/Questions/255064/Both-DataSource-and-DataSourceID-are-defined-on-Gr – Roger Oliveira Jun 23 '15 at 06:46
@ANNE the link above has a solution for you problem with examples. – Roger Oliveira Jun 23 '15 at 06:48

1 Answers1