基于AJAX的自动完成功能
现在问题是我输入英文能查出记录,我输入中文查不出
相关代码如下:
<script language="javascript" src="lookup.js"></script>
<script language="jscript">
mainLoop = function()
{
val = escape(queryField.value);
if (lastVal != val)
{
var response = ch41.AutoComplete.GetSearchItems(val);
showQueryDiv(response.value);
lastVal = val;
}
setTimeout('mainLoop()', 100);
return true;
}
</script>
<input name="search" type="text" id="search" autocomplete="off" runat="server">
[AjaxMethod()]
public ArrayList GetSearchItems(string query)
{
ArrayList items = new ArrayList();
SqlConnection myConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["cars"]);
string mySelectQuery =string.Format("select cartypename from tbl_car_info where CHARINDEX('{0}',LOWER(cartypename)) = 1",query);
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
myConnection.Open();
SqlDataReader myReader =myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myReader.Read())
{
items.Add(myReader.GetString(0));
}
myReader.Close();
return items;
}
不知道是什么原因,请哪位老大帮忙!
|