Wednesday, March 21, 2012

CascadingDropDown Method Error 500 Bug

Hello,

I have been trying out CascadingDropDown for few weeks now. One thing that I specifically noticed is that all Cascadingdropdowns works fine with the webservice. But the problem happens if number of rows returned to CascadingDropDown is more than 906, then I get method error 500.


Is 907 a magic number OR CascadingDropDowns cannot carry more data? I debugged the webservice and the array that it returns looks ok even if has more than 906 records. Just the CascadingDropDown doesn't like if get more than some specific amount/ number of records

Is there any solution or workaround?

------

Here's my webservice method

 <WebMethod()> _ Public Function GetPages(ByVal knownCategoryValues As String, ByVal category As String) As CascadingDropDownNameValue() Dim Values As List(Of CascadingDropDownNameValue) = New List(Of CascadingDropDownNameValue) Dim Kv As StringDictionary = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues) Dim Ds As DataSet Ds = DbImageInfo.ExecuteQuery("SELECT Page FROM ImageInfo WHERE County=" & Kv("County") & " AND Type='" & Kv("Docket") & "' AND Book='" & Kv("Book") & "' ORDER BY Page") For Each Dr As DataRow In Ds.Tables(0).Rows Values.Add(New CascadingDropDownNameValue(Dr("Page").ToString, PadVariableLength(Dr("Page").ToString)) Next Return Values.ToArray End Function

-------

And here's my asp.net tags

 <ajaxToolkit:CascadingDropDown ID="CascadingDropDown4" runat="server" TargetControlID="DdlPage" Category="Page" PromptText="Page..." LoadingText="[Busy...]" ServicePath="WebService.asmx" ServiceMethod="GetPages" ParentControlID="DdlBook"/>

hello,
I have exactly the same problem. Have you found any solution?
Many thanks

No comments:

Post a Comment