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
Post a Comment