Memory Handling - DataTable and SQL Database

[marcellus7]

Hey guys Im having some problem with handling DataTable memory, here's my predicament; Ive got a TableAdapter and Dataset from a SQL Database that I am inserting records to. These records are being inserting directly to schema using a DataRow of the table from the dataset (I cant use the insert query from the tableadapter because there are over 100 columns in the table that its being inserted to.)

My problem is that the datatable seems to be getting stored in memory from the dataset I am using on the form, and I am running out of memory before I finish inserting all the data into SQL (Over 1m records). Is there a way I can just use dataset schema and tableadapter without the datatable being stored in memory, or how am I going about this wrong?

Thanks

[marcellus7]

Ok guys, I think I've got it. I didnt know that when you add a dataset to the form using the Designer, it turns on the Generate Member property, which automatically saved the datatable in memory and declares it, etc. If you change this property to false, you can declare your own instance of the datatable, and dispose it as often as necessary to keep memory usage down. Just an FYI incase anyone else runs into this.

Thanks