>>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.
Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham