.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Performance with gridview

Posted By: venu     Posted Date: July 27, 2011    Points:5   Category :ASP.Net
Hi Friends!

I have been asked by a question in one interview.

Q:If my gridview page is displaying 100 records /page and it have 10 pages meas the total records are 1000 ,how can you handle it?

this is the question can any one give answer pls

Thanks & Regards

Author: Karthikeyan Anbarasan       [Moderator]      
Posted Date: July 27, 2011     Points: 20   


For your question you can simply say that using Pagination (Paging) you can handle this type of scenario

Mark as Answer if the answer solves your issue!!!
Author: venu             
Posted Date: July 27, 2011     Points: 20   

Thanks for your replay this is not the answer if i wish to display 10 records/page every time when i click on paging numbers it will execute query and will give 1000 records then obviously there is performance degradation.I think you got my point

Thanks & Regards
Dotnet Programmer
Author: Dhiraj Ranka             
Posted Date: July 27, 2011     Points: 20   


I guess pagination is correct answer.

Read this http://www.4guysfromrolla.com/articles/031506-1.aspx#postadlink

Hope this helps.

Thanks & Regards,
Dhiraj Ranka
http://www.twitter.com/dhirajranka | http://www.dhirajranka.com
Author: Sasi Prabhu             
Posted Date: July 29, 2011     Points: 20   


I Think Paging.
Or Else export the data to excel.

Thanks & Regards,
Sasi Prabhu.
Author: Gowthammanju             
Posted Date: July 29, 2011     Points: 20   

try these link as


Thanks & Regards,

Mark if the answer is true
Author: Ravi Ranjan Kumar             
Posted Date: July 31, 2011     Points: 20   


GridView Examples for ASP.NET 2.0: Paging and Sorting the GridView's Data
ASP.NET GridView with Custom Paging UI
Advanced Paging GridView with ASP.NET 2.0/3.5

Thanks & Regards
Ravi Ranjan Kumar
Author: Algernoncharles             
Posted Date: November 16, 2012     Points: 20   

Data sorting information is contained in grid headers.Users may set single or multiple sorting in one or multiple headers On programming level, sorting.The grid is optimized for working with dynamic data changed in real time.Resource consumption stays at the minimum irrespective of the methods of filling grid with data, data type and hierarchy level.For example, highly efficient integrated algorithms enable a grid with 5 000 rows to perform over 5000 sorting operations per second.Here sorting means calling Row.Update() method followed by row relocation. If after calling Row.Update() method the row doesn’t move or moves outside visible area of the grid, CPU resource consumption is much lower.More detail you can visit dapfor. com

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend