Bulk data in grid view [ASP.Net]

[Sudha Pune]

I need to show 1 lakh record in my gridview.... If i use data adapter
it will take more time to fill the dataset itself....

What will be the best way...

I dont think so only with paging we can solve this performance issue...

Tell me the best way of doing this....

Thanks

 

[sloan]

The way I do it is this:

Fill a dataset with 100,000 records.

On the pageload (and not post back)
I create the DataSet .... and then cache the dataset in the session.


I bind the DataSet to a
<asp:ObjectDataSource>

object.

Then set the gridview source to the the ObjectDataSource.

On paging and/or sorting calls...I pull the cached DataSet instead of a
fresh hit.

 

[Sudha Pune]

can u explain where u do the caching in session and how u r using it
back...

 

[Sudha Pune]

can u also c the below issues

http://groups.google.co.in/group/mi...t/browse_thread/thread/a803bf1c1ff5b184?hl=en

http://groups.google.co.in/group/mi...t/browse_thread/thread/bebe24c051fbfe04?hl=en

 

[misiek]

sloan napisal(a):

The way I do it is this:

Fill a dataset with 100,000 records.

On the pageload (and not post back)
I create the DataSet .... and then cache the dataset in the session.


I bind the DataSet to a
<asp:ObjectDataSource>

object.

Then set the gridview source to the the ObjectDataSource.

On paging and/or sorting calls...I pull the cached DataSet instead of a
fresh hit.

Hi Sloan.

Could you tell me how do you bind DataSet from Session to
ObjectDataSource?

Thanks,
misiek

 

[Sudha Pune]

But for loading 1 Lakh records first time will take too much time na....