| 发表于：2007-04-11 11:16:26 楼主 |
我要做想gogo搜索的ajax的自动完成功能,单个控件已经可以实现,但是问题是2个以上就不能实现,光用js不用表格限制控件也能实现多个,但问题是肯定有表格限制地方的,所以求教大哥大姐们.......到底能不能做.
代码如下 <web3dvp:ajaxtextbox id= "search " onfocus= "webkillfocus（) " runat= "server " backgroundcolor= "#eee " divborder= "1px solid #ccc "
divpadding= "2px " divfont= "arial " highlightcolor= "#ffcc00 " callbackfunction= "getsearchitems " scriptfile= "ajax/lookup.js " width= "185px "> </web3dvp:ajaxtextbox>
getsearchitems函数代码如下
[ajaxmethod（)]
public arraylist getsearchitems（string query)
{
//system.io.streamreader m_fs = new system.io.streamreader（query,system.text.encoding.getencoding（ "gb2312 "));
query =server.urldecode（query);
arraylist items = new arraylist（);
string myconnectionstring =
configurationsettings.appsettings[ "connectionstring "];
string myselectquery =
string.format（
"select name,x,y,z from citylife where charindex（ '{0} ',lower（name)) != 0 ",
query);
sqlconnection myconnection = new sqlconnection（myconnectionstring);
sqlcommand mycommand = new sqlcommand（myselectquery, myconnection);
myconnection.open（);
sqldatareader myreader =mycommand.ＥＸＥＣutereader（);
while （myreader.read（))
{
//string sdel = "_building ";
//items.add（myreader.getstring（0));
frame n= new frame（);
n.name=myreader.getstring（0);
n.x=（float)myreader.getdouble（1);
n.y=（float)myreader.getdouble（2);
n.z=（float)myreader.getdouble（3);
items.add（n.name);
}
myreader.close（);
return items;
}
js代码不写了太长 |
|
|
|
|
