本来在.CS中定义了SESSION["YYBDM"]这个值,想在ASPX中直接调用,但没有成功;
后来,想先用传入值的方法试试,在链接后加了个 test.aspx?yybdm=0430,然后代码如下,但没有成功。
其中开始的string mstr是测试是否传入成功,结果成功了;
但在下面的SelectCommand= 赋值时,一直没有成功,请高手赐教代码学习下,先谢谢<TD vAlign="middle" align="left" bgColor="#ffffff" colSpan="2" height="2"><DIV align="center"><FONT size="4">
<%string mstr = "SELECT * FROM [v_zhbyz] where orgid='" + Request.QueryString["yybdm"].ToString() + "' ORDER BY orgid,custid"; %>
营业部:<% =mstr %>
<asp:TextBox ID="TextBox3" runat="server" Width="177px">0430</asp:TextBox>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" OnRowDataBound="GridView1_RowDataBound" DataSourceID="SqlDataSource1" PageSize="50" ShowFooter="True">
<Columns>
<asp:BoundField DataField="柜台姓名" HeaderText="柜台姓名" SortExpression="柜台姓名" />
<asp:BoundField DataField="frdb" HeaderText="frdb" SortExpression="frdb" />
</Columns>
</asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:qsbConnectionString %>"
SelectCommand="SELECT * FROM [v_zhbyz] where orgid= @yybdm ORDER BY orgid,custid">
</asp:SqlDataSource>
后来,想先用传入值的方法试试,在链接后加了个 test.aspx?yybdm=0430,然后代码如下,但没有成功。
其中开始的string mstr是测试是否传入成功,结果成功了;
但在下面的SelectCommand= 赋值时,一直没有成功,请高手赐教代码学习下,先谢谢<TD vAlign="middle" align="left" bgColor="#ffffff" colSpan="2" height="2"><DIV align="center"><FONT size="4">
<%string mstr = "SELECT * FROM [v_zhbyz] where orgid='" + Request.QueryString["yybdm"].ToString() + "' ORDER BY orgid,custid"; %>
营业部:<% =mstr %>
<asp:TextBox ID="TextBox3" runat="server" Width="177px">0430</asp:TextBox>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" OnRowDataBound="GridView1_RowDataBound" DataSourceID="SqlDataSource1" PageSize="50" ShowFooter="True">
<Columns>
<asp:BoundField DataField="柜台姓名" HeaderText="柜台姓名" SortExpression="柜台姓名" />
<asp:BoundField DataField="frdb" HeaderText="frdb" SortExpression="frdb" />
</Columns>
</asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:qsbConnectionString %>"
SelectCommand="SELECT * FROM [v_zhbyz] where orgid= @yybdm ORDER BY orgid,custid">
</asp:SqlDataSource>
{
get{return Session["name"]==null?"":Session["name"].ToString();}
}<%=name%>
{
get{return Session["name"]==null?"":Session["name"].ToString();}
}
属性
<%=name%>
Session[""]是否丢失
用SqlDataSource控件进行模糊查询时的SelectCommand
<SelectParameters>
<asp:Parameter .... />
</SelectParameters>
{
get{return Session["name"]==null?"":Session["name"].ToString();}
}
request.querystring获取
public string name
{
get{return ViewSate["name"].ToString();}
set {ViewSate["name"]=value;}
}
<asp:Parameter .... />
</SelectParameters>
这个不会用,能就这个问题实例下?SESSION没丢的,测试过。
SelectCommand="SELECT * FROM [v_zhbyz] where orgid= @mstr ORDER BY orgid,custid">
<SelectParameters>
<asp:Parameter Name="mstr" />
</SelectParameters>
</asp:SqlDataSource>把@mstr 换成 @name也不行,但在前面的
营业部:<% =name%>
这儿能显示正确的数值
SelectCommand="SELECT * FROM [v_zhbyz] where orgid= @name ORDER BY orgid,custid">
<SelectParameters>
<asp:QueryStringParameter Name="name" QueryStringField="yybdm" />
</SelectParameters>
</asp:SqlDataSource>改成上面的取值成功
用QueryStringParameter好像不行
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:qsbConnectionString %>"
SelectCommand=" 后面的怎么写?在.CS中public string name
{
get{return Session["name"]==null?"":Session["name"].ToString();}
}的话,是能在ASPX中调用的:
营业部:<% =name%>
这儿能显示正确的数值;
但就是SQL中怎么调用?
<asp:sessionParameter DefaultValue="0401" Name="name" SessionField="yybdm"/>
</SelectParameters>
</asp:SqlDataSource>改成这样好了