会话值检索 [英] session value retrievel

问题描述

我有一个登录页面，我在其中创建一个会话并从数据库中获取一个memberId的值作为
session ["_ memberid"] = memberId.tostring(); (如果这是错误的话，请告诉我)
现在我认为我的会话将从数据库中记录一个成员ID.
现在我想要其他页面detail.aspx
上的那个整数成员ID 如何找回.?
请帮助我

I have a login page where i create a session and took a value of memberId from database as
session["_memberid"]=memberId.tostring(); (tell me if this is wrong)
now i think my session will pic a member Id from database.
now i want that integer member Id on some other page detail.aspx
how to retrieve that.?
please help me

推荐答案

进行选择查询以检索您的MemberId，
示例:

To Make Select Query to retrive your MemberId,
Example:

SqlConnection con=new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=shoping;Integrated Security=True");
        con.Open();
SqlCommand cmd=new SqlCommand("Select memberid from Members Where membername='"+TextBox1.Text+"'",con);
SqlDataReader dr = cmd.ExecuteReader();
      while (dr.Read())
      {
string id=dr.GetValue[0].ToString();
Session["_memberid"]=id;
}

It's easy-you just need to typecast the value stored in session 

public partial class ClassA : System.Web.UI.Page
{
    int ID;
    protected void Page_Load(object sender, EventArgs e)
    {
       ID=Convert.toInt32(Session["EmpID"]);
    }
}

这篇关于会话值检索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！