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;
}
}
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();
}
public void Rp_list_Bind()
{
string sqlstr = "select * from QUF";
DataTable dt = SqlHelper.ExcuteAdatper(sqlstr);
Rp_list.DataSource = dt;
Rp_list.DataBind();
}
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();
}