GridView (Edit / Cancel) Slow with 4,000 Records [modified]
-
Hi Guys, I am using ASP.Net 2.0 GridView control with more than 4,000 records. In one webform I used 4 views with 1 GridView each. One of these Views has a GridView with more than 4,000 records. And I am also using a repeater. But it is just really frustrating, because it is really very slow. When I clicked the AutoEdit(Edit link) for the 800th record it will postback and I need to find that 800th record again and start changing the cell values, which is not good. Same thing when I clicked Cancel. And by the way, I am using UpdatePanel and no paging method will be used in GridView as part of the client's standards. And also my GridView is inside the Panel control so that there's a Vertical Scroll bar, and it's easier for the user to see all the records from top to bottom using vertical scroll bar. The following ASP.Net controls I am currently using in this process are: Multiview, View, Panel, GridView, SqlDataSource, Repeater, UpdatePanel Structure/Hierarchy: Multiview1 -----View1 ----------Panel1 ---------------GridView1(with 100 records) -----View2 ----------Panel2 ---------------GridView2(with 150 records) -----View3 ----------Panel3 ---------------GridView3(with 50 records) -----View4 ----------Panel4 ---------------GridView4(with 4000plus records) Questions: 1.) How can I load the Page/Gridview fast with more than 4,000 records without using paging method? 2.) How can retain the position when editing a particular row? I really stumped with this. Any recommendation?
hifiger2004
modified on Wednesday, March 4, 2009 10:34 AM