>>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.
Use:

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

which is pretty much the equivalent of:

           {
                SqlDataAdapter oDataAdapter = new SqlDataAdapter(sqlSelectString, connectionString);
                try
                {
                    dsDataSet = new DataSet();
                    oDataAdapter.Fill(dsDataSet);
                }
                finally
                {
                    if (oDataAdapter != null)
                        oDataAdapter.Dispose();
                }
            }

Note that generally you should *not* declare the IDisposable (in this case oDataAdapter) outside the using statement. If you do that it will remain in scope even though it has been disposed.