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(); }