Scroll down in the grid view fetches next set of records without freezing the screen
-
Hi All, My problem is i am binding around 8,000 records in the gridview and the problem is it is taking more than a min to display data onto the browser. I know one solution can be to use Paging but client does not want paging as he has to search something in grid using ctrl + F feature of the browser. My question is can i load data in a gird view asynchronously just to make the reterieving of data somewhat faster or like as i scroll down in the grid it fetches next set of records without freezing the screen. I have seen this type of feature applied in various E-Commerce sites. Can you please help me. Best Regards Rohit
-
Hi All, My problem is i am binding around 8,000 records in the gridview and the problem is it is taking more than a min to display data onto the browser. I know one solution can be to use Paging but client does not want paging as he has to search something in grid using ctrl + F feature of the browser. My question is can i load data in a gird view asynchronously just to make the reterieving of data somewhat faster or like as i scroll down in the grid it fetches next set of records without freezing the screen. I have seen this type of feature applied in various E-Commerce sites. Can you please help me. Best Regards Rohit
Hi Rohit, It is really surprising to see your client's requirements. However I even agree to the fact that requirements will always be wierd :-D :laugh: from a developer point of view. It is anyways a bad idea to show all the records at once. What would you do if the number of records increase to 20K or to 1 million? I would suggest you convince your client, get the paging implemented for the gridview. Another option would be, give a search functionality in the page. Based on the search criteria load the relevant records. Look at the following links, all of them suggest to use paging. Second link talks about some Telerik control, which loads records on demand by scroll. You can check it out. Loading records in the grid view while scrolling down,No Paging technique.[^] displaying-large-gridviews-efficienty-in-asp-net[^]
Thanks & Regards, Vani Kulkarni
-
Hi All, My problem is i am binding around 8,000 records in the gridview and the problem is it is taking more than a min to display data onto the browser. I know one solution can be to use Paging but client does not want paging as he has to search something in grid using ctrl + F feature of the browser. My question is can i load data in a gird view asynchronously just to make the reterieving of data somewhat faster or like as i scroll down in the grid it fetches next set of records without freezing the screen. I have seen this type of feature applied in various E-Commerce sites. Can you please help me. Best Regards Rohit
as the above answer suggest giving all data at once is not a good practice , why not convince your client to use search from gridview (you can provide search box above gridview) IMHO you should convince him/her for that because as the records will increase the performance of your project will go down with time no matter what you use (Async or not) because even browser apps take space in memory and soon with so much data if its not a good system, the browser will start crashing(Personal experience) regards Alok sharma
sometimes noobs perform better but its sheer luck...