The number of Datasets

Question

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...

Andrzej Wegierski · Answer

Thx

metos · Answer

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.

Andrzej Wegierski · Answer

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?

metos · Answer

I need it to represent data in GridControl using master/detail...

Andrzej Wegierski · Answer

Typed datasets are very huge. I use them only to CristalReports.

metos · Answer

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

Andrzej Wegierski · Answer

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.