Фильтрация данных в DataGridView в зависимости от значения в txtBox по событию TextChanged

        string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database.accdb;Persist Security Info=False;";
 
 
        public ArrayList GetAllInfo()
        {
            ArrayList allInfo = new ArrayList();
            using (OleDbConnection con = new OleDbConnection(connectionString))
            {
                OleDbCommand com = new OleDbCommand("SELECT tbl_Region.Region, tbl_Company.Company, tbl_Expert.Expert, tbl_Expert.Otdel FROM ((tbl_Region RIGHT JOIN tbl_Company ON tbl_Region.id_Region = tbl_Company.id_Region) RIGHT JOIN tbl_Expert ON tbl_Company.id_Company = tbl_Expert.id_Company)", con);
 
                try
                {
                    con.Open();
                    OleDbDataReader dr = com.ExecuteReader();
                    if (dr.HasRows)
                        foreach (DbDataRecord result in dr)
                            allInfo.Add(result);
                    else
                    {
                        MessageBox.Show("Отсутствует информация для отображения", "Информация", MessageBoxButtons.OK);
                    }
                }
                catch
                {
                }
 
            }
            return allInfo;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dgvAll.DataSource = dal.GetAllInfo();
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
              //
        }

        private void textBox_TextChanged(object sender, EventArgs e)
        {
            con = new OleDbConnection(cs);
            con.Open();
            adapt = new OleDbDataAdapter("SELECT tbl_Region.Region, tbl_Company.Company, tbl_Expert.Expert, tbl_Expert.Otdel FROM ((tbl_Region RIGHT JOIN tbl_Company ON tbl_Region.id_Region = tbl_Company.id_Region) RIGHT JOIN tbl_Expert ON tbl_Company.id_Company = tbl_Expert.id_Company) WHERE (tbl_Region.Region like '%" + textBox1.Text + "%' AND tbl_Expert.Expert like '%" + textBox2.Text + "%')", con);
            dt = new DataTable();
            adapt.Fill(dt);
            dgvAll.DataSource = dt;
            con.Close();
        }

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.Common;
using System.Collections;
using System.Threading;
 
namespace TestDB
{
    public partial class MainForm : Form
    {
        string cs = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database.accdb;Persist Security Info=False;";
 
        OleDbConnection con;
        OleDbDataAdapter adapt;
        DataTable dt;

SELECT tbl_Region.Region, tbl_Company.Company, tbl_Expert.Expert, tbl_Expert.Otdel FROM ((tbl_Region RIGHT JOIN tbl_Company ON tbl_Region.id_Region = tbl_Company.id_Region) RIGHT JOIN tbl_Expert ON tbl_Company.id_Company = tbl_Expert.id_Company) WHERE (tbl_Region.Region like '%" + textBox1.Text + "%' AND tbl_Expert.Expert like '%" + textBox2.Text + "%')

OleDbDataAdapter adapt;
DataView dv;
 
DataSet ds = new DataSet();
adapt.Fill(ds);
dv = ds.Tables[0].DefaultView;
DataGridView.DaraSource = dv;

        private void dgvProducts_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            //get DGV row
            var row = dgvProducts.Rows[e.RowIndex];
            //get DataView row
            var dataRowView = row.DataBoundItem as DataRowView;
            //get DataTable row
            var dataRow = dataRowView.Row;
            //...
        }

data = new Repository().GetProducts(1);

Provider=Microsoft.ACE.OLEDB.12.0