Gridview with paging find all records
-
Hi, I am using a gridview(paging enabled with some 80,000 records, page size 1000 records) with selectallpages & deselectallpages. Selectallpages and deselect is working fine with me, after selecting all the pages record using a checkbox, I need to find the values in the rows having checkbox checked. But I m able to find only records on the selected page, not able to retrieve values from other pages. Selectallpages is working, I can see that by going through pages. I tried looping through gridview rows but its gives values only of current page. Any suggestion how to retrieve all the values(80k records). Regards
Vijay V. Yash Softech
-
Hi, I am using a gridview(paging enabled with some 80,000 records, page size 1000 records) with selectallpages & deselectallpages. Selectallpages and deselect is working fine with me, after selecting all the pages record using a checkbox, I need to find the values in the rows having checkbox checked. But I m able to find only records on the selected page, not able to retrieve values from other pages. Selectallpages is working, I can see that by going through pages. I tried looping through gridview rows but its gives values only of current page. Any suggestion how to retrieve all the values(80k records). Regards
Vijay V. Yash Softech
VijayVishwakarma wrote:
I am using a gridview(paging enabled with some 80,000 records, page size 1000 records)
Is it really necessary to display this amount (80,000) records in GridView. Did you ever thing about the web site performance ? Please have a look into it and Try to minimize the records as small as possible. This is just my suggestion.
VijayVishwakarma wrote:
But I m able to find only records on the selected page, not able to retrieve values from other pages. Selectallpages is working, I can see that by going through pages.
Here is a excellent article by Samir, Maintaining States of Selected CheckBoxes in Different Pages inside the GridView[^] This will resolve your problem. But please consider the Data amount the that you are showing on page. Good luck!
cheers, Abhijit CodeProject MVP
-
VijayVishwakarma wrote:
I am using a gridview(paging enabled with some 80,000 records, page size 1000 records)
Is it really necessary to display this amount (80,000) records in GridView. Did you ever thing about the web site performance ? Please have a look into it and Try to minimize the records as small as possible. This is just my suggestion.
VijayVishwakarma wrote:
But I m able to find only records on the selected page, not able to retrieve values from other pages. Selectallpages is working, I can see that by going through pages.
Here is a excellent article by Samir, Maintaining States of Selected CheckBoxes in Different Pages inside the GridView[^] This will resolve your problem. But please consider the Data amount the that you are showing on page. Good luck!
cheers, Abhijit CodeProject MVP
Thanks for the link. I do care for that, but it is the requirement. Its the admin of the site where site admin wants to see all the values. I am worried about the performance since I m expecting more than 100,000 users on the site at a time, need to write a perfect caching code and work out with performances. This count will go above 100,000 in 3-4 days. Regards
Vijay V. Yash Softech
-
Thanks for the link. I do care for that, but it is the requirement. Its the admin of the site where site admin wants to see all the values. I am worried about the performance since I m expecting more than 100,000 users on the site at a time, need to write a perfect caching code and work out with performances. This count will go above 100,000 in 3-4 days. Regards
Vijay V. Yash Softech
VijayVishwakarma wrote:
Its the admin of the site where site admin wants to see all the values.
That's correct. But why you are not giving some search criteria, based on that display the data.
VijayVishwakarma wrote:
I am worried about the performance since I m expecting more than 100,000 users on the site at a time, need to write a perfect caching code and work out with performances.
Yup. You should taking care of lots of Caching.And here is the one of the best link for performance, Improving ASP.NET Performance[^] . Please go through this. Good luck :rose:
cheers, Abhijit CodeProject MVP
-
VijayVishwakarma wrote:
Its the admin of the site where site admin wants to see all the values.
That's correct. But why you are not giving some search criteria, based on that display the data.
VijayVishwakarma wrote:
I am worried about the performance since I m expecting more than 100,000 users on the site at a time, need to write a perfect caching code and work out with performances.
Yup. You should taking care of lots of Caching.And here is the one of the best link for performance, Improving ASP.NET Performance[^] . Please go through this. Good luck :rose:
cheers, Abhijit CodeProject MVP
Thanks
Vijay V. Yash Softech
-
Hi, I am using a gridview(paging enabled with some 80,000 records, page size 1000 records) with selectallpages & deselectallpages. Selectallpages and deselect is working fine with me, after selecting all the pages record using a checkbox, I need to find the values in the rows having checkbox checked. But I m able to find only records on the selected page, not able to retrieve values from other pages. Selectallpages is working, I can see that by going through pages. I tried looping through gridview rows but its gives values only of current page. Any suggestion how to retrieve all the values(80k records). Regards
Vijay V. Yash Softech
VijayVishwakarma wrote:
I am using a gridview(paging enabled with some 80,000 records, page size 1000 records) with selectallpages & deselectallpages.
Reading all other posts, I understand you care about performance. So don't use the built-in gridview paging. It just loads all the data at the beginning and reloads it when page index changes which will be huge performance issue. As a remedy, use custom paging.
VijayVishwakarma wrote:
I tried looping through gridview rows but its gives values only of current page.
Loop through the data source. Data source will have all the values. :)
Navaneeth How to use google | Ask smart questions