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

Answer 1

We can put fields on report dynamically. For it we have to put formula-fields on report on design time.
We can put fields value from database in formula-fields in our c# coding.

For example AttendenceReport is crystal report having formula-field "status".

 AttendenceReport objAttendenceReport=new AttendenceReport();
//{AttendenceTable.Status} values coming from //database                               objAttendenceReport.DataDefinition.FormulaFields["Status"].Text = "{AttendenceTable.Status}";