Hi Friends,

I am trying to make use of Grid View pager control with Custom Paging. I have created stored procedure to fetch only 10 records out of say 50000 records. Using ROW_NUMBER() function of SQL Server 2005. And called this stored procedure in a Business Layer method which is passed to SelectMethod of ObjectDataSource. Also create SelectCountMethod.

I have set all the required properties of GridView and ObjectDataSource.

Also added required code in the PageIndexChanging event.

I am binding the records to the grid view on a button click event. My binding is successfull but pager control of grid view is not visible. Records are getting shown in the grid view.

Can anybody tell me what could be the problem?

Thanks in advance.

---

Give people what they expect and do it cheerfully.

Hi, Try setting AllowPaging="true" in GridView contro.l

Thanks for the reply.
I have set this property to true but it gives the same problem.
Also set AllowPaging property true for ObjectDataSourceControl.

---

Give people what they expect and do it cheerfully.

set on paging=true and fire onpageindexchanging event and bind the gridview data again.