¹ØÓÚ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")
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Óï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......