Hi All,

In my ASP.Net application am trying to read into a dataset many number of rows using DataAdapter.Fill method.

The query returns as many as 60,000 rows.

When the numbers of rows are less I dont have any problem. But when there are many rows being returned, it gives me either a "QueryTimeout Expired" error
OR
"WebServer is unavailable check the application event log of the web server".

When I check the event log this is what has been recorder for the error
aspnet_wp.exe (PID: 3764) was recycled because memory consumption exceeded the 301 MB (60 percent of available RAM).


Any help will be appreciated.