62,071
社区成员
发帖
与我相关
我的任务
分享
<asp:DropDownList ID="StateFilter" runat="server">
<asp:ListItem Value="*">请选择</asp:ListItem>
<asp:ListItem Value="1">通过审核</asp:ListItem>
<asp:ListItem Value="0">未审核</asp:ListItem>
<asp:ListItem Value="3">审核中</asp:ListItem>
<asp:ListItem Value="2">未过通</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:youtrubo_bbsConnectionString %>"
SelectCommand="SELECT * FROM [videos] where cast([state] AS nchar(2))=@state>
<SelectParameters>
<asp:ControlParameter ControlID="StateFilter" Name="state"
PropertyName="SelectedValue" />
</SelectParameters>