I've got a datagridview object that shows that shows the data from an SQL database. When a user searches by Customer ID I want the datagridview to show the correct record. So far I have the code below but it doesn't work, i'm not exactly sure if i'm on the right path, any ideas?

```
private void btnCustomerID_Click(object sender, EventArgs e)
    {
        if (txtCustomerID.TextLength == 0)
        {
            MessageBox.Show("Please enter a Customer ID to search by Customer ID");
            txtCustomerID.Focus();
        }
        else
        {

            String ID = txtCustomerID.Text;
            String sqlQuery = (sqlCommandCustomer.CommandText = ("SELECT * FROM Customers WHERE [CustomerID] LIKE ID"));
            dgCustomers.DataSource = sqlQuery;

        }

    }

```