System::Void TextBox1_TextChanged(System::Object^ sender, System::EventArgs^ e) {
        //DataGridViewRow row;
        for (int i = 0; i < dataGridView1->Rows->Count - 1; i++)
        {
            dataGridView1->Rows[i]->Selected = false;
        }
        System::String^ searchValue = textBox1->Text;
        dataGridView1->SelectionMode = DataGridViewSelectionMode::FullRowSelect;
        try
        {
            bool valueResult = false;
            for each (DataGridViewRow ^ row in dataGridView1->Rows)
            {
                for (int i = 0; i < row->Cells->Count; i++)
                {
                    if (row->Cells[i]->Value != nullptr && row->Cells[i]->Value->ToString()->Contains(searchValue))
                    {
                        int rowIndex = row->Index;
                        dataGridView1->Rows[rowIndex]->Selected = true;
                        valueResult = true;
                        break;
                    }
                }
            }
            if (!valueResult)
            {
                MessageBox::Show("Unable to find " + textBox1->Text, "Not Found");
                return;
            }
        }
        catch (Exception ^ exc)
        {
            MessageBox::Show(exc->Message);
        }
        //....................
        for (int i = 0; i < dataGridView1->Rows->Count - 1; i++)
        {
            if (!dataGridView1->Rows[i]->Selected) {
                dataGridView1->Rows[i]->Visible = false;
            }
            else dataGridView1->Rows[i]->Selected = false;
        }
        if (textBox1->Text == "") {
            for (int i = 0; i < dataGridView1->Rows->Count - 1; i++)
            {
                dataGridView1->Rows[i]->Visible = true;
                dataGridView1->Rows[i]->Selected = false;
            }

        }

        //dataGridView1->Columns[0]->Visible;
    }