前台:
<cc1:AjaxTextBox ID="AjaxTextBox1" runat="server"
οnsearch="AjaxTextBox1_Search"></cc1:AjaxTextBox>
后台:
protected object AjaxTextBox1_Search(object sender, HampWebControl.AjaxTextBox.SearchEventArgs e)
{
string strvalue = AjaxTextBox1.Text.Trim();
string strCon = "Data Source=.;database=ew114;UID=ew114;pwd=123";
string strSql = "select ID,userid from [user] where userid like '%" + strvalue + "%'";
using (SqlConnection conn = new SqlConnection(strCon))
{
conn.Open();
SqlCommand sd = new SqlCommand(strSql, conn);
SqlDataAdapter sa = new SqlDataAdapter(sd);
DataTable dt = new DataTable();
sa.Fill(dt);
return dt;
}
}