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语句中的字段改成你绑定到的表中的字段。