protected void Page_Load(object sender, EventArgs e) { DataAccessLayer dao = new DataAccessLayer(); if (!String.IsNullOrEmpty(Request.QueryString["agentID"])) { param = Convert.ToInt32(Request.QueryString["agentID"]); SqlDataReader reader; reader = dao.SelectUserByID(param); while (reader.Read()) { agentName.InnerText = reader.GetString(2).ToString(); agentDesc.InnerText = reader.GetString(9).ToString(); agentEmail.InnerText = reader.GetString(5).ToString(); agentPhone.InnerText = reader.GetString(3).ToString(); agentSkype.InnerText = reader.GetString(11).ToString(); string profPic = reader.GetString(12); propUserName.Value = agentEmail.InnerText.ToString(); agentProfile.ImageUrl = "userassets/" + reader.GetString(5) + "/" + profPic; SqlDataReader reader2 = dao.GetUserPropertiesbyAgentID(param, Constants.isApproved); Repeater1.DataSource = reader2; Repeater1.DataBind(); } } else { Response.Redirect("Error-404.aspx"); } }