Closing Connection in CLASS

Hi,

I populate a drop down list from a database. My getValues function is in a class, that I call, which is where i Open my connection and the dataReader.

I then return the dataReader value, and binding the data to the drop down.

I cannot close the connection in the class function(before return), as I will not be able to bind the data to the drop down later.

what are the usual procedures with this?

How do I make sure all my connections are closed when I'm done with that query?


Thank you

You would normally populate some form of Collection object in your GetValues function and return that instead of the DataReader.

That way you can close up all your db connections etc. before returning the collection and using that as your datasource.

Something like a Dictionary or Hashtable. You loop through the datareader, populating your collection object, close up the db connection and return the object.

Hope that helps.

yes it does. thank you!