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

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ÉÏ·­Á˰ëÌìҲûÕÒµ½@
лл!

Æ


Ïà¹ØÎÊ´ð£º

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

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

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

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

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

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

ÊÇ ......

²åÈëACCESSÊý¾Ý¿â³ö´í

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Á¬accessµÄÆæ¹ÖÎÊÌâ

Ò»¶Î´úÂ룬ֱ½ÓÔËÐÐûÓÐÎÊÌ⣬µ«ÊÇÔÚvcÀïÃæ±àÒëÔËÐоͻáÅ׳öÒì³£¡£ÕâÊÇÒ»¸ö¶Ô»°¿ò¹¤³Ì£¬ÏÂÃæÊǹؼü´úÂ룺

"StdAfx.h"ÖУº
#import "C:\program files\common files\system\ado\msado15.dll ......

sqlºÍaccess ͨÓÃת»»º¯Êý

ÎÒÓÐÒ»¸ö×Ö¶ÎÃû½Ð"ID",ÀïÃæ´æµÄÊÇ×Ö·û´®ÀàÐ͵ÄÊý×Ö,Èç"111","112"µÈ.
ÎÒÏÖÔÚÏë²éÑ®Ëü,²¢Êý×ÖÀàÐÍ·µ»Ø.
ÎÒÔÚsqlÀïдµÄÊÇ:"select Convert(int,ID) from table",
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ