想输入用户的ID号,然后在本页面提交,并验证它是否存在,然后,如果存在则将它提交到charge页面,这时就要用SESSION去保存用户ID号,然后在charge.aspx之个页面用这个ID号作为索引条件,但一直有错.两个页面的代码如下:
void Submitbtn_click(Object sender,EventArgs E)
    {
    SqlConnection conn=new SqlConnection("Persist Security Info=false;database=datac;server=.;uid=sa;pwd=sql");
    string queryStr="select user_id from datainfo where user_id='"+Request.Form["UserID"]+"' ";
    SqlDataAdapter userAdapter= new SqlDataAdapter(queryStr,conn);
    DataSet userSet=new DataSet();
    userAdapter.Fill(userSet, "datainfo");
    if(userSet.Tables["datainfo"].Rows.Count==0)
        {
        Message.Text="没有这个用户,请重新输入";
        return;
        }
    Session.Add("user", UserID);

    Response.Redirect("charge.aspx");
      }
.....
<asp:Button id="SubmitBtn" OnClick="Submitbtn_click" runat="server" Text="查询" />

charge.aspx用法:
void Page_Load()
{
    

    ConnectData();
    querystr="select * from datainfo where user_id=["user"] " ;
    stuadapter=new SqlDataAdapter(querystr,nwconn);
    stuadapter.Fill(stuset,"datainfo");
    if(!Page.IsPostBack)
    {
    BindGrid();
    }
}
但好像不成功呢.