Ejemplo n.º 1
0
        public void Rp_list_Bind()
        {
            string id = Request.QueryString["id"];

            string    sqlQ = "SELECT * from QUF where QU01 = '" + id + "'";
            DataTable tb   = SqlHelper.ExcuteAdatper(sqlQ);

            TITLE.Text   = tb.Rows[0]["QU02"].ToString();
            CONTENT.Text = tb.Rows[0]["QU03"].ToString();


            string sql = "SELECT * from ANF where QU01 = '" + id + "'";

            if (SqlHelper.ExcuteReader(sql).Read())
            {
                Q_null.Visible = false;
                DataTable dt = SqlHelper.ExcuteAdatper(sql);
                Rp_list.DataSource = dt;
                Rp_list.DataBind();
            }
            else
            {
                Q_null.Visible = true;
            }
        }
Ejemplo n.º 2
0
        public void Rp_list_Bind(string like)
        {
            string    sqlstr = "select * from QUF where QU02 like '%" + like + "%' or QU03 like '%" + like + "%'";
            DataTable dt     = SqlHelper.ExcuteAdatper(sqlstr);

            Rp_list.DataSource = dt;
            Rp_list.DataBind();
        }
Ejemplo n.º 3
0
        public void Rp_list_Bind()
        {
            string    sqlstr = "select * from QUF";
            DataTable dt     = SqlHelper.ExcuteAdatper(sqlstr);

            Rp_list.DataSource = dt;
            Rp_list.DataBind();
        }
Ejemplo n.º 4
0
        protected void Button3_Click(object sender, EventArgs e)
        {
            myQuestion.Visible = true;
            string    sqlstr = "select * from QUF where US02 = '" + Session["S_user"].ToString() + "'";
            DataTable dt     = SqlHelper.ExcuteAdatper(sqlstr);

            Rp_list.DataSource = dt;
            Rp_list.DataBind();
        }