Datasets - how to?

[John]

Hi

I have a clients table and a suppliers table. Both link to a single contacts
table as all contacts (clients or suppliers) reside in it. I have two
questions;

1. Should I create a single dataset definition for all three tables or two
separate definitions one each for client & contacts and suppliers and
contacts?

2. What is the procedure to create this dataset definition so I can use it
in my code? I believe this is what is called a typed dataset?

Thanks

Regards

 

[William Ryan]

If I understand you correctly, create three seperate datatables all in the
same DataSet. Relate them using a DataRelation object (google on
DataRelation ADO.NET for examples). Typed DataSets rock. Think of a
DataSet as you do a DataBase. A DB can talk to other DB's but it's
comprised of Tables/Views Etc. This is a bit of an oversimplification, but
essentially ADO.NET makes this same abstraction, just on the desktop.

Not exaclty sure about the 'definitions' thing, but I think I got the jist
of it. Anyway, I'll be around for a while if I misunderstood or you have
any questions.

Cheers,

Bill