>First, thank you for the sample code. A couple of things I don't understand. Why in your code nConnectionString is numeric (I presume that prefix n stands for numeric)? What is the oCommand?
>
>Here is the segment of my code where I would like to apply your (connection pool) approach:
>
>

>   string sqlSelectString = "select * from mytable where 1=1";
>   SqlDataAdapter oDataAdapter = new SqlDataAdapter( sqlSelectString, connectionString);
>   DataSet dsDataSet = new DataSet();
>   oDataAdapter.Fill( dsDataSet);
>

>
>What is not clear is how do I create data adapter (oDataAdapter) other than how it is in my code. Again, thank you.

I have some specific items in that sample that are related to my framework.

Basically, what you have in there does it. It's all in the background. If that command works, then, all is fine.