General question regarding using dataset to retrieve data from SQL Database -versus- Retrieving data directly from SQL database.
I have a loop function that will traverse multiple checkboxlist controls. For every checkedbox that is equal to true, data is retrieved from the database.
Is it better to use a data adapter to fill a dataset with the entire table and read the data from the Dataset?
Use sql command to retrieve the data directly every time the loop finds checkbox = true?
What are the pros and cons?