adp.Fill method pooling issues
-
I am pretty much exclusively using SqlDataAdapter.Fill method.... I am getting the dreaded timeout connection pool limit exceeded. MSDN tells me I dont have to exclusively open and close my connections. Yet! under heavy use, i'm getting these errors in my application. What can I do to make sure these connections are getting closed using this method.
-
I am pretty much exclusively using SqlDataAdapter.Fill method.... I am getting the dreaded timeout connection pool limit exceeded. MSDN tells me I dont have to exclusively open and close my connections. Yet! under heavy use, i'm getting these errors in my application. What can I do to make sure these connections are getting closed using this method.
I use
finallyblock to make sure that clean up is performed Farhan Noor Qureshi if (this == this) thow this;