memory..

[Guest]

I wrote a ado.net application that uses dataadapter,connection and command objects
I have a procedure to populate dataset.I call dispose on all objects after dataset is populate and close the connection
I see that the application still uses connection on sqlserver(I verified this by executing sp_who on sqlserver
application dosen't release connection untill I close the form or end the application
I tried calling gc.collect but this did not work
What is work around for this problem
Please sugges

 

[Miha Markic [MVP C#]]

Hi,

This is normal behaviour. By default at least one connection is open within
connection pool.
You might change the behaviour by changing connectionstring.
See
Connection Pooling for the .NET Framework Data Provider for SQL Server
..net help topic.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

I wrote a ado.net application that uses dataadapter,connection and command objects.
I have a procedure to populate dataset.I call dispose on all objects after

dataset is populate and close the connection.

I see that the application still uses connection on sqlserver(I verified

this by executing sp_who on sqlserver)