vb.net¸üÐÂACCESSÊý¾Ý¿â±¨´í£¬Çë½Ì¸ßÊÖ£¡
½öÊÇÒ»¶Î¸üÐÂÃÜÂëµÄ´úÂëÈçÏ¡£±¨´íÐÅϢΪ£º
δ´¦ÀíµÄ¡°System.Data.OleDb.OleDbException¡±ÀàÐ͵ÄÒì³£³öÏÖÔÚ System.Data.dll ÖС£
ÆäËûÐÅÏ¢: UPDATE Óï¾äµÄÓï·¨´íÎó¡£
µ¥¶ÀµÄINSERTÓïÑÔÔÚÊý¾Ý¿âÖÐÔËÐÐͨ¹ý¡£²¢ÇÒselectcommand ,insertcommand ¶¼ÊÇ¿ÉÒÔÔËÐеģ¬Î¨¶Àupdate ±¨Óï·¨´íÎó¡£
Çë½Ì¸ßÊÖ£¬¡£¡£¡£ÓôÃÆÖа¢¡£¡£¡£¡£¡£
¸üдúÂ룺
OleDbConnection1.Open()
Dim str As String = "update login set password = '999' where name ='222'"
Dim zhanghucommand As OleDbCommand = New OleDbCommand(str, OleDbConnection1)
ZhangHuCommand.CommandType = CommandType.Text
ZhangHuAdapter.UpdateCommand = zhanghucommand
ZhangHuAdapter.UpdateCommand.ExecuteNonQuery()
ZhangHuAdapter.Fill(ZhangHuDataSet, "login")
 
Ïà¹ØÎÊ´ð£º
±ÈÈç½ø³Ì¼ÓÔØÐµijÌÐò¡£
ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£
È»ºóÔÊÐíºó·ÅÐС£
±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£
¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£
ÉèÖ ......
VBżѧµÃ²»´í£¬ÏÖÔÚ´óÒ»£¬¸ßÈýµÄʱºò¾ÍѧVBÁË£¬ÏÖÔÚѧУÀï¶¼ÊÇѧC#ºÍVB.NETµÄÐֵܶࡣ¡£¡£
żҪתÐÐVB.NETÁË~µ±ÄêѧVBѧÁË2Ä꣬¶ÔVBÀïÃæµÄ³£Óú¯Êý¶¼Ê®·ÖÁ˽⡣
Select¡¢If½á¹¹¡¢For NextÑ»·¡¢µÈ¶¼Á˽⡣¡£¡£ ......
ÔõôÓÅ»¯²éѯµÄЧÂÊ£¬±ÈÈçÎÒÏë´Ó100ÍòÌõ¼Ç¼ÖÐÿ´ÎÖ»²éѯ100Ìõ¼Ç¼µÄ»°£¬ÄÇôÕâÌõsqlÓï¾ä¸ÃÔõôʵÏÖ£¬×¢Ò⣺ÓïÑÔÊÇVBScriptµÄ£¬
http://www.cnblogs.com/anjou/archive/2007/10/17/926944.html
Éæ¼°µ½Ëã·¨£¬goog ......
¸÷λ´óϺ£º
ÎÒÓÐÒ»¸öVBµ÷ÓÃË®¾§±¨±íµÄϵͳ£¬±¨±íÊÇ×÷Ϊһ¸öDesignǶÔÚVBÀïµÄ£¬½ñÌì·¢ÏÖ´òÓ¡µÚÒ»Õű¨±íÕý³££¬Í¬ÑùµÄÊý¾Ý£¬ÔÚµã´òÓ¡ÔÙµ÷ÓÃÒ»´Î¾Í»á±¨ Memory FullµÄ´íÎ󣬵«ÊÇ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......