public User getContactDetails(int u) { User user = new User(); cmd = new SqlCommand("select name,eContact,address,medicalId from Users WHERE userId=@userId", con); cmd.Parameters.AddWithValue("@userId", u); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { user.eContact= dr["eContact"].ToString(); user.address = dr["address"].ToString(); user.name =dr["name"].ToString(); user.medicalId= dr["medicalId"].ToString(); } dr.Close(); con.Close(); return user; }
protected void Page_Load(object sender, EventArgs e) { Page.DataBind(); if (!IsPostBack) { userId = (int)Session["userId"]; user = dc.getContactDetails(userId); eContactC = user.eContact; nameC = user.name; addressC = user.address; medicalIdC = user.medicalId; medical = dc.getMedicalDetails(userId); allergiesC = medical.allergies; bloodGroupC = medical.bloodGroup; specialConditionC = medical.specialCondition; hs = dc.getHospitalDetails(); } }