public DataTable ConnMySql(string strRegisterNo)
        {
            try
            {
                DataTable dt = new DataTable("table");
                string constr = IP"server=.;database=DB;uid=sa; pwd=sa";
                string sql = "select * from tablename where ID= ‘"   strNo   "‘";

                SqlDataAdapter adptr = new SqlDataAdapter(sql, constr);
                adptr.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }