foo, bar and donkey

PingBack from http://msdnrss.thecoderblogs.com/2007/10/09/cascading-autocomplete/

Thanks for the helpful posting!

I copied your javascript and I got it to work on my text boxes but it isn't working the way I thought it would.

When the user changes the value of the textbox that holds the context key and moves to the next textbox the autocomplete sometimes will use an "old" list of values from the last context key. I tried setting a break point on the web service that retieves the list from the database and in these instances it doesn't get fired. I assume the list is cached. I didn't experience this in your test website. Do you know what the problem could be?

Here is my code:

Webservice:

<WebMethod()> _

  Public Function GetPolicyNumbers(ByVal prefixText As String, ByVal count As Integer, ByVal contextKey As String) As String()

     Dim strsql As String = "Select DISTINCT TOP 15 PolicyNumber from tbl_Policy Where PolicyNumber like @prefixText AND PolicySymbol = @contextKey"

Dim daSQL As New SqlDataAdapter(strsql, My.Settings.ConnectionString)

     daSQL.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = "%" + prefixText + "%"

     daSQL.SelectCommand.Parameters.Add("@contextKey", SqlDbType.VarChar, 50).Value = contextKey

     Dim dt As New DataTable

     daSQL.Fill(dt)

     Dim items(dt.Rows.Count - 1) As String

     Dim i As Integer = 0

     Dim dr As DataRow

     For Each dr In dt.Rows

        items(i) = dr("PolicyNumber")

        items(i) = items(i).TrimStart("0"c)

        'items.SetValue(dr("PolicyNumber").ToString, i)

        i += 1

     Next

     Return items

  End Function

JavaScript:

       function initCascadingAutoComplete() {

           var symbolAutoComplete = $find('autoCompleteBehavior1');

           var numberAutoComplete = $find('autoCompleteBehavior2');

           numberAutoComplete.set_contextKey(symbolAutoComplete.get_element().value);

           symbolAutoComplete.add_itemSelected(cascade);

           // setup initial state of second flyout

           if (symbolAutoComplete.get_element().value) {

               numberAutoComplete.get_element().disabled = false;

           } else {

               numberAutoComplete.get_element().disabled = true;

               numberAutoComplete.get_element().value = "";

           }

       }

       function cascade(sender, ev) {

           var numberAutoComplete = $find('autoCompleteBehavior2');

           numberAutoComplete.set_contextKey(ev.get_text());

           numberAutoComplete.get_element().value = '';

           if (numberAutoComplete.get_element().disabled) {

               numberAutoComplete.get_element().disabled = false;

           }

       }  

       Sys.Application.add_load(initCascadingAutoComplete);

Design Source:

<cc1:AutoCompleteExtender ID="PolicySymbol" Enabled="true" TargetControlID="txtPolicySymbol" behaviorid="autoCompleteBehavior1"

                                MinimumPrefixLength="1"  ServicePath="AutoCompleteService.asmx"

                                Servicemethod="GetPolicySymbols" runat="server" CompletionInterval="100" CompletionSetCount="15">

  </cc1:AutoCompleteExtender>

  <cc1:AutoCompleteExtender ID="PolicyNumber" Enabled="true" TargetControlID="txtPolicyNumber"  BehaviorID="autoCompleteBehavior2"

                                MinimumPrefixLength="1"  ServicePath="AutoCompleteService.asmx"

                                Servicemethod="GetPolicyNumbers" runat="server" CompletionInterval="100" CompletionSetCount="15" EnableViewState="False">

  </cc1:AutoCompleteExtender>