How to position datgridview based on textbox value

Question

Through bindingSource control I am using LinqtoSql Products class in my datagridview I would like to make search for a given product name so while typing its name in a textbox datagridview selected row should change position. I do not want to filter my list only find the required row. How to do that please.

Sudhakar Chaudhary · Answer

hope it can help you..... try { dataGridView1.ClearSelection(); for (int i = 0; i { if dataGridView1.Rows[i].Cells[0].Value.ToString().StartsWith(textBox1.Text)) { dataGridView1.FirstDisplayedScrollingRowIndex = i; dataGridView1.Rows[i].Selected = true; return; } } } catch (Exception) { }

Samio · Answer

Hi Sudhakar to make it work please add  true CultureInfo.InvariantCulture if (dataGridView1.Rows[i].Cells[1].Value.ToString().StartsWith(textBox1.Text  true CultureInfo.InvariantCulture )) Thank you for your valuable help.