Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ

strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£

½¨ÒéÄãͨ¹ýµ÷ÊÔ°ÑÕâ¸ö  ("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),strVar,strValue,strVar2,strValue2)
Êä³ö¿´Ò»Ï½á¹ûÊÇʲô£¿ ¹À¼ÆÄãµÄ±äÁ¿ÓÐÎÊÌâ¡£

strSQLCmdÄÚÈÝÊÇʲô

CString strSQLCmd;
ÊDz»ÊDZäÁ¿µÄÖµ´ú½øÈ¥ÊÇÕâÖÐÐÎʽ°¡£ºstrSQLCmd.Format(_T("select * from (select * from talk_info where strVar ='strValue') where strVar2 ='strValue2'")£»



Ïà¹ØÎÊ´ð£º

vs2005 c# Á¬½ÓaccessÊý¾Ý¿â×Ô¼º×ÜÊÇÔÚCÅÌÏÂÕÒÊý¾Ý¿â

ÈçÌáʾ£ºÕÒ²»µ½Îļþ 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Usre.mdb'¡£
´úÂ룺conn.ConnectionString = "Provider=Microsoft.Jet.oledb.4.0;Data Source=" + Server.MapPa ......

aspÔõÑùÁ¬½ÓÓй¤×÷×éȨÏÞÉèÖõÄaccessÊý¾Ý¿â

ÎÒÃÇÓÃasp+accessдһ¸öÓ¦ÓóÌÐò£¬Ï£ÍûÌá¸ßÊý¾Ý¿âµÄ°²È«ÐÔ£¬ËùÒÔ¶ÔaccessÊý¾Ý¿â½øÐÐÁËÓû§¼¶°²È«ÉèÖ㨼´ÆôÓÃÁ˹¤×÷×éȨÏÞ£©¡£ÕâÑùÒ»À´£¬µ¼ÖÂÔ­À´µÄÁ¬½Ó³ÌÐòÎÞЧÁË¡£ÏÂÃæÊÇÔ­À´µÄδÉèÖù¤×÷×éȨÏÞµÄÁ¬½Ó´úÂ룺
......

asp·ÃÎÊAccessÁ´½Ó±í

¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£

Ìù³ö´úÂ ......

VB Óë Access ʵÏÖ°à×é¡¢ÈÕ¡¢Ô¡¢Ä걨±íÎÊÌâ

±¾È˳õ´Î½Ó´¥£¡±È½ÏÄ£ºý£¡Ï£Íû´ó¼Ò¿ÉÒ԰ѶÔMicrosoft Office AccessµÄ±í²Ù×÷³£ÓÃÃüÁî ¸æÖ®£¡
»¹ÓÐÎÒÏëʵÏÖ°à×é¡¢ÈÕ¡¢Ô¡¢Ä걨Microsoft Office AccessÀïµÄ±íµ¥Ôõô´¦Àí£¿

ÊÇÀûÓò»Í¬µÄ±í·Ö±ð¼Ç¼Сʱ°à×éÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ