By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

how to fill typed dataset with joined queries ?

P: n/a
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.

Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.