I am learning how to use .Net and have a question regarding efficiency of the code.
As i understand it i can create a series of datasets (basically in memory tables) from the database.
What is the best way to code a page where i have a number of different values from different parts of my database? Some queries might need to include joins between tables but in other cases i could just run discreet queries on a single table. Should i create a large number of different data sets and call each one with the relevant server control or should i create a single data set and manipulate the data within it.
Any info on this ... and tips, tricks, best practice... really to move me forward beyond just connecting to a DB and returning some rows from a query would be gratefully accepted