Interviews - C# Corner

Jaipal Reddy
How to Load a Large amount (1 lakh) of records in Gridview ? as well as how it loads in stored Procedure ?
By Jaipal Reddy in .NET onMay 23 2015
  • Mohsin Mukri
    Jul, 2017 6

    here you have to use the paging to load this amount of data, otherwise, your page performance either degrade or will not load completed the request. In this case, you should have to provide the search functionality because user always interested to have their record in second, user don't want to navigate and search on every page

    • 0
  • Raghavendra Rao
    May, 2017 4

    Use paging in SPselect ID,Note from(select ID,Note, ROW_NUMBER() OVER (order by ID desc) as Pos from TestTable) as Twhere T.Pos > 1000 and T.Pos < 10030

    • 0
  • Ritesh Singh
    Aug, 2016 4

    https://msdn.microsoft.com/en-us/library/bb445504.aspxhttp://www.codeproject.com/Questions/468866/how-to-bind-lakh-records-in-gridview-within-few

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS