Introduction:
In this article,i am going to explain about how to create a auto complete text box with out using auto complete
extender.
Main:
In windows application we cannot enjoy ajax auto complete extender,but we can try some other options,
the best one is ado.net,
AutoCompleteStringCollection local_Col = new AutoCompleteStringCollection();
DataTable local_DtAutoCompleteEx = Dal.ExecuteSP("StoredProcedure", fieldName, tableName);
if (local_DtAutoCompleteEx.Rows.Count >= 0)
{
for (int count = 0; count < local_DtAutoCompleteEx.Rows.Count; count++)
{
local_Col.Add(local_DtAutoCompleteEx.Rows[count][fieldName].ToString());
}
}
textbox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
textbox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textbox1.AutoCompleteCustomSource = local_Col;
AutoCompleteStringCollection local_Col = new AutoCompleteStringCollection(); DataTable local_DtAutoCompleteEx = Dal.ExecuteSP("StoredProcedure", fieldName, tableName); if (local_DtAutoCompleteEx.Rows.Count >= 0) { for (int count = 0; count < local_DtAutoCompleteEx.Rows.Count; count++) { local_Col.Add(local_DtAutoCompleteEx.Rows[count][fieldName].ToString()); } } textbox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend; textbox1.AutoCompleteSource = AutoCompleteSource.CustomSource; textbox1.AutoCompleteCustomSource = local_Col; |
Conclusion:
Hope this helps,
Happy coding.