asp.net(C#)中實現多個DropDownList及多個TextBox的多條件查詢，

最後更新：2015-01-30 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

這裡是通過語句拼接來實現多條件查詢的

主要代碼：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default19.aspx.cs" Inherits="Default19" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server">    <title></title></head><body>    <form id="form1" runat="server">    <div>        <asp:DropDownList ID="DropDownList1" runat="server" Width="80px">            <asp:ListItem Text="序號" Value="SerialNumber" />            <asp:ListItem Text="客戶代碼" Value="CustomCode" />            <asp:ListItem Text="客戶PO" Value="CustomPO" />            <asp:ListItem Text="是否急單" Value="OrderGrade" />            <asp:ListItem Text="申請人" Value="ApplicantName" />        </asp:DropDownList>        <asp:TextBox ID="tb_x1" runat="server" Width="140px">        </asp:TextBox>        <asp:DropDownList ID="DropDownList2" runat="server" Width="80px">            <asp:ListItem Text="序號" Value="SerialNumber" />            <asp:ListItem Text="客戶代碼" Value="CustomCode" />            <asp:ListItem Text="客戶PO" Value="CustomPO" />            <asp:ListItem Text="是否急單" Value="OrderGrade" />            <asp:ListItem Text="申請人" Value="ApplicantName" />        </asp:DropDownList>        <asp:TextBox ID="tb_x2" runat="server" Width="140px">        </asp:TextBox>        <asp:DropDownList ID="DropDownList3" runat="server" Width="80px">            <asp:ListItem Text="序號" Value="SerialNumber" />            <asp:ListItem Text="客戶代碼" Value="CustomCode" />            <asp:ListItem Text="客戶PO" Value="CustomPO" />            <asp:ListItem Text="是否急單" Value="OrderGrade" />            <asp:ListItem Text="申請人" Value="ApplicantName" />        </asp:DropDownList>        <asp:TextBox ID="tb_x3" runat="server" Width="140px">        </asp:TextBox>        <asp:Button ID="btn_search" runat="server" Text="檢索" OnClick="btn_search_Click">        </asp:Button>    </div>    </form></body></html>

   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);    }

大體情況就是這個樣子了，蠻好用的，比我以前用的方法簡單多了

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More