VB.NET+AJAXËÑË÷½¨Ò鹦ÄܵÄʵÏÖ
IDE£ºVisual Web Developer 2008 Express Edition
Êý¾Ý¿â£ºAccess 2007
µ½http://www.asp.net/ajax/downloads/ÏÂÔØAJAX Control Toolkit£¬½«AjaxControlToolkit.dll¿½±´µ½ÏîÄ¿µÄbinĿ¼Ï£¬ÔÚ¹¤¾ßÀ¸ÖÐÒýÈë¡£
WebServiceµÄ´úÂ룺£¨aaa.asmx£©
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim dbname As String
dbname = Server.MapPath("location.accdb")
myConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;DATA Source=" & dbname)
myConnection.Open()
Dim list As New List(Of String)
myCommand = New OleDbCommand("SELECT DISTINCT(columnName) from tableName WHERE columnName LIKE '" + prefixText & "%" + "'", myConnection)
Dim reader As OleDbDataReader = myCommand.ExecuteReader()
Do While reader.Read
list.Add(reader.GetString(0))
Loop
Return list.ToArray()
End Function
FORMÖеĴúÂ룺£¨aaa.aspx£©
<asp:TextBox ID="txtNo" runat="server" autopostback="true" Columns="50"></asp:TextBox>
<ajaxToolkit:AutoCompleteExtender ID="txtNo_AutoCompleteExtender" runat="server" Enabled="True" ServiceMethod="GetCompletionList" ServicePath="aaa.asmx" TargetControlID="txtNo" MinimumPrefixLength="1" EnableCaching ="true">
</ajaxToolkit:AutoCompleteExtender>
ÒÔÉϼ´¿É¡£
AJAXÈÕÆÚ¿Ø¼þµÄʹÓÃÒ²ºÜ·½±ã£¬È磺
<asp:TextBox ID="txtDate" runat="server" Columns="24"></asp:TextBox>
<ajaxToolkit:CalendarExtender ID="txtDate_CalendarExtender" runat="server" Enabled="True" TargetControlID="txtDate">
</ajaxToolkit:CalendarExtender>
Ïà¹ØÎĵµ£º
ǰ¶Îʱ¼äдJSP£¬Ê¹ÓÃAJAXÒÔPOST·½Ê½Ìá½»Êý¾Ý£¬Èç¹ûÊÇÖÐÎÄ×Ö·ûÌá½»¾Í»áÂÒÂ룬ºóÀ´Ð´ASPʱÓõ½AJAXÒÔPOST·½Ê½Ìá½»Êý¾Ý£¬ÖÐÎÄÒ»ÑùÊÇÂÒÂë¡£ËÑË÷Ò»ÏÂÏà¹Ø×ÊÁÏ£¬ÎÊÌâÓ¦¸ÃÊÇÌá½»Êý¾ÝʱÊÇÒÔUTF-8±àÂëÌá½»£¬ËùÒÔ½ÓÊÕʱÈç¹ûʹÓÃGB2312»òÕ߯äËüÖÐÎıàÂëµÄ»°¾Í»áÂÒÂë¡£
ʹÓÃGET·½Ê½Ìá½»Êý¾ÝµÄʱºò£¬ÖÐÎÄÎÊÌâºÜºÃ½â¾ö£¬setRequestHeader ......
Ò»¡¢¸ÅÊö
Marquee£ºHtmlÖйöÆÁ¿Ø¼þ£¬¿ÉÒÔʹ°üº¬Ôڴ˱ê¼ÇÖеÄÄÚÈݽøÐи÷¸ö·½Ïò£¬¸÷ÖÖËٶȵĹö¶¯£¬Òò´ËÔÚ²»¿¼ÂÇʹÓõÚÈý·½¿Ø¼þµÄǰÌáÏ£¬¿¼ÂÇʹÓÃMarquee+xmlhttpÀ´ÊµÏÖ¶¨´Î¸üÐÂÒ³ÃæÖеĹö¶¯ÄÚÈÝ£¬´ËʵÏÖÔÚIE6.0¼°ÒÔÉϰ汾²âÊÔͨ¹ý£¬ÆäËûä¯ÀÀÆ÷ÔÝʱδ²âÊÔ¹ý¡£
MarqueeÖеÄonfinishʼþ£ºÔÚ¸øMarqueeÊôÐÔloop¸ ......
×ªÔØÓÚhttp://xzio.javaeye.com/blog/91713
×î³õ¿´µ½ajax¸Ð¾õºÃ¾ªÏ²°¡£¬²»ÓÃË¢ÐÂÈ«²¿Ò³Ã棬¾Í¿ÉÒÔ¸ü¸Ä¾Ö²¿Ò³ÃæÊý¾Ý¡£ÕæµÄºÜ·½·¨
µ«ÊÇÒÔΪ»áºÜÄÑ£¬µ«Êµ¼Ê×öÁ˲ÅÖªµÀ£¬AJAXºÜ¼òµ¥¡£ÖÁÉÙÈëÃźܼòµ¥ Èç¹ûÄã»áajaxÄǾͲ»Òª¿´ÁË¡£¸ü²»ÒªÂîÎÒ¡£±ÈÎÒÅ£µÄÈËÌ«¶àÁË
»¥ÏཻÁ÷£¬Ñ§Ï°¡£MSN:whw_dream(AT)hotmail.com
Ê×ÏÈÊÇjspÒ³ÃæºÍ ......
ǰÕó×ÓдÁËÒ»¸öĿ¼Ãû/ÎļþÃûµÄ»ñȡС³ÌÐò£¬ÕâÁ½Ìì¾ÓÈ»ÓÖ±»Ãû³ÆÅúÁ¿ÐÞ¸ÄÂé·³ÁËһϣ¬ËùÒÔÔÙдһ¸ö°É¡£
×¢Ò⣺ÄãÒªÊÇÖ»Ïëдһ´ÎµÄ»°£¬ÓÃÅú´¦Àí¸ü·½±ã¡£Ö»Óжà´ÎʹÓõÄÇé¿öÏ£¬×Ô¼ºÐ´³ÌÐò²ÅÓÐÒâÒå¡£
VBÖнøÐÐÃû³ÆÐ޸ĺÜÈÝÒ×,Óõ½µÄ¾ÍÊÇNameÕâ¸öº¯Êý£¬Ó÷¨ÈçÏ£º
Name OldName As NewName£¬Ëü²»½ö¿ÉÒÔ¸ÄдÃû³Æ£¬¶øÇÒ¿ÉÒÔ¸ü¸ ......