Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AccessʹÓòÎÊý»¯UPDATEÊý¾Ýʱ£¬Êý¾ÝÎÞ·¨¸üеÄÎÊÌâ

      ½ñÌìupdate accessÊý¾Ý¿âʱ£¬Ê¹ÓÃÁ˲ÎÊý»¯µÄ·½Ê½£¬½á¹û²»±¨´í£¬µ«ÊÇÊý¾ÝҲûÓиüС£¾­¹ýgoogle·¢ÏÖaccessʹÓòÎÊý»¯Ê±£¬²ÎÊýλÖñØÐëºÍ¸³ÖµË³ÐòÏàͬ²ÅÐУ¬·ñÔò¸üÐÂʱ¾Í»á³öÏÖÊý¾ÝÎÞ·¨¸üе«ÊÇÒ²²»±¨´íµÄ¹ÖÏÖÏó¡£
      ÀýÈç:update tablename set [a]=@a,[b]=@b where [id]=@id
      ÄÇôÄãÔÚ¼Ó²ÎÊýʱ£¬Ò²±ØÐëÏȼÓ@a,ÔÙ¼Ó@b£¬×îºó¼Ó@id.Ò²¾ÍÊÇ˵±ØÐëÒª
cmd.Parameters.AddWithValue(“@a”,a);cmd.Parameters.AddWithValue(“@b”,b);cmd.Parameters.AddWithValue(“@id”,id);˳ÐòÈç¹û´íÁË£¬¾ÍÎÞ·¨¸üÐÂÁË¡£ÕâÒ»µãºÍsql server²»Ò»Ñù¡£ÔÚsql serverÖУ¬²»±Ø¹ØÐIJÎÊýÔö¼ÓµÄ˳Ðò¡£
      ÒòΪaccessÔÚupdateʱ²ÎÊý´íλ²»»á±¨bug£¬Ö»ÊDz»¸üУ¬ËùÒÔÕâÒ»µãÔÚд³ÌÐòʱһ¶¨Òª×¢Òâ¡£


Ïà¹ØÎĵµ£º

Data Access Application Block

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
us ......

ACCESSÖлñÈ¡ËùÓÐ×é¼þ´úÂë

 Private Sub cmdListProperties_Click()
    ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
    Dim ctl As Control
    Dim prp As Property
    On Error GoTo props_err
    For Each ctl In ......

phpÁ¬½ÓaccessµÄÀà

<?php
/*
 * Created on 2008-10-25
 *
 * developer by Alex.do QQ:20779512
 * PHP 5.0
 */
 class mdbClass {
    var $dbPath = 'database/#123123#.mdb';    //Êý¾Ý¿â·¾¶
    var $tabName;     & ......

ºÜÍ·ÌÛµÄACCESS²éѯÎÊÌ⣡

ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬ 
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁË°ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ