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