Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 


Customize paging in GridView/DataGrid/DataList/Repeater
Question Posted on 30 Sep 2011

Home >> DotNet >> ADO.NET >> Customize paging in GridView/DataGrid/DataList/Repeater




To customize paging in GridView we have to create a procedure which return the the exact result that we have set in GridView pagesize only we have to pass two parameter one is pageindex and second is pagesize

alter PROCEDURE GridviewOrdersPaged ( @PageIndex int, @PageSize int )
AS
BEGIN
  DECLARE @PageLowerBound int
  DECLARE @PageUpperBound int
  DECLARE @RowsToReturn int
  -- First of all set the rowcount
  SET @RowsToReturn = @PageSize * (@PageIndex + 1)
  SET ROWCOUNT @RowsToReturn
  -- Set the page bounds
  SET @PageLowerBound = @PageSize * @PageIndex
  SET @PageUpperBound = @PageLowerBound + @PageSize + 1
  -- Create a temp table to store the select results
  CREATE TABLE #PageIndex ( IndexId int IDENTITY (1, 1) NOT NULL, OrderID int )
  -- Insert into the temp table
  INSERT INTO #PageIndex (OrderID) SELECT col_id FROM tbl_name ORDER BY id DESC
  -- Return total count
  SELECT COUNT(col_id) FROM tbl_name
  -- Return paged results
  SELECT O.* FROM tbl_name O, #PageIndex PageIndex WHERE O.col_id = PageIndex.OrderID AND PageIndex.IndexID > @PageLowerBound AND PageIndex.IndexID < @PageUpperBound ORDER BY PageIndex.IndexID
END
0
0



 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


Other Important Questions
Getting Error DataControlRowType does not found in dotnet GridView?
Connection and Disconnected Scenario in ADO.Net
Error illegal characters in path while reading xml from dataset
Code to apply distinct keyword record on dataset table
Define different execute methods of ADO.NET Command Object






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |