Re: memory..

From: Miha Markic [MVP C#] (miha)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 15:47:02 +0200

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
"pvp" <anonymous@discussions.microsoft.com> wrote in message
news:D89CBDD9-EFB4-41F7-BC15-4539E3CB023C@microsoft.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)
> 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: Login prompt keeps popping up- Outlook 2003
    ... It also seems to be normal behaviour when the program is unable to connect ... to the POP3 server. ... We have tried recreating the Outlook profiles, ... question are at remote sites over a fiber connection. ...
    (microsoft.public.outlook)
  • Re: Problem with using ConnectionManager API on Win CE (pocket pc)
    ... normal behaviour for the ConnectionManager after establishing a ... so if you loose your connection, ... retVal = ConnMgrEstablishConnectionSyncgives a cryptival error code ... > Hi Kerstin, ...
    (microsoft.public.windowsce.app.development)
  • 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)
  • Re: bind data to textboxes
    ... >> I haven't been discussing connection strings, ... in order to populate some text boxes. ... >> Public Sub New ... >> Public Sub LoadData ...
    (microsoft.public.dotnet.framework.aspnet)