asp.net(C#)中实现多个DropDownList及多个TextBox的多条件查询

这里是通过语句拼接来实现多条件查询的

主要代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default19.aspx.cs" Inherits="Default19" %>

html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


    


    

    

        
            
            
            
            
            
        
        
        
        
            
            
            
            
            
        
        
        
        
            
            
            
            
            
        
        
        
        
        
    
    

   protected void btn_search_Click(object sender, EventArgs e)
    {
        string strfacy = "select * from tOrderReview where 1=1";
        if (!string.IsNullOrEmpty(tb_x1.Text.ToString()))
        {
            strfacy += " and " + DropDownList1.SelectedValue.ToString() + " like '%" + tb_x1.Text.ToString() + "%'";
        }
        if (!string.IsNullOrEmpty(tb_x2.Text.ToString()))
        {
            strfacy += " and " + DropDownList2.SelectedValue.ToString() + " like '%" + tb_x2.Text.ToString() + "%'";
        }
        if (!string.IsNullOrEmpty(tb_x3.Text.ToString()))
        {
            strfacy += " and " + DropDownList3.SelectedValue.ToString() + " like '%" + tb_x3.Text.ToString() + "%'";
        }
        strfacy += " order by OrderID desc";
        //GridBind(strfacy);
    }