Query Method in Database Class

I am writting a database wrapper class (Heres most of the class) I have the db_open, db_state and db_close methods working properly...but now I want to create a db_query and a db_execute methods. I want the db_query to take 2 parameters, the first being a string (possible sql statement or stored procedure name) and the 2nd is a boolean value as to whether or not the first parameter is a stored procedure. But I am somewhat confused as to how to return the data?? I don't want to used a Dataset, because I don't want the recordset to be disconnected, so it is down to either a DataAdapter or a DataReader...obviously just to query (SELECT) records from the database the DataReader would be fine, but how to return the data to the user via a method call???

I have seen methods like this

Code:

---

public Dataset blah(string blah)

---

but haven't seen anything regarding how to do it with a DataAdapter or DataReader.

Thanks!

Tadaaa

It's the Microsoft Data Access Application Block - from the page blurb:

Quote:

---

The Data Access Application Block encapsulates performance and resource management best practices and can easily be used as a building block in your own .NET application. If you use it, you will reduce the amount of custom code you need to create, test and maintain.

---

If I remember correctly, it uses DataReader exclusively.

It doesn't just use the datareader, it has ExecuteReader, ExecuteDataSet, ExecuteNonQuery, and ExecuteScaler functions. All of which are overloaded to provide the most functionality possible.

I just want to add my vote for the Data Access Block. If you are accessing SQL Server, you really need to use this. It helps so much IMO.

I think that they are updating it, or going to be updating it soon so you can call FillDataSet along with other features. Something to look out for.

There is also a exception management block:
http://msdn.microsoft.com/library/de...ServiceAgg.asp

And others:
http://msdn.microsoft.com/library/de...ServiceAgg.asp
http://msdn.microsoft.com/library/de...l/PAIBlock.asp
http://msdn.microsoft.com/library/de...chingBlock.asp
http://msdn.microsoft.com/library/de.../html/cmab.asp
http://msdn.microsoft.com/library/de...ml/updater.asp
http://msdn.microsoft.com/library/de...a/html/uip.asp

Hey, thanks for the links hellswraith!