473,326 Members | 2,148 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

releasing memory...

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

Nov 20 '05 #1
4 1012
"paruchurip" <pa********@hotmail-dot-com.no-spam.invalid> schrieb
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

Nov 20 '05 #2

Provided today By Armin

http://msdn.microsoft.com/library/en...management.asp

And is of course also for ADONET.

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

Cor
Nov 20 '05 #3
System.GC.WaitForPendingFinalizers()
System.GC.Collect()
paruchurip wrote:
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


Nov 20 '05 #4
Now I know why posts are written upside down.

Armin

"Arcer P" <No@Spam.Com> schrieb
System.GC.WaitForPendingFinalizers()
System.GC.Collect()
paruchurip wrote:
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

Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: lebo | last post by:
Hi I'm trying to understand how Python handles memory usage and dynamic object loading and unloading. Problem to solve? Build a very low memory footprint (non-GUI) Python application for...
7
by: trialproduct2004 | last post by:
Hi all I am having application in c# where i am loading one table of database into dataset. My table is of large size. so whenever i am loading that into dataset my memory size is getting...
2
by: M.Ob | last post by:
Hello... I am having issues with my asp.net apps not releasing memory. The memory usage for the process w3p.exe continues to grow to it's allowable limit and does not drop until the app pool is...
8
by: Sean | last post by:
I have a service that is pulling alot of records from a SQL Server table in a DataSet. This process takes up alot of memory, which is to be expected. But when the process is finished, I am clearing...
5
by: Mark Rae | last post by:
Hi, I'm encountering a strange phenomenon whereby a DataSet object is not releasing its memory when it's being disposed and/or set to Nothing. It is part of a Windows service written in VB.NET...
12
by: iker.arizmendi | last post by:
Is there any way to get Python to release memory back to the C allocator? I'm currently running a script that goes through the following steps: 1) Creates a very large number of Python objects...
3
by: ib | last post by:
ICloneable::Clone returns a new instance of the object being cloned. However, it seems possible that the garbage collector could release this memory before the calling function receives a reference...
5
by: Ian Boyd | last post by:
Customer is running a load test against a websphere application that uses DB2. While the load test is running the memory usage of DB2 climbs from x up to y. When the load test ends, the memory...
1
by: amollokhande1 | last post by:
Hi All, We have ASP.Net based content management web application. We are performing lots of XML based operations like setting the innerxml, loading the xml, string replace operations on XML etc....
2
by: enggwaqas | last post by:
Hi guys, I have a memory problem in my vb.net application. It's actually a point of sales system, which must be keep running the whole day. The problem is: application is not releasing any memory...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.