早上好,我如何将这个过滤器表达式转换成一个参数化的查询,但仍然显示在网格视图中?现在,如果我搜索%^&%*,它就会崩溃。[UserName], [ClubNumber], [FirstName], [Email], [LastName], [DOB] FROM [Players] order by lastname ASC"></asp:Content>错误:
类似操作符中的
源代码的/>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStringsSelectCommand="SELECT * FROM TBL_BATCH_STAGE WHERE RQUST_KEY=@RequestId ORDER BY [ORDER_NO] ASCOldValuesParameterFormatString="o
更新:如果我在参数中硬编码,查询就能工作--所以它与我向查询添加参数的方式有关 ORDER BY StartDate DESC, [ID] DESC) AS foo INNER JOIN Story AS t ON bar.ID = t.ID
ORDER BY bar.StartDate DESC, bar.[I