c# - How to use autocomplete extender multiple times in single textbox? -
i working on real estate based application in asp.net . here, want use autocomplete extender cities. have tried following
below design section have used textbox named "txtcity" along autocomplete extender target control "txtcity" , web service method "getcities".
<%@ register assembly="ajaxcontroltoolkit" namespace="ajaxcontroltoolkit" tagprefix="ajax" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>ajax autocompleteextender without webservice</title> </head> <body> <form id="form1" runat="server"> <ajax:toolkitscriptmanager id="scriptmanager1" runat="server"/> <div> <asp:textbox id="txtcity" runat="server"></asp:textbox> <ajax:autocompleteextender id="autocompleteextender1" runat="server" targetcontrolid="txtcity" minimumprefixlength="1" enablecaching="true" completionsetcount="1" completioninterval="1000" servicemethod="getcities" > </ajax:autocompleteextender> </div> </form> </body> </html> below webservice method return names of cities in form of list.
using system.data; using system.data.sqlclient; using system.collections.generic; using system.configuration; [system.web.services.webmethod] public static list<string> getcities(string prefixtext) { sqlconnection con = new sqlconnection (configurationmanager.connectionstrings["dbconnection"].tostring()); con.open(); sqlcommand cmd = new sqlcommand("select * city cityname @name+'%'", con); cmd.parameters.addwithvalue("@name", prefixtext); sqldataadapter da = new sqldataadapter(cmd); datatable dt = new datatable(); da.fill(dt); list<string> coitynames = new list<string>(); (int = 0; < dt.rows.count; i++) { citynames.add(dt.rows[i][1].tostring()); } return citynames; } here, when enter character cities matching character gets displayed in drop-down manner , after selecting city, selected city displayed in textbox.
when search city new city appears in textbox while selected city gets deleted. don't want selected cities disappear.
i want use functionality used in sites 99acres.com.
the exact functionality is being demonstrated using rad controls here http://demos.telerik.com/aspnet-ajax/autocompletebox/examples/default/defaultcs.aspx
you need set sql data source , bit of ajax wrapping.
screenshot:
Comments
Post a Comment