给gridview加入查找（搜索）功能

1．在设计模式下，设计查询控件：

<table border="0" cellpadding="4" cellspacing="0" style="width: 100%">

            <tr><td bgcolor="#f7f7de" colspan="2" style="height: 18px" valign="bottom"> 关键字:

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

                   <asp:Button ID="Button1" runat="server"  OnClick="Button1_Click"  Text="查找" /></td>

            </tr>

        </table>

2．在.cs代码模式下，写Button1_Click事件，用sql语句查询。代码如下：

    protected void Button1_Click(object sender, EventArgs e)

    {

      string res = "SELECT [ArticleID], [Title], [Editor], [UpdateTime] FROM [Article] WHERE ( [key] like '%" + TextBox1.Text.ToString() + "%') Order by [ArticleID] Desc";

      SqlDataSource1.SelectCommand = res;

      GridView1.DataSourceID = "SqlDataSource1";

      GridView1.DataBind();

}
把SELECT语句中的字段改成你绑定到的表中的字段。