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.

Nested GridView With Expandable

Nested GridView with Expandable:

In this article I'm trying to explain how to work with nested GridView with expandable option. For example if we click on parent row information then only the child grid information to be displayed. This is very pretty to show the data.

Gridview Bulk Edit, Bulk Update, Bulk Insert in ASP.net

 

GridView Bulk Edit, Update, Insert

                In my previous thread GridView Edit/ Update /Cancle I'm explaining about how to edit, update GridView Records, but now I'm trying to explain Bulk Records edit, Update and inserting. For this purpose I'm introduce one checkbox and based on checkbox selection I want to insert data , edit data, and update data based on checkbox selection. For this we no need to choose GridView EditItem Template why because we are performing multiple rows editing not a single row. EditItemTemplate performs single row Editing. So, for that purpose I'm consider both Label and Textbox controls inside Template field only it is easy to understanding.

GridView Edit/ Cancel/ Update/ Delete in ASP.net

GridView Editing / Updating / Deleting:

                     One of the feature of GridView is to support "in place Editing" what even data we are presenting to user can also be allowed with rich Editing (deleting also).

Gridview provides a property called EditIndex whose default value is "-1". When this value is changed to some record then that record of GridView is set to be in Editing Mode.

What is Grid View.? Binding Expressions in GridView..?

GridView:

 

Presentation of data purpose we can use Grid view control. For effective presentations of data we have to handle Grid view columns display manually. For this we can set Auto Generate column property to false is provide all column information manually.