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" <su***************@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

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

[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/mic...1ff5b184?hl=en

http://groups.google.co.in/group/mic...51fbfe04?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....