releasing memory...

[paruchurip]

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 suggest

 

[Armin Zingler]

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 suggest

Why not ask in the ADO.NET group?
microsoft.public.dotnet.framework.adonet


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

 

[Cor Ligthert]

Provided today By Armin

http://msdn.microsoft.com/library/en-us/cpguide/html/cpconautomaticmemorymanagement.asp

And is of course also for ADONET.

Be aware that checking memory by using the taskmanager gives unpredictable
results

Cor

 

[Arcer P]

System.GC.WaitForPendingFinalizers()
System.GC.Collect()

 

[Armin Zingler]

Now I know why posts are written upside down.

Armin