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();
            }
        }
    }