private void btnSearch_Click(object sender, EventArgs e)
    {
        OleDbCommand command = new OleDbCommand();
        OleDbDataAdapter db = new OleDbDataAdapter(command);
        DataTable dt = new DataTable();

        if (!string.IsNullOrEmpty(txtSerial.Text))
        {
            try
            {
                connection.Open();
                command.Connection = connection;
                command.Transaction = transaction;
                command.Parameters.Add("@searchSerial", OleDbType.VarWChar).Value = txtSerial.Text;
                string searchFB = "SELECT (SerialNumber) FROM Inventory WHERE SerialNumber = @searchSerial";
                command.CommandText = searchFB;

                db.Fill(dt);
                dgResults.DataSource = dt;
                connection.Close();
            }

            catch (OleDbException ex)
            {
                MessageBox.Show(ex.Message);
                connection.Close();
            }
        }
    }