how to fill typed dataset with joined queries ?

[Ersin Gençtürk]

hi ,

I have 2 tables , tUser and tUserRole and I have a query like :

select * from tUser inner join tUserRole on tUserRole.UserId=tUser.UserId
where tUser.UserId=1

this will return a user with associated roles.

Also I have a typed dataset with two tables inside : tUser and tUserRole

how can I use this typed dataset when I use the query above ? What is the
expected behaviour ? Should I fill
two tables of the dataset with seperate queries like :

select * from tUser where UserId=1
select * from tUserRole where UserId=1

or is there any other better way ? I wonder because there are more complex
joined queries from database.I have to map them to the dataset.

[Eliyahu Goldin]

You need to make your mind what you want. If you want to work against 2
tables, you have to run 2 separate queries, like you write. You can't fill 2
tables from one select query. You can do it with a stored procedure or a
batch query that return 2 recordsets.

You may decide that you need only one table. For example, if you want to
show both user and user role fields in the same grid. Than you should make
just one table that will contain fields from the joined select.

Eliyahu

"Ersin Gençtürk" <ers[spam]@gencturk.org> wrote in message
news:ef**************@TK2MSFTNGP15.phx.gbl...

hi ,

I have 2 tables , tUser and tUserRole and I have a query like :

select * from tUser inner join tUserRole on tUserRole.UserId=tUser.UserId
where tUser.UserId=1

this will return a user with associated roles.

Also I have a typed dataset with two tables inside : tUser and tUserRole

how can I use this typed dataset when I use the query above ? What is the
expected behaviour ? Should I fill
two tables of the dataset with seperate queries like :

select * from tUser where UserId=1
select * from tUserRole where UserId=1

or is there any other better way ? I wonder because there are more complex
joined queries from database.I have to map them to the dataset.