Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to dispose a DataSet
Message
From
08/05/2005 20:50:54
 
 
To
All
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
How to dispose a DataSet
Miscellaneous
Thread ID:
01012057
Message ID:
01012057
Views:
67
Hi Guys,

I created a simple program that has a main form that has a button to call a dialog form. In the dialog form, I created a dataset that handles around 3000 records.

The programs works fine during the first few hours of usage. But as the users continue to click the button, the system becomes slower. I noticed that everytime I call the fill method of the DataAdapter, the memory being used by the system goes up significantly.

I tried to to close and dispose the connection and call the dispose method of the dialog form and the dataset in it but it has no effect. The memory that was used was not freed up even if the dialog form was already closed and disposed.

Any idea on how to fix this problem?

Thanks in advance...
Music Rocks www.musicreserve.blogspot.com
Success is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.
Next
Reply
Map
View

Click here to load this message in the networking platform