Subject:
You have been asked to create an ASP.NET page using C# Code and SQL Server Database that displays values from the Database in a Grid View. The Grid View page also contains drop down lists, one at each column, which are populated with unique values from the columns which allow the user to filter the data in the Data Grid before exporting the Data Grid into excel.
The problem is that if a large volume of data i.e. greater than 50,000 records need to be displayed then the page load is very slow, the controls on the page do not display correctly and cause runs time errors. Microsoft excel also has a limit of 65,000 records that it can export so when you try to export large volumes of data excel cannot handle the records in one file.
How would you solve the following problems?
- Issues with displaying large data volumes in a Grid View
- Problems with Runtime errors appearing when the page load is slow and controls not loading correctly
- Problem of having 100,000 records that need to be exported into excel but excel can only handle 65,000 records
Please find answers for the following and detail the steps you would follow to solve the issues.
