Search in Datagridview populated by typing on it

Question

I own a DataGridView already with recovered data where user selects an item. But, as the items are numerous, I would like to enable the user to type on the Datagrid while the system "goes" to the entered item.

I don’t know the correct name for this type of facility, but it’s very common in the Widows environment itself. How do I apply this to a DataGridView?

Thank you.

Answer 1

Add a field of the type TextBox just above your DataGridView and add a handler to the event TextChanged and within this handler do as code below, taking into account your needs:

var termo = (sender as TextBox).Text.ToLowerInvariant();
bool semTermo = String.IsNullOrEmpty(termo);

foreach (DataGridViewRow linha in dataGridView1.Rows)
{
    if ((linha.Cells[COL_NOME.Index].Value as string).ToLowerInvariant().Contains(termo) || semTermo)
        linha.Visible = true;
    else
        linha.Visible = false;
}

In this example when the field text is changed the lines that contain the value typed in the "Name column", COL_NOME is the name of a column, will be displayed. If the term is empty, ie the person has deleted, it will display all lines.