OutOfMemoryException

This is a long shot, but i was wondering if there was anything that i could
do to avoid an OutofMemory Exception.

I have written a program that runs on a pda which reads in a csv file and
stores it into a datatable object (which can be searched through). At the
moment i can only read in a file with 8000 lines. I'd like to increase this
to 20,000 but can't as i get the OutOfMemoryException...

--
WD

dbgrick
Wed Apr 23 09:52:00 CDT 2008

Try reading a smaller number of lines at a time and perform the database
update. Just put your file read in a loop until eof is reached.

Regards,
Rick D.

"WD" wrote:

> This is a long shot, but i was wondering if there was anything that i could
> do to avoid an OutofMemory Exception.
>
> I have written a program that runs on a pda which reads in a csv file and
> stores it into a datatable object (which can be searched through). At the
> moment i can only read in a file with 8000 lines. I'd like to increase this
> to 20,000 but can't as i get the OutOfMemoryException...
>
> --
> WD