Zrlhappy的博客
                               从今天起, 做一个幸福的人
                                    喂马, 劈柴, 周游世界
                                    从今天起, 关心粮食和蔬菜
                                    我有一所房子, 面朝大海, 春暖花开
                                    给每一条河每一座山取一个温暖的名字
                                    我也愿面朝大海, 春暖花开……
  //查找功能。

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

      SqlDataSource2.SelectCommand = res;

      GridView2.DataSourceID = "SqlDataSource2";

      GridView2.DataBind();

}

posted on 2006-03-10 09:44  zrlhappy  阅读(358)  评论(0编辑  收藏  举报