how to handle bulk data in gridview

HI

I am having a gridview in a web application. for a search my stored procedure returns more than 30 thousands of records sometimes.

I am not using any direct connection from gridview to databse. i am fill the dataset by executing the stored procedure. If it's a direct connection it will bring few records to fill the first few pages and once we navigate , it will bring another set of data. (my page size is 1000).

how can i handle this? is there anyway to bring few data to dataset and once we navigate to another page we can bring next few 1000s records?

Regards

K.Anvar sadath

Hi Anvar,

You need to use custom paging in Gridview. Please check out this article:

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

Hope this helps.