搜索功能的实现

guwen1991

于 2013-10-06 21:38:34 发布

阅读量982

点赞数

分类专栏： asp.net

本文链接：https://blog.youkuaiyun.com/oGuWen1/article/details/12358175

版权

asp.net 专栏收录该内容

14 篇文章

订阅专栏

本文演示了如何使用C#编写SQL查询并利用Session存储查询结果，通过筛选条件优化查询效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 protected void Button1_Click(object sender, EventArgs e)
    {
        string table = ddlSearchType.SelectedValue.ToString();
        string keyType = ddlKeyType.SelectedValue.ToString();
        string keys = txtKey.Text;
        string sql;
        if (txtTerminal.Text != "")
        {
            sql = "select * from " + table + " where " + keyType + " like '%" + keys + "%' and  terminal like '%" + txtTerminal.Text + "%'";
        }
        else
        {
            sql = "select * from " + table + " where " + keyType + " like '%" + keys + "%'";
        }
        Session["searchSql"] = sql;
        Session["searchType"] = ddlSearchType.SelectedValue.ToString();
        Response.Redirect("searchList.aspx");
    }