如何通过viewstate值绑定SqlDataSource? [英] How to bind SqlDataSource by viewstate value?
本文介绍了如何通过viewstate值绑定SqlDataSource?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想通过viewstate值绑定SqlDataSource,我在where语句中使用它
这是HTML中的SqlDataSource代码:
I want to bind SqlDataSource by viewstate value, I used it in where statement
This the SqlDataSource code in HTML:
<asp:SqlDataSource ID="SeatsDS" runat="server" ConnectionString="<%$ ConnectionStrings:CSCinema %>" SelectCommand="SELECT * FROM [ShowRoomSeat] WHERE ([ShowRoomID] = @ShowRoomID)">
<SelectParameters>
<asp:Parameter DefaultValue="ViewState("RoomID")" Name="ShowRoomID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
但是没有成功..
这是ViewState:ViewState(RoomID)
But it didn't successful..
this is the ViewState : ViewState("RoomID")
推荐答案
ConnectionStrings:CSCinema%> SelectCommand = SELECT * FROM [ShowRoomSeat] WHERE([ShowRoomID] = @ShowRoomID) >
< ; SelectParameters >
< asp:参数 DefaultValue = ViewState( RoomID) 名称 = ShowRoomID 类型 = Int32 / >
< < span class =code-leadattribute> / SelectParameters >
< / asp:SqlDataSource >
ConnectionStrings:CSCinema %>" SelectCommand="SELECT * FROM [ShowRoomSeat] WHERE ([ShowRoomID] = @ShowRoomID)"> <SelectParameters> <asp:Parameter DefaultValue="ViewState("RoomID")" Name="ShowRoomID" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>
但它没有成功..
这是ViewState:ViewState(RoomID)
But it didn't successful..
this is the ViewState : ViewState("RoomID")
这篇关于如何通过viewstate值绑定SqlDataSource?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文