<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:gamedataConnectionString %>"
SelectCommand="SELECT [id], [title], [category], [swfpic], [viewnum] FROM [gameinfo] WHERE ([category] = @category)">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="9" Name="category"
QueryStringField="category" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
后台aspx.cs取值: string stitle = "";
string scate = SqlDataSource1.SelectParameters["category"].DefaultValue;
为什么只能取到缺省值9??
要取到每个值该怎么做?请教高手啊!~~~~~~~~~
ConnectionString="<%$ ConnectionStrings:gamedataConnectionString %>"
SelectCommand="SELECT [id], [title], [category], [swfpic], [viewnum] FROM [gameinfo] WHERE ([category] = @category)">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="9" Name="category"
QueryStringField="category" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
后台aspx.cs取值: string stitle = "";
string scate = SqlDataSource1.SelectParameters["category"].DefaultValue;
为什么只能取到缺省值9??
要取到每个值该怎么做?请教高手啊!~~~~~~~~~
QueryStringField="category" Type="Int32" />
这个地方好像是可以指定参数提供的控件的把。不提供参数才用默认的9
而且你的代码上也是不管什么情况都是读取默认值的。
要用string[]
DefaultValue="9" Name="category"这儿不是写明是9吗??/
http://www.cnblogs.com/scottckt/archive/2008/08/12/1266208.html
我晕本来不想说的,但是忍不住手养!
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:gamedataConnectionString %>"
SelectCommand="SELECT [id], [title], [category], [swfpic], [viewnum] FROM [gameinfo] WHERE ([category] = @category)">
<SelectParameters>
<asp:QueryStringParameter Name="category"
QueryStringField="category" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>现在我要在aspx.cs里取到category字段的值该如何做?
你要获得category字段的值,可以用
string category= Request.QueryString["category"].ToString();