drop down with large data on postback gives error

madhusrp · March 13th, 2006, 11:28 AM

hai everyone

      i havnt got any solution to the previous blog and in mean time i have found a high priority bug which gives error.

      when i operate any click event in the page that contains a dropdown which is binded with large data then it gives error message stating maximum request length exceeded i dont understand the problem.

       can anyone help me what kind of problem it is whether coding problem or sql problem or browser problem

thanks in advance

jbenson001 · March 13th, 2006, 04:14 PM

most likly a timeout on the sql server. You really shouldn't pull large amounts of data into a dropdownlist anyway. Restrict the # of rows retrieved.

rstelma · March 13th, 2006, 04:50 PM

I had the same error myself. Except, it wasn't the drop-downs that were large. The drop-downs contained filter values for what could be large queries on the page.

I put

Code:

enableviewstate=False

on all of the controls on the page and it solved the error.

madhusrp · March 14th, 2006, 12:48 AM

Hai,

jbenson001,rstelma

A close thanks to u for giving me a good solution.I have another dought which i think can be clarified by you as the previous one.i need to speed up the UI which takes atleast 10 minutes to get loaded.
but i dont have anyproblem with the query, it is executing fastly.my page has a datagrid which contains the dropdown and page size is 10 so for filling all the rows with the dropdown where each dropdown contains nearly 50000 values. probably it is taking time,but the query executes fast so i need to trace in which part it is slowing down and suggest me a solution that i can come out of it

thank you
have a nice day.

jbenson001 · March 14th, 2006, 12:52 AM

Glad to help

madhusrp · March 16th, 2006, 02:55 AM

thank u very much