I have a vb.net windows form project that includes a dataset. From my main form, the user can open a "load client" form that contains a datagridview. When the "load client" form opens, I fill a dataset on the form from my sql ce database and then load the dataset into a datagridview. The database I'm testing with has 10,000 records, and it causes the memory usage to skyrocket. My issue is that when the user closes the form, the memory usage doesn't decrease. When they open the "load client" form again, the memory usage almost doubles again.
The form closes using me.dispose, but it doesn't seem to have an effect on the memory usage.
How can I stop this from happening? To me, it seems like the dataset fills, but the memory is never emptied, so each time I fill the dataset the memory just keeps increasing.