Server Application Unavailable Error when query returning more datas

Hai All,

There is a problem on my asp.net(C#) program
i am using VS.Net2003.On that program i'm taking datas from
Oracle database and displaying it.

My query will taking(now) 89512 Rows of datas
when that query works i got the following error:

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

IF i give one more condition eg: upper(name) like '%SS%'(return 1814 rows) then
the program woorks well. How can i overcome this problem?.
i'm using datatable to store data and datagrid to display.

Somebody please help me...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

nikshukla20y ago
Are you binding data to the Grid on the page?

If yes then Enable Paging feature of Datagrid which should resolve this issue. Binding DataGrid with Paging disabled and displaying too many rows is memory consuming. You worker process goes out of memory and crash at the same time. Use Try/Catch block, and you will see a System.OutOfMemory exception.

Regards,
0