2 tables in one DataGrid

[MRW]

Hello!

I'm looking for an easy way to take 2 tables with different, but
similar, structures and combining them into one DataGrid, with a
hyperlink on each record to send you to a page depending on what table
it's from.

Is there an easy way to at least merge the two tables into one to
display the DataGrid?

Thanks for any help!

Oh yes... I'm using VB

 

[Guest]

Are you talking about DataTable objects, if so you could add the two
DataTables to a DataSet and then join them using a relationship. You could
then create the hyperlinks and send the user wherever you want by using
TemplateFields and the <%# bind("somefield") %> syntax.

 

[sirfunusa]

Use the SQL UNION Keyword to combine the two tables into one SELECT
statement