Hi,

I'm new to ADO.NET and I have a question about working with Datasets.

I'm writing a program with Visual Studio 2003 and SQL Server 2000. For this program I need to visualize and administrate (CRUD-operations) the information about USERS in a Windows Form. In the underlying database , this information has been put in 4 related tables : table 1 represents Person (with his name and language); table 2 represents UserIds (because each Person can have 1 or many UserIds); table 3 represents a connection between this UserID and the possible Business Entity('s) where he works and, at last, table 4 holds the names for the Business Entity.
Each table uses a single primary key and a timestamp-field has been set for the concurrency-solution. (Its a generic databasemodel that has been given to me as the basis for the program).

I thought using a dataset to create a view on a Windows Form and subsequent changes in the underlying tables would be efficient. But, I see some problems. Using a Datagrid, it seems I can't visualise all the relevant information from these 4 tables in only one line. For each table that is in the dataset a subsequent +sign resides on the left.
Is there a way to create a view in this dataset that puts the relvant information from these 4 tables in only 1 line?

I can also use a stored procedure to obtain the relevant information from those 4 tables and put this in the dataset -> datagrid. This works, but then I have not the ability to use the CRUD-ability in the underlying dataset to create updates.

What is the best approach in such a scenario and have you any documentation (articles or examples) on this subject ?

Thans in advance,
edes