Custom Paging for Gridview using SQL Server

 

Custom Paging for Gridview using SQL Server:

Description:

In my previous article I'm explaining Load on demand, but in this article I'm going to explain how to load data for particular page dynamically using SQL server, for example in some scenarios we want to load huge data, usually what we are doing load all the records and display gridview and perform paging using default grid page options, but when we are looking performance and bandwidth the approach is not good, so that only we are moving forward that load fixed page records based on page size and currentpage index. 

Load on demand data in Gridview using Jquery

Load on demand data in Gridview using Jquery

Description:

In this article I'm going to explain how to load data on demand using Jquery. In some cases to improve the performance of application we are loading data on demand basis, rather than load all the records at a time, in this article I'm going to explain how to achieve this.

Always Visible Extender

           In this article I'm trying to explain how to display the data default into visible to the page. Using this article we can able to pin the position of the control by default. But need to download the AJAX toolkit dll's after download add reference to the project.

Balloon Popup Control

             In this article I'm trying to explain how to work with Balloon Popup control in ASP.net using AJAX. During this we can learn how to work with Popup styles, to put simple efforts. And also we can learn how to show custom styles. For beginners this article will help you how to use this control.

Drag Panel Extender

           In this article I'm trying to explain how to work with AJAX Drag Panel Extender Control in ASP.net. Here we learn how to work with drag functionality using AJAX. There is a control called DragPanelExtender using that we can easily move panel from one place to another.

Filtered TextBox

                In this article I'm trying to explain how to work with AJAX FilteredTextBox control in ASP.net. It Prevents a user enter some invalid characters into Textbox control. Without JavaScript we can achieve this by using AJAX FilteredTextbox Extender control in ASP.net.

Hover Menu

           In this article I'm trying to explain how to work with HoverMenu controls using AJAX in ASP.net. When the user move the mouse over the control then based on pop up displayed position it will show in page.