AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
void AutoCompleteItems()
{
try
{
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
s = "Select EmpName from tablename ";
dt = cnn.DataTable(s);
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
namesCollection.Add(dt.Rows[i][0].ToString());
}
}
else
{
}
txt_empName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt_empName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_empName.AutoCompleteCustomSource = namesCollection;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void AutoCompleteItems()
{
try
{
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
s = "Select EmpName from tablename ";
dt = cnn.DataTable(s);
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
namesCollection.Add(dt.Rows[i][0].ToString());
}
}
else
{
}
txt_empName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt_empName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_empName.AutoCompleteCustomSource = namesCollection;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
No comments:
Post a Comment