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

ÈçºÎÓÃvc·ÃÎÊaccessÊý¾Ý¿â

ÎÒµÄÈÎÎñÊǽ«³ÌÐòÖеõ½µÄÒ»¸ö×Ö·û´®¡°1001EY125X02511025¡±Ð´Èëµ½Ò»¸öÊý¾Ý¿âÖУ¬ÎÒÏë²ÉÓÃODBC·½Ê½£¬ÀûÓÃvcÈ¥·ÃÎÊaccessÊý¾Ý¿â£¬ÄÄλ¸øÎÒ½²½²·½·¨£¬¸øÎÒÌṩһ¸öÍøÖ·Ò²ÐУ¬ÔÚÍøÉϲéÕÒÁ˺ܶණÎ÷£¬ËµµÄ¶¼±È½ÏÂÒ¡£Ð»Ð»´ó¼Ò¡£
ÓÃADOÁ¬½ÓMDB£¬UPDATEÊý¾Ý
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb


ÒýÓÃ
C++ ͨ¹ýADOÀ´²Ù×÷ACCESS£¬ÀûÓÃADO.connection.execute À´Ö´ÐÐSQLÓï¾ä¡£

Execute¡¢Requery ºÍ Clear ·½·¨·¶Àý (VC++)¡£¡£¡£¡£

ÄúµÄÕâ¸ö³ÌÐòºÜºÃ¡£ÎÒÒªÊÇÌí¼ÓÎÒµÄÊý¾ÝÔ´µÄʱºòÊDz»ÊǰÑProvider='sqloledb';Data Source='MySqlServer';Ð޸ijÉProvider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb(test.mdb)ÊÇÎÒµÄÊý¾Ý¿âÃû³Æ¡£

access µÄ connection string

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

ÒýÓÃ
access µÄ connection string

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

ÄúÏÂÃæµÄ¼¸¾ä»°ÊÇʲôÒâ˼°¡£¿
_bstr_t strSQLChange("UPDATE Titles SET Type = "
            "'self_help' WHERE Type = 'psychology'");
  _bstr_t strSQLRestore("UPDATE Titles SET Type = "
            "'psychology' WHERE Type = 'self_help'");
  _bstr_t strCnn("Pro


Ïà¹ØÎÊ´ð£º

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......

Çë½ÌÒ»¸öACCESSµÄ²éѯÓï¾ä£¡

Òª×éºÏ4ÕűíµÄ²éѯ£¬·Ö±ðÊÇA±í£¬B±í£¬C±í£¬D±í£»
A±í
Game_id  Game_Name
  1        abc


B±í
Category_ID  Category_Name  Game_id
  & ......

ΪɶÎÒ²åÈëaccessÊý¾Ý¿âÓÐÎÊÌâ

string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
        string sql = "insert into times(time) values('" + DateTime.Now + ......

accessÖÐʹÓÃtableÈ·¶¨Î»ÖÃ

¡¡¡¡²»ÖªµÀaccessÖÐÊÇ·ñÄܹ»Ê¹ÓÃtableÀ´½«¸÷¸ö¿Ø¼þ·ÅÈëÏàÓ¦µÄtableµÄ¸÷¸ö¸ñ×ÓÖУ¬¾Í¸úvsµÄaspÒ»Ñù¡£ÔÚdesignÖÐûÓÐÕÒµ½¿ÉÒÔÔÚÒ³ÃæÖгÊÏÖÒ»¸ötableµÄ¹¤¾ß£¬Ïò´ó¼ÒÇó½Ì£ºaccessµ½µ×ÊÇ·ñÓÐÕâÑùµÄ¹¤¾ß£¿

¿´À´£¬access ......

ÇëÎÊVCÀïÔõôÁ´½ÓaccessÊý¾Ý¿â

±¾ÈË×î½üÔÚѧϰvc£¬¶Ôvc²Ù×÷Êý¾Ý¿â»¹ºÜÃԻ󣬲»ÖªµÀÄÄλÄÜ˵ÏÂvcÀïÔõôÑùÁ´½ÓÊý¾Ý¿âµÄ£¬sql server»òaccess¶¼¿ÉÒÔ£¬×îºÃÓиöÀý×Ó¿ÉÒԲο¼Ï¡£ÏÈлл¸÷λ

ADOÀ´·ÃÎÊ ºÜ·½±ãµÄ£¬ÍøÉϺܶàÀý×Ó
VC ADO


htt ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ