Re: OutOfMemoryException Filling DataTable

I am doing a simple select on a MSSQL 2005 database and asking for
10,000 rows using classic ADO.NET. I am getting an out of memory
exception. I need this big table, is there any way to back the
DataTable with a disk-resident stream or something else that will let
me "go big"? I don't care if it is slow or not.

Thanks.

DataTable tb = new DataTable();
try
{
using ( sqlco sqlco = new sqlco( myconnstring ) )
{
sqlco.Open();
using ( da da = new da( "select top 10000 id,key,value from mytable" ,
sqlco ) )
{
    da.Fill( tb );
}
}
}