I have a DataSet with two tables, Orders and Products. I would like to create a new table that is a JOIN of these two tables on Orders.ProductID = Products.ProductID and use the resulting table as the DataSource for a GridView control. I am new to DataSets and I suspect this is a very simple problem, but I can't figure it out. Any help would be greatly appreciated. Thanks!
...
Go to the complete details ...