multiple data sets
Posted on 2005-04-21
Another one for you...
As i understand there are four main objects needed to connect to a DB
which of these can be reused across all queries and resulting datasets and which do i need to create for each separate SQL query
I had assumed that i only needed to do the connection once -but it only works with multiple connections... so does this mean that for every connection i make to the DB i need to go through setting up and populating each of these objects? isn't that really inefficient? it certainly seems it from the amount of code i am going to have to generate...
any tips or comments - am i going about this completely the wrong way?