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
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)
Dim DDTP1 As String
Dim date1 ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......