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

2007-08-01 16:30

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

前台加上搜索：

<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>

后台代码：  

  protected void Button1_Click(object sender, EventArgs e)

    {

        string res = "SELECT * FROM [city] WHERE ( [cityName] like '%" + TextBox1.Text.ToString() + "%') Order by [cityID] Desc";

        SqlDataSource1.SelectCommand = res;

        GridView1.DataSourceID = "SqlDataSource1";

        GridView1.DataBind();

}