private void buttonSearch_Click(object sender, EventArgs e)
        {
            int len = textBoxSearch.TextLength;
            string realString = "";
            char[] strArry = textBoxSearch.Text.ToArray();
            for (int i = len; i > 0; i--)
            {
                realString = "%" + strArry[i - 1] + realString;
            }
            string sql = "select * from EquipmentInformation where DeviceID LIKE'" + realString + "%'" +
                " or DeviceType LIKE'" + realString + "%'" +
                " or DeviceLocation LIKE'" + realString + "%'" +
                " or DeviceLendSituation LIKE'" + realString + "%'" +
                " or DeviceStatus LIKE'" + realString + "%'";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "EquipmentInformation");
            dataGridView1.DataSource = ds;
            dataGridView1.DataSource = ds.Tables["EquipmentInformation"];
        }