Customizing PAging By Using SQL Server 2012I want implement customizing paging by using SQL Server 2012.(By using Store Procedure) In the Grid view data will bind then user can choose any page. It will show below Grid View.
Another Requirement is Onw Drop Down List will there and user can chooose drop down list and data will bind according the paging.
Example: In GridView First page is showing 5 no of record on one page. Then Record will show 1-5 records on First page.
If User Choose 2 No from drop Down List then it will show 6-10 record in the Gird View.
In Below Grid View we will take repeater for choosing the page No.