memory..

From: pvp (anonymous_at_discussions.microsoft.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 06:21:04 -0700

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

Relevant Pages

  • Re: releasing memory...
    ... > command objects. ... > I have a procedure to populate dataset.I call dispose on all ... > objects after dataset is populate and close the connection. ...
    (microsoft.public.dotnet.languages.vb)
  • releasing memory...
    ... command objects. ... I have a procedure to populate dataset.I call dispose on all objects ... I see that the application still uses connection on sqlserver(I ...
    (microsoft.public.dotnet.languages.vb)
  • releasing memory ...
    ... command objects. ... I have a procedure to populate dataset.I call dispose on all objects ... I see that the application still uses connection on sqlserver(I ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Performance better with DataSet or DataReader or ...???
    ... If you were to use a DataReader to populate a DataTable ... One may argue that you'd have to do that anyway since if the data structure ... So in any case I wasn't planning to leave an open connection to ... >> public class MyClass ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Reusable Database connection for Combo Box, list box and other query
    ... List boxes. ... languages you have an abstraction to the database where you can pass ... Here is code to populate one of my Combo boxes. ... I have one more and I have to repeat my Connection code each time: ...
    (microsoft.public.excel)