ADOXΪaccessÌí¼ÓÓû§(VC)
ÈçºÎÔÚvcÖÐʹÓÃADOXΪaccessÊý¾Ý¿âÌí¼ÓÒ»¸öÓû§? лл!
ßí?ÔõôûÈËÀ´¿´¿´Ñ½? ÎÒŪ ÁË ºÃ¾ÃÁË,¶¼Ã»Ò»µãÍ·Ð÷! ÄÇλ´ó´óÀ´¾È¾È¼±Ñ½! ллÁË! Ìí¼ÓÒ»¸öÓû§ÊÇʲôÒâ˼£¿£¿Ìí¼ÓÒ»ÕÅ±í£¿£¿»¹ÊÇ´´½¨Ò»¸öеÄÊý¾Ý¿â£¿ ADOX.AppendUser Users.Append User[,Password] ºÜÈÝÒ׵ģ¬MSDNÉÏÓÐVB´úÂ룬»»³ÉVCµÄ¾ÍÐÐÁË ¿´¿´Õâ¸öÍøÒ³°Éhttp://topic.csdn.net/t/20050207/16/3779720.html ÎÒ¶¼ÊÔ¹ýÁË,µ«ÊÇÓдíÎó,ÎÒÐèÒªÒ»¸öÇÐʵ¿ÉÐеÄVCµÄÀý×Ó! accessÖ§³Ö¶àÓû§Ñ½,ÎÒÏëÔÚÎÒ´´½¨µÄaccessÊý¾Ý¿âÉÏ,ÔÚÌí¼ÓÒ»¸öÊôÓÚ "¹ÜÀíÔ±"×é±ðµÄÓû§! ÎÒÒѾ²éÕÒÒ»ÌìÁË,ûÓÐVCµÄÀý×Ó,VBµÄÀý×ÓÎÒת»»µÄ¿ÉÄܲ»¶Ô,×ÜÊÇÓдíÎó,ËùÒÔ,ÎÒÏ£ÍûÄÜ¿´µ½Ò»·ÝÄÜÕý³£ÔËÐÐµÄ VCÔ´´úÂë,¾ÍÒªÌí¼ÓÓû§µÄÕâÒ»¶Î¾ÍÐÐ!ÒýÓà Users.Append User[,Password] ºÜÈÝÒ׵ģ¬MSDNÉÏÓÐVB´úÂ룬»»³ÉVCµÄ¾ÍÐÐÁË ´ó´óÄܸøÎÒÕâ¶ÎVC µÄ´úÂëÂð? ÎÒ×Ô¼º×ª»»µÄʧ°ÜÁË,²»ÄܽøÐÐÌí¼Ó! ´ò¿ªÄǸösystem.mdwµÄÁ¬½Ó´®×ÜÊDz»¶Ô,¶øÇÒ,ҲûÓÐUser.NameÕâ¸öÊôÐÔѽ!ÒýÓà http://msdn.microsoft.com/en-us/library/ms676686(VS.85).aspx ½¯ÀÏ´óµÄÌṩ¼«Æä¾«×¼ÒýÓà http://msdn.microsoft.com/en-us/library/ms676686(VS.85).aspx Ì«¸Ðл jiangsheng (½¯êÉ) ´ó´óÁË Å¼¶¼¿à¿àµÄÕÒÁËÒ»ÌìÁË,ÔÚMSDNÉÏ·Á˰ëÌìҲûÕÒµ½@ лл! Æ
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC) '=========================================================================== SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû S ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡ ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖà sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£ ÊÇ ......
C# code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; namespace DAL { public class DBHelp { ......
Ò»¶Î´úÂ룬ֱ½ÓÔËÐÐûÓÐÎÊÌ⣬µ«ÊÇÔÚvcÀïÃæ±àÒëÔËÐоͻáÅ׳öÒì³£¡£ÕâÊÇÒ»¸ö¶Ô»°¿ò¹¤³Ì£¬ÏÂÃæÊǹؼü´úÂ룺 "StdAfx.h"ÖУº #import "C:\program files\common files\system\ado\msado15.dll ......
ÎÒÓÐÒ»¸ö×Ö¶ÎÃû½Ð"ID",ÀïÃæ´æµÄÊÇ×Ö·û´®ÀàÐ͵ÄÊý×Ö,Èç"111","112"µÈ. ÎÒÏÖÔÚÏë²éÑ®Ëü,²¢Êý×ÖÀàÐÍ·µ»Ø. ÎÒÔÚsqlÀïдµÄÊÇ:"select Convert(int,ID) from table", ......