Time taking Asp.Net GridView with 2 million Records

Question

How to get data fast from million of records from sqlserver in asp.net. Display in Gridview. Thanks and Regards Bvenkat Jeewesh S/W Developer

Riddhi Valecha · Answer

Hi.. What is Asynchronous Programming ... ?? Is this just setting async = true in aspx Page..... Also I have to fetch records from a table and export to excel ... THere are 5 lakhs records in the table .... how to export them all at a time in excel ?? And it takes a lot of time while loading. I am currently doing database paging (Row_Number())

Anurag Sarkar · Answer

You can use asynchronous programming.

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/0b8108/Asp-Net-ajax-gridview-loading-using-C-Sharp/default.aspx