Hi,
I tried partly successful to implement the AutoComplete sample (http://www.codeproject.com/Articles/201099/AutoComplete-With-DataBase-and-AjaxControlToolkit) using mysql as database - that means I succeeded to get a table of streetnames, but myTextBox did not show the items - error message: autoComplete1 could not extend myTextBox. Environment: Windows 7, XAMPP, MySQL, VisualStudio 2008
1) what's the problem with myTextBox? autoComplete1 could not extend myTextBox. was returned by localhost.
2)
The final form where I would like to use the autocompletion is a table and looks like that:
Adresse <input name="BezStrasse"; type="text" id="BezStrasse" maxlength="80" /> HausNr <input name="HausNr" type="text" id="HausNr" maxlength="10"/>
PLZ / Ort <input name="PLZ" type="text" id="PLZ" maxlength="20" /> /
<input name="Ort" type="text" id="Ort" maxlength="50" /><input type="hidden" name="ID_S" id="ID_S" />
The user should receive typing characters in BezStrasse by autocomplete lines attached to BezStrasse showing PLZ, ORT, STRASSE, ID_Strasse
coding in autocomplete.cs is to retrieve data from the DB, this part work's fine returning
foreach (DataRow row in dt.Rows)
{
//String From DataBase(dbValues)
dbValues = row["PLZN"].ToString() + ";" + row["ORT"].ToString() + ";" + row["STRASSE"].ToString() + ";" + row["ID_Strasse"].ToString();
txtItems.Add(dbValues);
}
return txtItems.ToArray(); in txtItems I have the retrieved data.
by selecting one line the fields PLZ, Ort, BezStrasse and ID_S should be filled with the Data out of the txtItems Array selected Line -
Is there help or a template available?
Thanks in advance
MiKr41