Dear all:
Im using DataSet for my C# Windows App. My app has just a DataSet including more than 20 different table. But each form use just 1 or 2 tables of that (Max 5).
sence
Now I wanna ask for ur idea, since there is no form witch use all these 20 table, should I have separate DataSet?! or it doesnt sense?!
FOR example: my form1 is useing [u]Table1, Table2, Table3</u>
& form2 is useing [u]Table4, Table5</u>.
Should I have [u]DataSet1 for form1</u> & [u]DataSet1 for form2</u>?!

Tnx in Advance.

Always:),
Hovik Melkomian.

__________________
Always,
Hovik Melkomian.

It would certainly make sense that if all the tables do not HAVE to live together, then they shouldn't. Why load 15 tables in a dataset if you don't use them? However, concidering that you are writing a windows application, you might not need to worry about constant reloading of a dataset from a file (assuming this is how you are doing it). Some factors to consider are: how are you loading this dataset (from a file, SQL)? How often are you REloading the dataset? If you don't reload the dataset during the lifetime of the application you might need to worry about loading the whole thing. In fact, it might be better for you application to load the whole thing first on program load and have the data available immediately when you need it.

Peter
-------------------------
Work smarter, not harder

Dear Peter tnx for ur responce, but I would like to add some info to my scenario:
As I said my DataSet has more than 20 table but I dont use them in my all forms. As I said I just fill & update each table witch depend to form.
Yes, tables might update every min. specially 3-5 main tables, since App has about 30-50 users, & Im using MS-SQL 2000 as my DB.

Always:),
Hovik Melkomian.

Dear Peter:
So u suggest to make DataSet for each form in App. Isnt it?!

Always:),
Hovik Melkomian.