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

來源:互聯網
上載者:User

標籤:

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


主要代碼:

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

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

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

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: 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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.