private void SetCombo() { DbTrans trans = new DbTrans(); trans.CreateTransaction(); QuestionnaireENG eng = new QuestionnaireENG(); DataTable dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(txtID.Text), trans); if (dt.Rows.Count > 0) { cmbSectionID.SetItemList(dt, "section_name", "id"); } DataTable dtC = eng.GetChoiceTypeList(trans); if (dtC.Rows.Count > 0) { cmbChoiceTypeID.SetItemList(dtC, "choice_type_name", "id"); } trans.CommitTransaction(); }
private void SetSectionList() { if (txtID.Text != "0") { DbTrans trans = new DbTrans(); trans.CreateTransaction(); QuestionnaireENG eng = new QuestionnaireENG(); DataTable dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(txtID.Text), trans); if (dt.Rows.Count > 0) { gvQuestionnaireSection.DataSource = dt; gvQuestionnaireSection.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(); } } }