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

ÈçºÎΪaccessÊý¾Ý¿â¼ÓÃÜ

¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º

£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ

       

                                                      ͼ1

£¨2£©¡°Îļþ¡±——>¡°´ò¿ª¡±——>Ñ¡ÔñÊý¾Ý¿â——>¡°ÒÔ¶ÀÕ¼·½Ê½´ò¿ª¡±£¨Èçͼ2Ëùʾ£©

       

3¡¢¡°¹¤¾ß¡±——>¡°°²È«¡±——¡°ÉèÖÃÊý¾Ý¿âÃÜÂ롱

     

4¡¢ÊäÈë¡°ÃÜÂ롱¡¢¡°ÑéÖ¤¡±——>¡°È·¶¨¡±£»ok£¡
http://photo.blog.sina.com.cn/blogpic/5ff596a20100dqsr/5ff596a2h6d1207b32ccb



Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

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

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

accessÁбí¿òÊý¾Ý¶ªÊ§

¸÷λ´óÏÀ£º
            ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
  µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔ­À´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ