access ²Ù×÷
1.now() »ñÈ¡µ±Ç°Ê±¼ä£»
2.¹ØÓÚAccessÄÚ²¿µÄÄ£ºý²éѯ£º
ÔÚC#ÀïдӦд³É Select * from Table Where Name Like '%ABC%'
Select * from Table Where Name Like '_ABC_'
AccessÄÚ²âÊÔÓï¾äӦд³É : Select * from Table Where Name Like '*ABC*'
Select * from Table Where Name Like '?ABC?'
Ïà¹ØÎĵµ£º
Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾¹ýOLE DB¾«Ðİü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓ ......
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: ......
----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......
vc±à³ÌdebugʱÌáʾ
First-chance exception in exShowBmp.exe (HOOKDLL.DLL): 0xC0000005: Access Violation.
First-chance exception in exShowBmp.exe: 0xC0000005: Access Violation.
¿ÉÄܵÄÔÒò:
ÄÚ´æ·ÃÎÊ´íÎó¡£Ó¦¸ÃÊÇ·ÃÎÊÁ˲»¸Ã·ÃÎʵĵط½£¬¿ÉÄÜÊÇʹÓÓҰָÕë”·ÃÎÊÔì³ÉµÄ¡£±ÈÈç·ÃÎÊÒ»¸öÒѾÊÍ·ÅÁ覄 ......