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?
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…