Working with large datasets and filtering
-
Hi, I have a gridview control and a radiobuttonlist with 4 options. Each option applies a different Rowfilter (one of them is "All data") to the dataset.Tables[0].DefaultView Rowfilter and then the grid is bound to the filtered dataview. On the localhost the app run 100%, as soon as I publish the app I get a "Internet Explorer cannot display the webpage" error on the radiobuttonlist_selectedindexchanged event. The dataset returned from the sql db can be very large 10000+ records (even after I added a number of parameters to reduce the result, I cannot apply more paramaters therefore I'll have to get a way to display and filter that amount of data) Any help would be much appreciated. Thanx
-
Hi, I have a gridview control and a radiobuttonlist with 4 options. Each option applies a different Rowfilter (one of them is "All data") to the dataset.Tables[0].DefaultView Rowfilter and then the grid is bound to the filtered dataview. On the localhost the app run 100%, as soon as I publish the app I get a "Internet Explorer cannot display the webpage" error on the radiobuttonlist_selectedindexchanged event. The dataset returned from the sql db can be very large 10000+ records (even after I added a number of parameters to reduce the result, I cannot apply more paramaters therefore I'll have to get a way to display and filter that amount of data) Any help would be much appreciated. Thanx
You are trying to display 10,000+ records all at once? :omg: Have you thought about Paging?
only two letters away from being an asset
-
You are trying to display 10,000+ records all at once? :omg: Have you thought about Paging?
only two letters away from being an asset
Yeas, I do use paging: pagesize: 20. At first I read all data in at once saved it in session and the rebind on pageindexchanging to the session object. I got the same error. Then I changed the code to alter the sqlcommand on the rbl_selectedindexchanging event and read only the data from the database for the selected error. Then on pageindexchanging the sql command is executed again. Still the same error.