如何在 asp.net 中输入 SQL 数据源的文本"<"和">"

Question

我不能把这个sqlcommand放到SqlDataSource里。

<asp:SqlDataSource ID="dsOperator" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"
        SelectCommand=" select '+' id,'+' txt from dual  
                        union all select '-','-' from dual
                         union all select '*','*' from dual
                         union all select '/','/' from dual
                         union all select '>','>' from dual
                         union all select '<','<' from dual
                         union all select '%','%' from dual
                         union all select '||','||' from dual
                         union all select '=','=' from dual
                         union all select '!=','!=' from dual
                         union all select '>=','>=' from dual
                         union all select '<=','<=' from dual
                         union all select 'LIKE','IS NULL' from dual
                         union all select 'BETWEEN','BETWEEN' from dual
                         union all select 'IN','IN' from dual
                         union all select 'NOT','NOT' from dual
                         union all select 'NOT IN','NOT IN' from dual
                         union all select 'AND','AND' from dual
                         union all select 'OR','OR' from dual
                         union all select 'ANY SOME','ANY SOME' from dual
                         union all select 'ALL','ALL' from dual
                        union all select 'EXISTS','EXISTS' from dual
                        union all select 'ESCAPE','ESCAPE' from dual
                        union all select 'UNION','UNION' from dual
                        union all select 'UNION ALL','UNION ALL' from dual
                        union all select 'INTERSECT','INTERSECT' from dual
                        union all select 'MINUS','MINUS' from dual " ProviderName="<%$ ConnectionStrings:DefaultConnection.ProviderName %>"></asp:SqlDataSource>             

这是我的错误。

在此处输入图像描述

Answer 1

我可以通过输入>和<来编辑它

asp:SqlDataSource ID="dsOperator" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"
        SelectCommand=" select '+' id,'+' txt from dual  
                        union all select '-','-' from dual
                         union all select '*','*' from dual
                         union all select '/','/' from dual
                         union all select '&gt;','&gt;' from dual
                         union all select '&lt;','&lt;' from dual
                         union all select '%','%' from dual
                         union all select '||','||' from dual
                         union all select '=','=' from dual
                         union all select '!=','!=' from dual
                         union all select '&gt;=','&gt;=' from dual
                         union all select '&lt;=','&lt;=' from dual
                         union all select 'LIKE','IS NULL' from dual
                         union all select 'BETWEEN','BETWEEN' from dual
                         union all select 'IN','IN' from dual
                         union all select 'NOT','NOT' from dual
                         union all select 'NOT IN','NOT IN' from dual
                         union all select 'AND','AND' from dual
                         union all select 'OR','OR' from dual
                         union all select 'ANY SOME','ANY SOME' from dual
                         union all select 'ALL','ALL' from dual
                        union all select 'EXISTS','EXISTS' from dual
                        union all select 'ESCAPE','ESCAPE' from dual
                        union all select 'UNION','UNION' from dual
                        union all select 'UNION ALL','UNION ALL' from dual
                        union all select 'INTERSECT','INTERSECT' from dual
                        union all select 'MINUS','MINUS' from dual " ProviderName="<%$ ConnectionStrings:DefaultConnection.ProviderName %>"></asp:SqlDataSource>