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>
Ïà¹ØÎĵµ£º
¶ÔÏëѧAjaxµÄÐÂÈË£¬Ç¿ÁÒÍÆ¼öÒ»ÏÂÎÄÕ£º¡¶ÕÆÎÕ Ajax ϵÁС· http://www.ibm.com/developerworks/cn/web/wa-ajaxintro/
¸ÃϵÁУ¬²»ÏñÄÇЩͷʹҽͷ½ÅÍ´Ò½½ÅµÄËÙʳÅÉ£¬ßëßë߶߶˵Á˰ëÌì¶¼¾õµÃû˵µ½µã×ÓÉÏ£¬¸ÃϵÁÐÎÄÕÂÉîÈëdz³öµÄ½éÉÜÁËһЩºÜ»ù±¾µÄ֪ʶ£¬µÀ³öÁËһЩ·Ç³£±¾ÖʵÄÄںˣ¬¾ÍËãÄãÊÇAjaxÀÏÊÖ£ ......
¾¹ýÕûÀíºÍµ÷ÊÔ£¬Krabber 0.2.9°æ±¾Õýʽ·¢²¼ÁË¡£
Õâ¸ö°æ±¾µÄÌØµãÊDz»½ö½ö¿ÉÒÔÖ´ÐÐAJAXÍøÒ³²¢·µ»ØÖ´ÐкóµÄ½á¹û£¬»¹¿ÉÒÔÓɳéÈ¡Óû§Ìṩ½Å±¾½øÐÐÖ´ÐУ¬²¢·µ»ØÖ´ÐÐÓû§µÄ¶¯×÷½Å±¾ºóµÄ½á¹û¡£ÕâÒ»ÌØÐÔ¿ÉÒԺܺõĽâ¾öÐèÒª½øÐÐAJAX·Ò³¡¢ÑÓʱ¼ÓÔØµÈµÈÎÊÌâ¡£
ÁíÍâÓÉÓÚ¾«Á¦ÓÐÏÞ£¬°æ±¾Ã»Óо¹ýÑϸñµÄ²âÊÔ£¬Òò´ËÓÐÎÊÌâÇëÔÚÕâÀïÁôÑÔ£¬Ð ......
<mce:script type="text/javascript"><!--
function login(){
var postURL = "http://localhost:8080/cas/simpleLogin";
var params = {
"loginUrl":$("#loginUrl").val(),
"service":$("#service").val(),
"login":$( ......
½ñÌì°ïͬʽâ¾öÁËjsÒì²½µ÷ÓÃʱ³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬¾ßÌå½â¾ö°ì·¨ÈçÏ£º
1£©Ê×ÏÈÈ·ÈÏjsÊÇ·ñûÓжԺǫ́´«Êä¹ýÀ´µÄÖÐÎĽøÐнâÂë¡£
°´ÕÕÍøÂçÉÏдµÄ·½·¨Í¨¹ýjs¶ÔresponseµÄ¶ÁÈ¡³öÀ´Êý¾Ý½øÐжà´Î²âÊÔ£¬·¢ÏÖÈÔÈ»²»Äܽâ¾ö£¬Ï¸Ïë²»Ò»¶¨ÊÇ´Ë´¦ÎÊÌâ¡£¸Ä»»ÆäËû°ì·¨½â¾ö¡£
2£©Èç¹û½âÂë½â¾ö²»ÁË£¬ÔÙ¿´ÊÇ·ñÊÇÒòÎªÍø ......
ǰÕó×ÓдÁËÒ»¸öĿ¼Ãû/ÎļþÃûµÄ»ñȡС³ÌÐò£¬ÕâÁ½Ìì¾ÓÈ»ÓÖ±»Ãû³ÆÅúÁ¿ÐÞ¸ÄÂé·³ÁËһϣ¬ËùÒÔÔÙдһ¸ö°É¡£
×¢Ò⣺ÄãÒªÊÇÖ»Ïëдһ´ÎµÄ»°£¬ÓÃÅú´¦Àí¸ü·½±ã¡£Ö»Óжà´ÎʹÓõÄÇé¿öÏ£¬×Ô¼ºÐ´³ÌÐò²ÅÓÐÒâÒå¡£
VBÖнøÐÐÃû³ÆÐ޸ĺÜÈÝÒ×,Óõ½µÄ¾ÍÊÇNameÕâ¸öº¯Êý£¬Ó÷¨ÈçÏ£º
Name OldName As NewName£¬Ëü²»½ö¿ÉÒÔ¸ÄдÃû³Æ£¬¶øÇÒ¿ÉÒÔ¸ü¸ ......