protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string    id        = Request.QueryString["dethi"].ToString();
            string    sql_dethi = "select Tende from DETHI where Made='" + id + "'";
            DataTable tb_dethi  = ketnoi.getData(sql_dethi);
            txt_dethi.Text  = tb_dethi.Rows[0][0].ToString().ToUpper();
            txt_dethi2.Text = tb_dethi.Rows[0][0].ToString().ToUpper();
            string sql_Phutnghe = "select * from DONGHO where IDDongho='03'";
            rpt_dongho.DataSource = ketnoi.getData(sql_Phutnghe);
            rpt_dongho.DataBind();

            string sql_docdientu = "select * from CAUHOI where IDNoidung='DoublePassage'";
            Rpt_nghe.DataSource = ketnoi.getData(sql_docdientu);
            Rpt_nghe.DataBind();
            for (int i = 0; i < Rpt_nghe.Items.Count; i++)
            {
                Label a = (Label)Rpt_nghe.Items[i].FindControl("A");
                Label b = (Label)Rpt_nghe.Items[i].FindControl("B");
                Label c = (Label)Rpt_nghe.Items[i].FindControl("C");
                Label d = (Label)Rpt_nghe.Items[i].FindControl("D");
                try
                {
                    string    sql = "select * from DAPAN where IDCauhoi ='1_Double_" + (i + 1) + "'";
                    DataTable tb  = ketnoi.getData(sql);
                    a.Text = tb.Rows[0]["NDDA"].ToString();
                    b.Text = tb.Rows[1]["NDDA"].ToString();
                    c.Text = tb.Rows[2]["NDDA"].ToString();
                    d.Text = tb.Rows[3]["NDDA"].ToString();
                }
                catch {}
            }
        }
    }
Esempio n. 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string    id        = Request.QueryString["dethi"].ToString();
            string    sql_dethi = "select Tende from DETHI where Made='" + id + "'";
            DataTable tb_dethi  = ketnoi.getData(sql_dethi);
            txt_dethi.Text  = tb_dethi.Rows[0][0].ToString().ToUpper();
            txt_dethi2.Text = tb_dethi.Rows[0][0].ToString().ToUpper();

            string sql_Phutnghe = "select * from DONGHO where IDDongho='03'";
            rpt_dongho.DataSource = ketnoi.getData(sql_Phutnghe);
            rpt_dongho.DataBind();

            string sql_hinhanh = "select A.IDCauhoi,C.IDNoidungchitiet, A.Phancauhoi, RTRIM(B.Tenfile)as Tenfile,A.Noidung from CAUHOI A, FILES B, CHITIETNOIDUNG C where A.IDNoidung='Conversation' and C.IDNoidungchitiet=A.IDNoidung and A.IDFile=B.IDFile and A.Made='" + id + "' order by A.IDCauhoi ASC";
            Rpt_nghe.DataSource = ketnoi.getData(sql_hinhanh);
            Rpt_nghe.DataBind();

            for (int i = 0; i < Rpt_nghe.Items.Count; i++)
            {
                Label     a            = (Label)Rpt_nghe.Items[i].FindControl("A");
                Label     b            = (Label)Rpt_nghe.Items[i].FindControl("B");
                Label     c            = (Label)Rpt_nghe.Items[i].FindControl("C");
                Label     d            = (Label)Rpt_nghe.Items[i].FindControl("D");
                string    sql_idcauhoi = "select IDCauhoi from CAUHOI where IDNoidung='Conversation'";
                DataTable tb_idcauhoi  = ketnoi.getData(sql_idcauhoi);
                try
                {
                    string    sql = "select * from DAPAN where IDCauhoi ='" + tb_idcauhoi.Rows[i]["IDCauhoi"].ToString() + "'";
                    DataTable tb  = ketnoi.getData(sql);
                    a.Text = tb.Rows[0]["NDDA"].ToString();
                    b.Text = tb.Rows[1]["NDDA"].ToString();
                    c.Text = tb.Rows[2]["NDDA"].ToString();
                    d.Text = tb.Rows[3]["NDDA"].ToString();
                }
                catch { }
            }
            try
            {
                DataTable tb_filenghe = ketnoi.getData(sql_hinhanh);
                filenghe = tb_filenghe.Rows[0]["Tenfile"].ToString();
            }
            catch { }
        }
    }