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

vcÁ¬accessµÄÆæ¹ÖÎÊÌâ

Ò»¶Î´úÂ룬ֱ½ÓÔËÐÐûÓÐÎÊÌ⣬µ«ÊÇÔÚvcÀïÃæ±àÒëÔËÐоͻáÅ׳öÒì³£¡£ÕâÊÇÒ»¸ö¶Ô»°¿ò¹¤³Ì£¬ÏÂÃæÊǹؼü´úÂ룺

"StdAfx.h"ÖУº
#import "C:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")

Dlg.hÎļþÖУº
_ConnectionPtr m_pConnection;//Á¬½Ó¶ÔÏó


OnInitDialog£¨£©º¯ÊýÖУº³õʼ»¯¿â»·¾³
 
if (!AfxOleInit())
{
AfxMessageBox("³õʼ»¯OLE DLLʧ°Ü£¡");
return FALSE;
}
//////////////////////////////////////////////////////////////////////////////////////

HRESULT hr;
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");//´´½¨Connection¶ÔÏó
if(SUCCEEDED(hr))
{
hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Student.mdb","","",adModeUnknown);///Á¬½ÓÊý¾Ý¿â
}
}
catch(_com_error e)///²¶×½Òì³£
{
CString errormessage;
errormessage.Format("Á¬½ÓÊý¾Ý¿âʧ°Ü!\r\n:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///ÏÔʾ´íÎóÐÅÏ¢
}


Çëǰ±²Ö¸µã£¡

vcÀïÃæ±àÒëÔËÐоͻáÅ׳öÒì³££ºÏÔʾ"Á¬½ÓµÄÊý¾Ý¿âʧ°Ü£¡Î´Ö¸¶¨µÄ´íÎó"

Á¬½Ó×Ö´®Ð޸ijÉÕâÑùÊÔÊÔ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb

hr = m_pConnection->O


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ADO.NET²Ù×÷AccessµÄÎÊÌâ

C# code:

public override int Update(Table model, DbTransaction dbtran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Tabl ......

ADOÎÞ·¨Á¬½ÓaccessÊý¾Ý¿âÎÊÌâ

ÎÒдÁËÒ»¸ömfc³ÌÐò£¬ÊÇsdiµÄ¡£ÊÓͼÊÇCformviewµÄÅÉÉúÀà¡£
ÎÒÏëʵÏÖÈÎÒâÁ¬½ÓÊý¾Ý¿âµÄ¹¦ÄÜ¡£ËùÒÔÔÚÊÓͼÉÏÌí¼ÓÁËÒ»¸ö°´Å¥¡£µã»÷°´Å¥£¬´ò¿ª¶Ô»°¿òÑ¡ÔñÊý¾Ý¿â½øÐÐÁ¬½Ó¡£´úÂëÈçÏÂËùʾ:

ÎÒÏÈÔÚstdafx.hÎļþÖмÓÁË ......

²åÈëACCESSÊý¾Ý¿â³ö´í

C# code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace DAL
{
public class DBHelp
{
......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ