aspx:
<asp:Label ID="Label1" runat="server" Text="index_02"></asp:Label><br />
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ZFConnectionString %>"
SelectCommand="SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='<%=Label1.Text; %>' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='<%=Label1.Text; %>')">
</asp:SqlDataSource>
怎么执行的是:
SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='<%=Label1.Text; %>' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='<%=Label1.Text; %>')我想让他执行:
SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='index_02' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='index_02')
<asp:Label ID="Label1" runat="server" Text="index_02"></asp:Label><br />
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ZFConnectionString %>"
SelectCommand="SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='<%=Label1.Text; %>' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='<%=Label1.Text; %>')">
</asp:SqlDataSource>
怎么执行的是:
SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='<%=Label1.Text; %>' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='<%=Label1.Text; %>')我想让他执行:
SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='index_02' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='index_02')
SelectCommand="SELECT [NewsId], [Title], [Description] FROM [News] WHERE NewsTypeID='"+<%=Label1.Text; %>+"' or NewsTypeID in( select NewsTypeid from Newsinfo where parentid='"+<%=Label1.Text; %>+"')">