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»¸üУ¬ËùÒÔÕâÒ»µãÔÚд³ÌÐòʱһ¶¨Òª×¢Òâ¡£
Ïà¹ØÎĵµ£º
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 ......
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
/*
* Created on 2008-10-25
*
* developer by Alex.do QQ:20779512
* PHP 5.0
*/
class mdbClass {
var $dbPath = 'database/#123123#.mdb'; //Êý¾Ý¿â·¾¶
var $tabName; & ......
ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁË°ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......