while i was writing a code to access data from database to dataset i realized that that once the dataset is created it resides in the memory of the system till the time application is running. sometime we dont need the dataset any more after using it i think if this is the case then we must destroy the dataset to release the system memory resources how we can destroy a dataset when it is not required any more

dinesh Rana

__________________
dinesh Rana

hi ranakdinesh
 I think dispose method of dataset will do that,check it

Dim ds As New DataSet
ds.Dispose()

try it

firstly what kind of application you mean?

(supposed it's a windows app)
if you declared your dataset globally,it should resides in the memory

if you declared it locally it would be disposed automatically by the GC in the best possible time

you would need dispose method(IDisposable) when you have an unmanaged resource

(in some managed objects(like pen) we call Dispose method as soon as possible)

_____________
Mehdi.
software student.

any way if your DataSet contains huge info and you don't need it anymore just earase the info(GC is responsible for disposing not you)

theDataSet.Clear();

_____________
Mehdi.
software student.