1.在设计模式下,设计查询控件:
<table border="0" cellpadding="4" cellspacing="0" style="width: 100%">
<tr><td bgcolor="#f
<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();
}