实现gridview模糊搜索

最新推荐文章于 2023-01-06 13:17:06 发布

原创最新推荐文章于 2023-01-06 13:17:06 发布 · 1.3k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#asp #textbox #string #server #button #search

asp.net 2.1 专栏收录该内容

31 篇文章

订阅专栏

本文介绍如何在ASP.NET中使用GridView控件结合TextBox和DropDownList实现动态搜索功能。通过设置WHERE子句并利用ControlParameter参数传递搜索条件，实现对Customers表中CustomerID和CompanyName字段的模糊查询。

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

1、添加控件如图：

2、配置gridview1的数据源，选择customers表的CustomerID、CompanyName、ContactName、Country字段。然后点“WHERE”进入“添加WHERE”子句界面，“列”选择CustomerID，“运算符”为like,"源"为control，“控件id”为TextBox1。点"添加"就可以了。然后再同样的方式设置CompanyName like DropDownList1 。点添加，就可以了。3、双击“Search”按钮进入Default.aspx.cs添加代码段如下：

protected void Button1_Click(object sender, EventArgs e)

{

SqlDataSource1.SelectCommand = "SELECT [CustomerID], [CompanyName], [ContactName],

[Country] FROM [Customers] WHERE (([CustomerID] LIKE '%' + @CustomerID + '%') AND ([CompanyName]

LIKE '%' + @CompanyName + '%'))";

}

呵呵，这个SELECT语句我是从Default.aspx页面拿过来的。
然后把Default.aspx里原来的SELECT语句改为很简单的

SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [Country] FROM [Customers] "

4、对DropDownList的设置如下：

     <asp:DropDownList ID="DropDownList1" runat="server">
        <asp:ListItem Selected=True></asp:ListItem>
        <asp:ListItem >a</asp:ListItem>
        <asp:ListItem >aa</asp:ListItem>
        <asp:ListItem >ab</asp:ListItem>

</asp:DropDownList>

Selected=True相当是DropDownList的默认值。

5、这样会看不到东西，要把

<asp:ControlParameter ControlID="TextBox1" Name="CustomerID" PropertyName="Text"

Type="String"/>

<asp:ControlParameter ControlID="DropDownList1" Name="CompanyName"

PropertyName="SelectedValue"

Type="String" />

</SelectParameters>

改为：

<asp:ControlParameter ControlID="TextBox1" Name="CustomerID" PropertyName="Text"

Type="String" ConvertEmptyStringToNull="False"/>

<asp:ControlParameter ControlID="DropDownList1" Name="CompanyName"

PropertyName="SelectedValue"

Type="String" ConvertEmptyStringToNull="False" />

</SelectParameters>

6、OK了！

下面提供代码：

一、Default.aspx的代码：

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

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

</head>

<body>

<div>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="search" Width="88px" /><br />

<asp:DropDownList ID="DropDownList1" runat="server">

<asp:ListItem Selected=True></asp:ListItem>

<asp:ListItem >a</asp:ListItem>

<asp:ListItem >aa</asp:ListItem>

<asp:ListItem >ab</asp:ListItem>

</asp:DropDownList>

<br />

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"

AutoGenerateColumns="False" DataKeyNames="CustomerID" DataSourceID="SqlDataSource1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AutoGenerateEditButton="True">

<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />

<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />

<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />

<asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />

<asp:TemplateField HeaderText="City">

<asp:Label ID="Label1" runat="server" Text='<%# Bind("City") %>' Width="184px"></asp:Label>

</ItemTemplate>

<asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind ("City") %>' DataSourceID="SqlDataSource1" DataTextField="City" DataValueField="City">

</asp:DropDownList>

</EditItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [Country], [City] FROM [Customers]"

DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = @CustomerID"

InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [Country], [City]) VALUES (@CustomerID, @CompanyName, @ContactName, @Country, @City)"

UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactName] = @ContactName, [Country] = @Country, [City] = @City WHERE [CustomerID] = @CustomerID">

<asp:Parameter Name="CustomerID" Type="String" />

</DeleteParameters>

<asp:Parameter Name="CompanyName" Type="String" />

<asp:Parameter Name="ContactName" Type="String" />

<asp:Parameter Name="Country" Type="String" />

<asp:Parameter Name="City" Type="String" />

<asp:Parameter Name="CustomerID" Type="String" />

</UpdateParameters>

<asp:Parameter Name="CustomerID" Type="String" />

<asp:Parameter Name="CompanyName" Type="String" />

<asp:Parameter Name="ContactName" Type="String" />

<asp:Parameter Name="Country" Type="String" />

<asp:Parameter Name="City" Type="String" />

</InsertParameters>

<asp:ControlParameter ControlID="TextBox1" Name="CustomerID" PropertyName="Text"

Type="String" ConvertEmptyStringToNull="False"/>

<asp:ControlParameter ControlID="DropDownList1" Name="CompanyName"

PropertyName="SelectedValue"

Type="String" ConvertEmptyStringToNull="False" />

</SelectParameters>

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

二、Default.aspx.cs代码：

protected void Button1_Click(object sender, EventArgs e)

{

SqlDataSource1.SelectCommand = "SELECT [CustomerID], [CompanyName], [ContactName], [Country], [City] FROM [Customers] WHERE (([CustomerID] LIKE '%' + @CustomerID + '%') AND ([CompanyName] LIKE '%' + @CompanyName + '%'))";

}