CascadingDropDown with a Database fails when Table has more than 908 rows

Using CascadingDropDown with a Database fails when Table has more than 908 rows

with "SELECT * FROM TABLA1" CascadingDropDown fails with message [Method error 500] otherwise with "SELECT TOP 908 * FROM TABLA1" works fine.

can somebody help me? my Table has more than 908 rows, I need to load about 1100 rows

Thanks

It's due to this:http://ajax.asp.net/docs/mref/P_System_Web_Script_Serialization_JavaScriptSerializer_MaxJsonLength.aspx

The JSON serializer has a default max length (see the bottom of the entry). Increase that number in web.config.

thank you for your quick and accurate response now it works

have been a pleasure

hi,

i have tried to uncomment the <jsonserialization> attribute in the web.config file. i get an error at method error[12030]. i need to retrive about 2000 rows in my dropdown list. any help would be greatly appreciated.

ooops..its working now.i had previously included teh convert tag below the json tag in the web.config file. when i removed the converter tag, its working well...