I need your help please
in very urgent issue, I need to fill a .net datatable with a huge data( about 400 MB), when load data i face a memory problem , Out of memory exception , i found it take more than 1GB from memory.
I search about this problem and find somebody talk that when use .Net datatable it makes 3 copies of this .net datatable.
My Question is:
what is the best way to use .net Datatable with a huge data?
to avoid memory problems??
Thanks in advance