protected void Show(int Id) { Business.HR.EmployeeMaster ObjBelEmployeeMaster = new Business.HR.EmployeeMaster(); Entity.HR.EmployeeMaster ObjElEmployeeMaster = new Entity.HR.EmployeeMaster(); ObjElEmployeeMaster.EmployeeMasterId = Id; SqlDataReader dr = ObjBelEmployeeMaster.ViewEmployeeById(ObjElEmployeeMaster); while (dr.Read()) { lblEmployeeName.Text = dr["EmployeeName"].ToString(); Image1.ImageUrl = dr["Image"].ToString(); lblgender.Text = dr["GenderId"].ToString(); lbldob.Text = dr["DOB"].ToString(); lblmaratorialStatus.Text = dr["MaritalStatus"].ToString(); lblreligion.Text = dr["ReligionId_FK"].ToString(); lblBloodGroup.Text = dr["BloodGroup"].ToString(); lblPersonalMobileNumber.Text = dr["PersonalMobileNo"].ToString(); lblofficialNumber.Text = dr["OfficeMobileNo"].ToString(); lblpersonalEmailId.Text = dr["PersonalEmailId"].ToString(); lblOfficeEmailId.Text = dr["OfficeEmailId"].ToString(); lblReferenceEmployee.Text = dr["ReferenceEmployeeId"].ToString(); lblpAddress.Text = dr["pAddress"].ToString(); lblCityName.Text = dr["CityName"].ToString(); lblPpin.Text = dr["pPIN"].ToString(); lblDesignationName.Text = dr["DesignationName"].ToString(); lblDOJ.Text = dr["DOJ"].ToString(); lblPANNo.Text = dr["PANNo"].ToString(); lbltAddress.Text = dr["tAddress"].ToString(); lbltCityId_FK.Text = dr["tCityId_FK"].ToString(); lbltPINMasterId_FK.Text = dr["tPINMasterId_FK"].ToString(); } }