Populate Dataset from a View in SQL Server

[Kurzo]

How would you populate a dataset(or some other type of collection) from a view in SQL Server?

I want to be able to show records in a list view that pull data from a number of related tables.

I know how to poplulate a dataset from one table, because my object is based in the table collection and populated through a stored procedure.

How can I have a collection that contains records from many tables?

I'm not sure if I am making any sence or not, so please ask me to be more specific, if neccessary.

[Edneeis]

You can use a view exactly like a table, but it will return the view results as a table not as seperate tables. If you want to fill a dataset with multiple tables you'll need to use multiple queries or multiple commands. You can either keep changing the select query of a dataadapter and refilling the dataset with new tables or you can just put multiple queries in the same command, just seperate them with a semicolon.