Autocompleteextender control in asp.net

shyamala

17y13.6k.NET

i am using asp.net with c#....I am using two textbox and two Autocompleteextender control in asp.net....the first one control is used to retrieve database value from sqlserver database..the data is (example--city)..the second control is retrieve the data from the same table..the data is (example--name)..
i want to display the name only based on the city.....who one name are matching with city that names are only display in the second textbox using autocompleteextender control...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

keshav singh17y ago
make a webservice. in webservice ,make a method and all the code you have to write in that method.

and call this webservice into autocompleteextender control in source page
use of webservice in control you can see below links

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx
Lalit M17y ago
you can do that with contextkey property

ServiceMethod="GetCities"
ServicePath="../AotuSuggestions.asmx"
MinimumPrefixLength="2"
CompletionInterval="100"
CompletionSetCount="20" UseContextKey="True" >

ServiceMethod="GetMainAreas"
ServicePath="../AotuSuggestions.asmx"
MinimumPrefixLength="2"
CompletionInterval="100"
CompletionSetCount="20" >

you have to place the javascript after scriptmanager

your webmethod look like below

[WebMethod]
public string[] GetMainAreas(string prefixText, int count, string contextKey)
{

string CountryId = "0";
string City = "0";

if (contextKey != "" && contextKey != null)
{
City = contextKey;
}
}
keshav singh17y ago
you can see some samples on

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx

http://www.codeproject.com/KB/ajax/autosuggestextender.aspx
Kirtan Patel17y ago
Friend,

Here is Nice Article About How to Use AutoComplte Extender Control

http://www.aspdotnetcodes.com/AutoComplete_From_Database.aspx