如何使用access数据库在DataGridView中进行搜索？

private void btnSearch_Click(object sender, EventArgs e)
{
    string keyword = txtKeyword.Text.Trim(); // 获取搜索关键字

    // 构建SQL查询语句
    string sql = "SELECT * FROM TableName WHERE ColumnName LIKE '%" + keyword + "%'";

    // 执行查询并将结果填充到DataGridView中
    using (OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourDatabase.accdb"))
    {
        OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connection);
        DataTable dataTable = new DataTable();
        adapter.Fill(dataTable);
        dataGridView.DataSource = dataTable;
    }
}