Question

.net中session值怎么在.aspx文件中引用

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EAIData %>"
SelectCommand="SELECT
[ProjectNO],
[ProjectName],
[ModifiedBy],
[ModifiedDate],
[UndertakeDate],
undertakeAdminstrator
FROM [tbProjectInfo] where undertakeAdminstrator=???">
</asp:SqlDataSource>
我想把 undertakeAdminstrator 等于页面传过来的Session["UserName"]，请问这要怎么做？

Answer 1

session和application、response、request这些都是内置对象，不需要引用，可直接使用
如String s =Session["username"].ToString()，当然前提是你得把username存到session里去
存的话就直接Session["username"] = "xxxx";

追问

我刚刚进行了问题补充 ，帮忙看一下 谢谢

追答

=???的地方改成'" + Session["UserName"].ToString() + "'"
前提是Session["UserName"]必须有值
Session["UserName"]是个object，必须转换成String才能用+来拼接

Answer 2

string a=Session["session名字"].toString() 这个事赋值

Session["haha"]=“123”; 这个是 开辟一个session的变量，叫做haha。给他赋值为"123"

SelectCommand="SELECT
[ProjectNO],
[ProjectName],
[ModifiedBy],
[ModifiedDate],
[UndertakeDate],
undertakeAdminstrator
FROM [tbProjectInfo] where undertakeAdminstrator=???">
改成

SelectCommand="SELECT
[ProjectNO],
[ProjectName],
[ModifiedBy],
[ModifiedDate],
[UndertakeDate],
undertakeAdminstrator
FROM [tbProjectInfo] where undertakeAdminstrator='"+Session["UserName"].toString()+"'">

Answer 3

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EAIData %>"
SelectCommand="SELECT
[ProjectNO],
[ProjectName],
[ModifiedBy],
[ModifiedDate],
[UndertakeDate],
undertakeAdminstrator
FROM [tbProjectInfo] where undertakeAdminstrator={UserName}">
<SelectParameters>
<asp:SessionParameter Name="UserName" SessionField="UserName" />
</SelectParameters>

追问

报错 undertakeAdminstrator={UserName} 附近 有语法错误

追答

undertakeAdminstrator=@UserName
刚才笔误

Answer 4

<%=Session["UserName"]%> 在前台，试一下。

追问

试了一下 where undertakeAdminstrator='""' 编译通过了，运行报错

追答

断点。错误贴出来