Odbc ÈçºÎÔ¶³ÌÁ´½ÓaccessÊý¾Ý¿â
²»¹Üʲô·½·¨Ö»ÒªÄÜÁ´½ÓÉÏ ÂíÉϽáÌù!
OdbcÈçºÎÅäÖÃÔ¶³ÌÊý¾ÝÔ´
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.167.0.5\zz\1.mdb
×¢ÒâĿ¼ȨÏÞ
Õâ·½ÃæÎÒÒ»µã²»¶® Â鷳˵Çå³þµã
ÊDz»ÊÇ ¼ÆËã»úÒªÔÚͬһ¸öÍøÂç ÍøÉÏÁÚ¾Ó ÀïÃæ?
Ö»ÒªÄÜ·ÃÎÊÆäËü¼ÆËã»ú¾ÍOKÁË
ÄÇÕâ¾ÍÊÇ˵ obdc ÊÇûÓа취 ͨ¹ýÒ»¸öipµÄ¶Ë¿Ú À´·ÃÎÊÁËÂð?
accessµÄmdbÎļþºÍ jspÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ
mdb Îļþ°ÑÔÚĿ¼Ïȹ²Ïí³öÀ´£¬ÈÃJSPµÄÕ˺ÅÄܹ»·ÃÎÊ¡£È»ºóÔÚJSPµÄÁ¬½Ó´®ÖÐд³É \\hostanem\sharefolder\xxx.mdb
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......