The number of Datasets

m3lles

How many datasets do we really need to use in a database application..can we just create one big dataset to hold the data we need or we need to localize the datasets by creating new instances for every new sets of table..thanks.. I also need links to database programming in C## and also report generations...

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski22y ago
Thx
0
metos22y ago
In my case, dataset represents all the database, but I'm downloading data only when master row expanding. Ofcourse, highest level of the datagrid - result of the query runned by the user. Besides I don't know what it would be. So I have one table in dataset representing top level of the datagrid. Some fields are obligatory (foreign keys) but they are not represented in datagrid.
0
Andrzej Wegierski22y ago
Interesting. I use my own master-detail using some DataGrids with one table inside and row filters in positions (DataGrid with some tables and master-detail inside isn't readable for our clients). What are the advantages of using typed datasets in DataGrid with master-detail?
0
metos22y ago
I need it to represent data in GridControl using master/detail...
0
Andrzej Wegierski22y ago
Typed datasets are very huge. I use them only to CristalReports.
0
metos22y ago
I'm using typed DataSet. Each time I need any data from DB I'm reading it in instance of this class. I have just 2 objects for now. Project is great
0
Andrzej Wegierski22y ago
I use one dataset for a menu position (form) in my application. All extra information I set into extended properties of dataset or datatables. Generally it is clear to use as a parameter. If Your algorithms need to use few datasets it's proper too.
0