A single select statement as you described returns 1 result set - which
corresponds to a DataTable in a dataset. A DataTable is not a direct
relation to a database table, but rather a result set (which could be select
* from table1 - but doesn't have to be).
Quote:> I have created a strongly typed dataset with two tables. I want to
> populate the dataset with a select command (select x, x, x from
> table1, table2 where xx) - how do I fill the dataset using the
I'm using a strongly typed dataset. When iterating thru the rows
collection, i would prefer to use the strongly typed row data type,
instead of using system.data.datarow. It doesn't seem to be available
from intellisense, but it compiles correctly and it is a public class.
Is this a vs.net bug?