private void SetQuestionnaireForm(long vID) { DbTrans trans = new DbTrans(); trans.CreateTransaction(); QuestionnaireENG eng = new QuestionnaireENG(); QuestionnairePara para = eng.GetQuestionnarePara(vID, trans); txtID.Text = para.ID.ToString(); txtQuestionnaireName.Text = para.QUESTIONNAIRE_NAME; txtObjective.Text = para.OBJECTIVE; txtDesc.Text = para.DESCRIPTION; chkActive.Checked = (para.ACTIVE == 'Y'); if (para.ID != 0){ TabContainer1.Visible = true; } DataTable dt = eng.GetQuestionListDT(vID, trans); if (dt.Rows.Count > 0) { gvQuestion.DataSource = dt; gvQuestion.DataBind(); } trans.CommitTransaction(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { DbTrans trans = new DbTrans(); trans.CreateTransaction(); DataTable dt; //dt.Columns.Add("id"); //dt.Columns.Add("section_name"); //for (int i = 0; i <= 5; i++) { // DataRow dr = dt.NewRow(); // dr["id"] = (i+1); // dr["section_name"] = "ส่วนที่ " + (i+1) + " กกกกกกกกกกกกกกกกกกก"; // dt.Rows.Add(dr); //} if (Request["id"] != null) { QuestionnaireENG eng = new QuestionnaireENG(); QuestionnairePara para = new QuestionnairePara(); para = eng.GetQuestionnarePara(Convert.ToInt64(Request["id"]), trans); txtID.Text = para.ID.ToString(); lblQusitionnaireName.Text = para.QUESTIONNAIRE_NAME; lblQuestionnaireObjective.Text = para.OBJECTIVE; lblQuestionnaireDesc.Text = para.DESCRIPTION; dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(Request["id"]), trans); gvSection.DataSource = dt; gvSection.DataBind(); trans.CommitTransaction(); } } }