Free up memory used by a dataset
Posted on 2004-08-18
DataSet ds = new DataSet();
OleDbAdapter da = new OleDbAdapter(sqltext, connection);
the command text is a select command retrieving lots of data. After that call the memory jumps up (by more than 100M).
Then I try to clean up the dataset by:
ds = null;
But the memory decreases by only a fraction of the above (about 10-20M).
What's wrong with the code, how can I free up the memory used by the dataset.