VC ADO ACCESS »ñÈ¡ÁÐÃû
BOOL GetAllFields(_RecordsetPtr m_pRecordset,CStringArray & fieldsarray)
{
if (m_pRecordset)
{
if (m_pRecordset->State)
{
try
{
HRESULT hr;
Fields * fields = NULL;
hr = m_pRecordset->get_Fields (&fields);
long ColCount;
if(SUCCEEDED(hr))
fields->get_Count(&ColCount);
for(long i=0;i<ColCount;i++)
{
Field * field = NULL;
field = fie
Ïà¹ØÎĵµ£º
ÔÒò£ºIISûÓÐ×¢²á,ÎÒÊÇÔÓÐϵͳµÄIISɾÁË,Ôì³ÉÔËÐÐIISÖеÄÓ¦ÓóÌÐò³öÏÖÕâÖÖ´íÎó!
½â¾ö°ì·¨:
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ±Ç°Óû§£©
2¡¢aspnet_regiis -i £¨×¢²áIIS£©
3¡¢iisreset /noforce £¨ÖØÆôIIS£©
......
----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......
Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â
1¡¢wxWidgets¿âÖÐODBCµÄ±àÒë
ĬÈϱàÒëʱ£¬ODBC¿âÖеÄûÓе¼³ö£¬ÖÂʹµ÷ÓÃwxDbConnectInf£¬wxDbTableµÈÀຯÊýÊÇʱ³öÏÖÁ´½Ó´íÎóµÄÎÊÌ⣬¹ÊÊ×ÏÈÒª±àÒëODBC¿âΪµ¼³ö Àà¿â£¬ÕâÐèÒªÔÚ"Include"Ŀ¼ÏµÄ"Setup.h"ÖжÔ#define wxUSE_ODBC 0ÉèÖÃΪ1£¬ÖØÐ±àÒë¼´¿É.
2¡¢Êý¾Ý¿âµÄÁ´½ÓÓ ......
1.now() »ñÈ¡µ±Ç°Ê±¼ä£»
2.¹ØÓÚAccessÄÚ²¿µÄÄ£ºý²éѯ£º
ÔÚC#ÀïдӦд³É Select * from Table Where Name Like '%ABC%'
Select * from Table Where Name Like '_AB ......
Ò»Ö±¼áÐÅ×Ô¼ºSQLÓï¾äÍæµÄ»¹ÊDz»´íµÄ£¬µ«ÊÇÕâ¸ö¹ÖÒìµÄÎÊÌ⻹ÊÇһֱŪµÃÎÒºÜÀDZ·£¬Ò»ÉÏÎçµÄʱ¼äûÕÒµ½ÔÒò£¬oracle£¬ MSSQL£¬MySQL,DB2¶¼Íæ¹ý£¬¾ÍûÕâôÓôÃÆ¹ý¡£¡£´ÓÀàÐͶÔÓ¦µ½×ֶΡ£¡£ÔÙµ½Êý¾Ý¿â¹ÜÀíÉèÖᣡ£ËùÓÐÄܼì²éµÄ¶¼¼ì²éÁË¡£¡£»¹Ã»ÕÒµ½¡£¡£×îºóÕÒµ½ÔÒòÁË¡£¡£sum us ......