datasets

[Goon]

I have a dataset with two datatables, each from different
datasources. The two tables are related by a datarelation. How would
I databind a gridview to something equal to "SELECT * FROM table1
JOIN table2.."

 

[Peter Bromberg [C# MVP]]

Your post doesn't provide enough information to be sure about what the
intended use is. You can bind such a DataSet to, for example, a child grid
based on the DataRelation, but that doesn't sound like what you want.
Actually, it sounds more like UNION. The easiest way to do this is at the
server - using things like linked tables or for SQL Server, OpenRowset.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short Urls & more: http://ittyurl.net

 

[Goon]

Can I make a new datatable that consists of the join of the other two
datatables?

Basically I have table1 from SqlServer, table2 from odbc to a file.