Multiple tables in a dataset or just one?

[qwert231]

I am wondering about performance/speed and ease of programming/use.

I know you can have multiple tables in a dataset. Programatically you can use each table.
But a DataAdapter only seems to be able to use one Query/Result set of data.
Should I (since I have different groups of data I want to use) build multiple DataAdapter/DataSet pairs, or can I have multiple DataAdapters fill the same Dataset?

Thoughts.

 

[Corran007]

You can have multiple dataadapters fill a dataset. Currently have 5 in one dataset and notice no performance problems.

As to grouping, i would group things that are similiar. But i really havnt seen anything about it other than what your individual preference is. In Mine, I grouped by thier function if they will span multiple pages or all together if they are just one page. But i just do that so they make more sense in my project explorer and i can figure out what data is in what dataset based on the name.

 

[qwert231]

K, thanx, I feel better now.