How can I maintain a value in a gridview cell which is a combobox and is set autocomplete? I have a gridview and an autocomplete combobox column, which works properly, but as I select a value and...

See more:

C#

{private void dataGridViewX1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{

if (e.Control is DataGridViewComboBoxEditingControl)
{
AutoCompleteStringCollection strng = new AutoCompleteStringCollection();
SqlDataReader reader;
con.Open();
SqlCommand cmd = new SqlCommand("select * from Item_tbl ", con);
cmd.CommandType = CommandType.Text;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
strng.Add(reader["Name"].ToString());
((ComboBox)e.Control).DropDownStyle = ComboBoxStyle.DropDown;
((ComboBox)e.Control).AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.SuggestAppend;
((ComboBox)e.Control).AutoCompleteSource = AutoCompleteSource.CustomSource;
((ComboBox)e.Control).AutoCompleteCustomSource = strng;

}
}

}
con.Close();
}
}