c# - AutoCompleteExtender help needed -


i sure simple solution, @ end..

i have following aspx

      <asp:textbox id="textvendornamelookup" autopostback="true" runat="server" width="200px"                      onfocus="this.select()"                      text=''></asp:textbox>                 <ajaxtoolkit:autocompleteextender id="vendornameautocompleteextender" targetcontrolid="textvendornamelookup"                     firstrowselected="false" runat="server" servicemethod="getvendor" completioninterval="1"                      enablecaching="true" minimumprefixlength="1" usecontextkey="true" servicepath="vendorlookupwebservice.asmx">                  </ajaxtoolkit:autocompleteextender> 

and following asmx

using system; using system.collections.generic; using system.web; using system.web.services; using system.data; using system.data.sqlclient; using system.configuration; using system.xml;   /// <summary> /// summary description vendorlookupwebservice /// </summary> [webservice(namespace = "http://rouses.com/")] [webservicebinding(conformsto = wsiprofiles.basicprofile1_1)] // allow web service called script, using asp.net ajax, uncomment following line.  [system.web.script.services.scriptservice] public class vendorlookupwebservice : system.web.services.webservice {      public vendorlookupwebservice()     {          //uncomment following line if using designed components          //initializecomponent();      }      [webmethod]     //public string[] getorganization(string prefixtext)     public static list<string> getvendor(string prefixtext)     {          var cmdtext = "select vmvnnm dbmoto..apvendp vmvnnm @prefixtext , vmasts = 'a'";          using (var conn = new sqlconnection(configurationmanager.connectionstrings["mainconnectionstring"].tostring()))         using (var cmd = new sqlcommand(cmdtext, conn))         {             cmd.parameters.add(new sqlparameter("@prefixtext", string.format("%{0}%", prefixtext)));             conn.open();             sqldatareader dr = cmd.executereader();              var vendors = new list<string>();              if (dr.hasrows)             {                 while (dr.read())                 {                     vendors.add(dr["vmvnnm"].tostring());                 }             }             conn.close();             return vendors;         }      } } 

but webservice not firing when type textbox....

any ideas?

the getvendor function must absolutely match signature below:

public string[] getvendor(string prefixtext, int count) 

as stated here:

the return type , parameter name , type must match, including case.


Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -