INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I always seem to find what I need in previous threads without starting my own. I have started a couple but that's it..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > C# (C sharp): Microsoft Forum

ADO.Net - Populate dataset with sql server tables and relations

Read More Threads Like This One

spangeman (Programmer)

15 Sep 10 17:34

Hi

Is there an easy way of populating an ADO dataset with a set of tables (and their data) from SQL Server and then all their relations based on the Foreign Key constraints defined on the SQL server database.

All examples I have seen online when googling show the relations being coded one by one in C# but I want them to be taken automatically from the relations that already exist on the tables in SQL server as FK constraints.

I am using c# under .NET Framework 4

I want to do something like......

1. Declare dataset.
2. List tables I am interested in and add these to the dataset with all of their data.
3. Add all relations based on FK Constraints in SQL Server DB.

jmeckley (Programmer)

16 Sep 10 9:40

create a strongly typed dataset to reflect the information you need.

I don't see much value in duplicating the schema in memory though. This only applies to simple forms-over-data UIs. anything beyond that and you are working with subsets of data in a context specific way. the context may not align 1:1 with the database schema.

Jason Meckley
Programmer

FAQ855-7190: Database Connection Management
FAQ732-7259: Keeping the UI responsive

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To C# (C sharp): Microsoft