Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

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

C# code:

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

²åÈë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Ò»¸ö×ֶεÄËùÓмǼÎÊÌâ

Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿


¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡

vbÓïÑÔ´úÂëÈ ......

ÇëÎÊAccessÖÐÈçºÎʹÓÃÎÞ·ûºÅÕûÊý

´ó¼ÒºÃ£¬ÎÒÔÚÊý¾Ý±íÖж¨ÒåÒ»¸öÐèÒª½øÐÐÅÅÐòµÄÕûÊý×ֶΣ¬µ«ÊǸù¾ÝÓ¦ÓÃÐèÇ󣬸Ã×ֶεÄȡֵ·¶Î§ºÜ´ó£¬¼¸ºõÓÃÂúÁËÕû¸ö32볤¶È¡£
ÔÚAccess±íÖкÃÏñÖ»ÓС°³¤ÕûÐÍ¡±Êʺϳ¤¶ÈµÄÐèÒª¡£¿ÉÊÇÓÉÓÚ³¤ÕûÐÍÊÇ´ø·ûºÅÊýµÄ£¬Òò´ËÔÚ ......

winform ACCESS δָ¶¨µÄ´íÎó 100·Ö

winformÓ¦ÓóÌÐò
Á¬½Ó×Ö·û´®
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbpath
dbpathΪ¾ø¶Ô·¾¶ Õâ¸ö·¾¶ÊÇûÓÐÈκÎÎÊÌâµÄ
ÔÚÖ´Ðе½connection.open()ʱ ±¨System.Data.OleDb.OleDbException:&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ