protected void Page_Load(object sender, EventArgs e)
        {
            ddlCountries.DataSource     = handler.BLL_GetAllCountries();
            ddlCountries.DataTextField  = "CountryDescription";
            ddlCountries.DataValueField = "CountryID";
            ddlCountries.DataBind();

            ddlCities.DataSource     = handler.BLL_GetAllCities();
            ddlCities.DataTextField  = "CityDescription";
            ddlCities.DataValueField = "CityID";
            ddlCities.DataBind();

            int studentNo           = 213456854;                        /////////////////////////////////////////////////////////
            UspGetStudentProfile vs = handler.BLL_GetStudentProfile1(studentNo);

            txtStudentNo.Text   = "215333608";
            txtFirstName.Text   = vs.studentFirstName;
            txtEmail.Text       = vs.studentEmail;
            txtLastName.Text    = vs.studentLastName;
            txtDateofBirth.Text = vs.studentDateofBirth.ToString();
            //txtc.Text = vs.countryDescription.ToString();
            //ddlCities.Text = vs.cityDescription.ToString();
            txtEmail.Text     = vs.studentEmail;
            txtContactNo.Text = vs.studentContactNo;
            //txtIndustry.Text = vs.industryDescription.ToString();
            //txtQualifications.Text = vs.qualificationDescription.ToString();
            txtSkills.Text = vs.skillDescription.ToString();

            if (vs.driversLicense == "yes")
            {
                rbtnDriversYes.Checked = true;
            }
            else
            {
                rbtnDriversNo.Checked = true;
            }
            //byte[] bytes = (byte[])vs.studentProfilePicture;
            //string base64String = Convert.ToBase64String(bytes);
            //Image1.ImageUrl = "data:image/png;base64," + bytes;

            //DataTable dt = (DataTable)Session["dt"];
            //Image1.ImageUrl = dt.Rows[0][4].ToString() + vs.StudentProfilePicture;

            //Image1.ImageUrl = base64String;
            txtStudUsername.Text = vs.studentUsername;
            txtStudPassword.Text = vs.studentPassword;
            lblLastUpdated2.Text = vs.lastUpdate.ToString();
        }