public AutoCompleteStringCollection AutoCompleteLoad()
{
AutoCompleteStringCollection str = new AutoCompleteStringCollection();
foreach (DataRow row in dt.Rows)
{
str.Add(Convert.ToString(row[1]));
}
return str;
}
private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
int column = dataGridView1.CurrentCell.ColumnIndex;
string headerText = dataGridView1.Columns[1].HeaderText;
if (headerText.Equals("pro"))
{
TextBox tb = e.Control as TextBox;
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb.AutoCompleteCustomSource = AutoCompleteLoad();
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
}i make to only only column but still work with all cells how can i solve it ?
alaaPosted May 11, 2015, 5:44 PM
g sPosted May 11, 2015, 8:38 AM
http://dotnetdrizzles.blogspot.in/2015/02/autocomplete-textbox-search-database.html
http://screenshotdrizzles.blogspot.in/2015/02/autocomplete-textbox-search-database.html