Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â°´ÈÕÆÚ²éѯµÄÎÊÌâ

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

¹ØÓÚaccessÊÇ·ñÓÐͳ¼Æ¹¦ÄÜ

  ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a    table b
  ¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
  Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
 

  Èç:  ta ......

ΪʲôAccess²»Ö§³ÖÄØ£¿

ÈçÏÂÓï¾ä
Select [Name] as sUnit, count(*) as sTime from Cl_BreakRecord inner join Cl_Group On GroupID = Cl_Group.ID and DepartmentID = 3 group by [Name] order by sTime desc

ÔÚsqlÀï²âÊÔʱûÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ