7
Answers

The number of Datasets

m3lles

m3lles

20y
2k
1
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...
Answers (7)
0
Andrzej Wegierski

Andrzej Wegierski

NA 705 0 20y
Thx
0
metos

metos

NA 27 0 20y
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 Wegierski

Andrzej Wegierski

NA 705 0 20y
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
metos

metos

NA 27 0 20y
I need it to represent data in GridControl using master/detail...
0
Andrzej Wegierski

Andrzej Wegierski

NA 705 0 20y
Typed datasets are very huge. I use them only to CristalReports.
0
metos

metos

NA 27 0 20y
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 Wegierski

Andrzej Wegierski

NA 705 0 20y
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.