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


Ïà¹ØÎÊ´ð£º

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

Á¬½ÓACCESSÊý¾Ý¿â²ÎÊýÎÊÌâ

ÎÒÔÚACCESS²éѯÖн¨Á¢ÁËÒ»¸ö²éѯ,ÐèÒªÊäÈëÒ»¸ö²ÎÊý.

¼´Ë«»÷²éѯʱ,Ìø³ö"ÊäÈë²ÎÊýÖµ",È»ºóÊÖ¶¯ÊäÈëÏàÓ¦×Ö·û,²éѯ³É¹¦.

ÏÖÔÚÎÊÌâÊÇÔÚASPÖÐÖ±½Óµ÷ÓòéѯÏÔʾ"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ&qu ......

¹ØÓÚaccessÊý¾Ý¿â°´ÈÕÆÚ²éѯµÄÎÊÌâ

СµÜÊǸöASPÐÂÊÖ£¬×î½üÓöµ½¸ö¼¬ÊÖµÄÎÊÌ⣬ÀûÓÃASP+ACCESSÊý¾Ý¿â×öÁ˸öÍøÕ¾³ÌÐò£¬ÏëҪʵÏÖ°´Ô·ݲéѯ³öÊý¾Ý£¬ÒѾ­´´½¨ÁËÒ»¸öʱ¼ä×ֶΣ¬ÀïÃæ´æµÄ¶¼ÊÇ1999-9-1ÕâÑùµÄ¸ñʽ£¬Ìá½»°´Ô²éѯʱµÄ±íµ¥Ê±ÊÇÓõÄ×Ö·û´®£¬µ«ÊDz»» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ