通过asp.net中的复选框过滤搜索结果 [英] Filter search result by check box in asp.net

问题描述

我在网上购物网站工作。因此，为了搜索产品，我需要根据复选框列表显示搜索结果，并在数据集中显示结果。所以请帮助我..提前感谢....

I am working for an online shopping website. So for searching the products I need to show the search results according to checking the check box lists and show the results in a data set. So please help me.. Thanks in advance....

推荐答案

private string GetSql()
{
    bool a = true;
    bool b = true;

    System.Text.StringBuilder sb = new System.Text.StringBuilder();

    sb.AppendFormat("SELECT * FROM mytable WHERE 1 = 1");

    if (a)
        sb.AppendFormat(" AND `aa` = 1");
    if (b)
        sb.AppendFormat(" AND `bb` = 1");

    sb.AppendFormat(";");

    return sb.ToString();
}

这篇关于通过asp.net中的复选框过滤搜索结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！