autocomplete
http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx
全文检索
String connStr = @"";
String sql = "select id,name from Tb where name like '%"+name+"%'";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand sd = new SqlCommand(sql, conn);
SqlDataAdapter sa = new SqlDataAdapter(sd);
DataTable dt = new DataTable();
sa.Fill(dt);
}