I have a service that is pulling alot of records from a SQL Server table in a DataSet. This process takes up alot of memory, which is to be expected. But when the process is finished, I am clearing all the data I thought with:

MyDataSet.Tables("MyTable1").Rows.Clear()
MyDataSet.Tables("MyTable2").Rows.Clear()
MyDataSet.Tables("MyTable3").Rows.Clear()

But I'm monitoring the memory the process is doing and this isn't freeing the memory. Is there something I need to do to flush the memory?