Интеграция SQL запроса в код на C#

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source =  база данных.mdb");
var search = textBox2.Text;
string query = "SELECT * FROM БД_МИ WHERE (clearnedText LIKE '%" + search + "%')";
DataTable DT = new DataTable("БД_МИ");
connection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(search, connection);
база_данныхDataSet.Tables.Add(DT);
adapter.Fill(база_данныхDataSet.Tables["БД_МИ"]);
бДМИBindingSource = new BindingSource(база_данныхDataSet, "БД_МИ");
connection.Close();

private DataTable GetFilteredBd_Mi(string search)
{
     DataTable DT = new DataTable("БД_МИ");
using(OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source =  база данных.mdb"))
{     
     string query = "SELECT * FROM БД_МИ WHERE (clearnedText LIKE '%" + search + "%')";
     connection.Open();
     OleDbDataAdapter adapter = new OleDbDataAdapter(search, connection);
     adapter.Fill(база_данныхDataSet.Tables["БД_МИ"]);
     бДМИBindingSource = new BindingSource(база_данныхDataSet, "БД_МИ");
     connection.Close();
}
return DT;
}

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source =  база данных.mdb");
string search = textBox2.Text;
string query = "SELECT * FROM БД_МИ WHERE (clearnedText LIKE '%" + search + "%')";
DataTable DT = new DataTable("БД_МИ");
connection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(query, connection);
база_данныхDataSet.Tables.Add(DT);
adapter.Fill(база_данныхDataSet,"БД_МИ");
бДМИBindingSource = new BindingSource(база_данныхDataSet, "БД_МИ");
dataGridView1.DataSource = бДМИBindingSource;
connection.Close();

adapter.Fill(база_данныхDataSet.Tables["БД_МИ"]);

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;
 
namespace MyBD
{
    public partial class Form1 : Form
    {
        OleDbConnection connection;
        OleDbDataAdapter adapter;
        DataSet dataSet;
        BindingSource bindingSource;
        DataTable DT;
        string Tb;
        public Form1()
        {
            InitializeComponent();
            connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source= Mybd.mdb");
            dataSet = new DataSet();
        }
 
        private void button1_Click(object sender, EventArgs e)  // Открыть БД и искать
        {
            Load_table("SELECT * FROM Table1 WHERE (Name LIKE '%" + textBox1.Text + "%')");
        }
        private void Load_table(string str)
        {
            DataTable DT = new DataTable("Table1");
            connection.Open();
            OleDbDataAdapter adapter = new OleDbDataAdapter(str, connection);
            dataSet.Tables.Add(DT);
            adapter.Fill(dataSet, "Table1");
            bindingSource = new BindingSource(dataSet, "Table1");
            dataGridView1.DataSource = bindingSource;
            connection.Close();
        }
 
        private void button2_Click(object sender, EventArgs e)    // Просто открыть БД 
        {
            Load_table("SELECT * FROM Table1 ");
            dataSet.Tables.Clear();
        }
    }
}

catch{}