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); }
结帖率:66.67%
输入文本框,
按照字母或者文字自动索引前10条!
谁有这样的代码例题,
发到我邮箱里[email protected]
或者粘贴这里!!
谢谢!!!
谢谢!!!
谢谢!!!
谢谢!!!
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);
}