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

Fill dataset with multiple tables

P: n/a
How to fill dataset with multiple tables and set their relaition?
Can I get the relations from the SQL server?
Also I would like to do it using stored procedures.

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


P: n/a
Hi Nikolay
You can just create tables fill them with data and add them to the tables
collection of your dataset . you can also create a Select command for you
dataAdapter that select more than one table and then use that fill method
of that dataAdapter against you dataset . this simply will fill the
dataset with all the table that you selected. If you want to do it with a
SP you can create that stored procedure that select more than one table.
then set the selectCommand type of the adapter to a SP and make it
reference your SP then use the fill method to fill your set will all the
tables. You can also create a typed set then from server explorer drag
all your database table to create a schema or the relational model of your
database with all its constrains
Hope this helps

Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.