2 datasets into 1 datagrid

[Mike Fellows]

I have 2 datasets that i need to put into 1 datagrid

each dataset has the same amount of columns and contains the same type of
data
but column names are different (though i know how to rename them if this is
an issue)

i need to insert dataset1 into the datagrid (not a problem) but how can i
then append
dataset2 onto my datagrid

i then need to sort the datagrid by one of the columns

thanks in advance

Mike Fellows

 

[AlexS]

You can create joined dataset before binding to datagrid. Combine both into
one using SQL (union) or whatever you use now.

HTH
Alex