如何让SQL Where子句处理两个StringVariables？

Question

我向新页面传递了两个StringQueries：/Find.aspx?Color=Blue&Shape=Round

在我的Products.aspx中，我有一个带有SelectCommand的GridView：

SelectCommand="SELECT DISTINCT [Name], [Price], [ProductNo] 
               FROM [MSD_Store] WHERE ([Color] = ?)" 

如何让Where子句处理两个StringVariables？

Answer 1

只需添加SQL查询的必要部分并定义另一个查询字符串参数：

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    SelectCommand="SELECT DISTINCT [Name], [Price], [ProductNo] FROM [MSD_Store] WHERE ([Color] = ?) AND ([Shape] = ?)">
    <SelectParameters>
        <asp:QueryStringParameter QueryStringField="Color" Name="color" />
        <asp:QueryStringParameter QueryStringField="Shape" Name="shape" />
    </SelectParameters>
</asp:SqlDataSource>

Answer 2

简单地做

SelectCommand: SelectCommand="SELECT DISTINCT Name，Price，SELECT DISTINCT Name，Price，ProductNo FROM WHERE ( MSD_Store =？ProductNo= ?)

然后添加另一个参数定义，读取查询字符串值

Answer 3

你是说这个吗？

SELECT DISTINCT [Name], [Price], [ProductNo] 
FROM [MSD_Store] WHERE ([Color] = ?) AND ([Shape] = ?)

通过“两个”字符串变量？