string NewConn = Server.MapPath("DataBase.MDB");
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider =Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);
string sql = "select * from Member where username ='" + (string)Session["user"] + "'"; OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Member");
TextBox1.Text = ds.Tables[0].Rows[0]["username"].ToString();
TextBox2.Text = ds.Tables[0].Rows[0]["sex"].ToString();
TextBox3.Text = ds.Tables[0].Rows[0]["hobby"].ToString();
查询数据库里的内容,红色部分出错,不知道怎么拿到session的那个值~请各位指教啊~
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider =Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);
string sql = "select * from Member where username ='" + (string)Session["user"] + "'"; OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Member");
TextBox1.Text = ds.Tables[0].Rows[0]["username"].ToString();
TextBox2.Text = ds.Tables[0].Rows[0]["sex"].ToString();
TextBox3.Text = ds.Tables[0].Rows[0]["hobby"].ToString();
查询数据库里的内容,红色部分出错,不知道怎么拿到session的那个值~请各位指教啊~
自然也不能得到值
Session["user"]="";
string sql = "select * from Member where username ='" + Session["user"]==null?"":Session["user"].ToString() + "'";
会话状态可能会过期(默认情况下,在处于不活动状态 20 分钟后过期),而在其中存储的信息可能会丢失。可以使用 sessionState 配置节的 timeout 属性控制会话状态生存期。
string sql = "select * from Member where username ='" + (string)(Session["user"]) + "'";