Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to dispose a DataSet
Message
De
08/05/2005 20:50:54
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
How to dispose a DataSet
Divers
Thread ID:
01012057
Message ID:
01012057
Vues:
69
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform