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

¹ØÓÚAccess×öÊý¾Ý¿âµÄʱºòÔõô¸ÄÎļþµÄÏà¶Ô·¾¶¡£

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\liaotian.mdb");
Õâ¸öÊǾø¶Ô·¾¶£¬ÎÒÏë°ÑÊý¾Ý¿âÎļþ·ÅÔÚÎÒµÄÏîÄ¿ÀïÃæµÄDataÎļþ¼ÐÀïÃæ£¬ÊÇÕâÑù¸ÄÂð£¿
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Data/Chat.mdb"));
·½·¨µ¹ÊǶÔÁË£¬µ«Òª¼Çס³ÌÐòÒª·ÅÔÚºÏÊʵĵط½£¬dataÎļþ¼ÐÒªºÍ³ÌÐò·ÅÔÚÒ»Æð£¬»¹ÓУ¬ÄãµÄ·¾¶Ð´´íÁË£¬ÊÇ"\"¶ø²»ÊÇ"/",Â¥Ö÷Ôõô·¶ÕâÖֵͼ¶´íÎó£¿

²»ºÃÒâ˼£¬¿´´íÁË£¬ÕâÊÇASP,ȷʵÊÇ¡°/¡±£¬ÎÒÒ»°ãϲ»¶ÓÃ&×Ö·û
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../DataBase/DBase.mdb")

ÒýÓÃ
·½·¨µ¹ÊǶÔÁË£¬µ«Òª¼Çס³ÌÐòÒª·ÅÔÚºÏÊʵĵط½£¬dataÎļþ¼ÐÒªºÍ³ÌÐò·ÅÔÚÒ»Æð£¬»¹ÓУ¬ÄãµÄ·¾¶Ð´´íÁË£¬ÊÇ"\"¶ø²»ÊÇ"/",Â¥Ö÷Ôõô·¶ÕâÖֵͼ¶´íÎó£¿

lz

string strDbPath = @"C:\aa.mdb";//Ò²¿ÉÄÜʹÓÃÎļþ¶Ô»°¿òÀ´²Ù×÷
string strSqlCnn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + strDbPath;
OleDbConnection conn = new OleDbConnection(strSqlCnn);

Ö±½ÓдµÄ£¬¿ÉÄÜÓÐ´í£¬Æä·½·¨Êǽ«Êý¾Ý¿â·¾¶È·¶¨ºóÔÙ½áºÏµ½Á¬½Ó×Ö·û´®ÀïÈ¥¡£


лÁË£¬·Ö¸ø´ó¼ÒÁË¡£


Ïà¹ØÎÊ´ð£º

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

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

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

ÊÇ ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~

±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢

Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ