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

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

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

ASP.net Êä³öaccess ole¶ÔÏó³öÏÖSystem.Byte[]

Ô´´úÂë
C# code:
<asp:Repeater runat="server" ID="rptShowLink">
<ItemTemplate>

<div>
......

ACCESSÊý¾Ý¿â ×ö·ÖҳдSQLµÄÎÊÌâ

select top 20 * from tb
where ×Ö¶ÎÃû not in
(select top 10 ×Ö¶ÎÃû from tb)

ÎÒÖªµÀÓÃÕâÖÖ·½·¨¿ÉÒԵõ½10-20µÄÊý¾Ý
µ«ÊÇÈç¹ûÊý¾ÝºÜ¶à
±ÈÈçselect top 100020 * from tb
where ×Ö¶ÎÃû not ......

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

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

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