private void GetData(string id) { if (string.IsNullOrEmpty(id)) { return; } string strSql = "Select a.StrategiesName, b.ProjectsCode, b.ProjectsName, b.MissionCode, b.GoalsCode, c.* " + " From Strategies a, Projects b, Activity c " + " Where c.ActivityCode = '" + id + "' And a.StrategiesCode = b.StrategiesCode And b.ProjectsCode = c.ProjectsCode "; DataView dv = Conn.Select(string.Format(strSql)); if (dv.Count != 0) { lblYearB.Text = dv[0]["StudyYear"].ToString(); lblStrategies.Text = dv[0]["StrategiesName"].ToString(); lblProjects.Text = dv[0]["ProjectsName"].ToString(); lblPurpose.Text = dv[0]["Purpose"].ToString(); lblTarget.Text = dv[0]["Target"].ToString(); lblTarget2.Text = dv[0]["Target2"].ToString(); lblProjectsDetail.Text = dv[0]["ActivityDetail"].ToString(); txtActivityCode.Text = dv[0]["ActivityCode"].ToString(); txtActivity.Text = dv[0]["ActivityName"].ToString(); getActivityDetail(dv[0]["ActivityCode"].ToString()); txtEvaluation.Text = dv[0]["Evaluation"].ToString(); txtEvaIndicators.Text = dv[0]["EvaIndicators"].ToString(); txtEvaAssessment.Text = dv[0]["EvaAssessment"].ToString(); txtEvaTool.Text = dv[0]["EvaTool"].ToString(); txtExpected.Text = dv[0]["Expected"].ToString(); lblMission.Text = btc.getMissionName(dv[0]["MissionCode"].ToString()); lblGoals.Text = btc.getGoalsName(dv[0]["GoalsCode"].ToString()); lblStandardNationName.Text = btc.getStandardNationName(false, dv[0]["ProjectsCode"].ToString()); lblStandardMinistryName.Text = btc.getStandardMinistryName(false, dv[0]["ProjectsCode"].ToString()); lblStandard.Text = btc.getStandardName(false, id); lblIndicators.Text = btc.getIndicatorsName(false, id); strSql = "Select *, txtWeightType = Case WeightType When 0 Then '%' When 1 Then '¨Ó¹Ç¹' End, txtCkCriterion = Case CkCriterion When 0 Then 'äÁè¼èÒ¹' When 1 Then '¼èÒ¹' End From Indicators2 Where DelFlag = 0 And ActivityCode = '" + id + "'"; DataView dv1 = Conn.Select(strSql); rptIncicators2.DataSource = dv1; rptIncicators2.DataBind(); } }