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


Top 5 Contributors of the Month
david stephan

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

ASP.NET - Avoiding Database calls to display Grid Views

Posted By: Nani     Posted Date: September 23, 2009    Points:2   Category :ASP.Net
Hi,

We are working on Grid Views in an ASP.NET application.
Here we would like to avoid the database calls for binding dataset/data table to grid view whenever a user clicks on sort (column sorting), pagination links or whenever he updates a record.

Would you please let me know the best practice to handle it?
If would be great if you could also provide a reference document or web references (If needed).


Many Thanks,
Regards,
Nani.

Responses
Author: Amit Mehra             
Posted Date: September 23, 2009     Points: 5   

Hi,
You can use Ajax and Update panel for various gridview operation. if you are using asp.net 2.0 onwards..its easy to implement and also due to ajax call all the page will not post to the server.

Thanks
Amit

Thanks,
Amit
Please "Mark As Answer " if this post help you.
Author: Nani             
Posted Date: September 24, 2009     Points: 5   

Hi Amit,
Thank you very much.

Would you please let me know any best reference url for this so that I could go through it and make a sample.


Regards,
Nani

Author: Amit Mehra             
Posted Date: September 24, 2009     Points: 5   

HI Nani,

You can refer this link to sort, Apply Pagination in gridview using Ajax updatepanel


http://programming.top54u.com/post/AJAX-GridView-Paging-and-Sorting-using-C-sharp-in-ASP-Net.aspx

Regards
Amit

Thanks,
Amit
Please "Mark As Answer " if this post help you.


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
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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