DAO,ÈçºÎ¸ü¸ÄAccessÊý¾Ý¿âµÄ±íÃû?
DAOÊDz»Ðеģ¬Ì«ÀÏÁË¡£ADOX¿ÉÒÔ
MFCµÄDAO·â×°À಻֧³Ö¡£ÐèÒªÖ±½Óµ÷ÓÃDAO SDK»òÕßADOX¡£
ʹÓÃADOX
ÎÒÕâÑù¸ÄµÄ...òËƳɹ¦ÁË...
C/C++ code:
CDaoDatabase m_DaoDB;
m_DaoDB.Open(szDBFilePath);
CDaoTableDef m_pTableDef(&m_DaoDB);
m_pTableDef.Open(szOldTa ......
datagridviewÖÐÓжàÐÐÊý¾Ý£¬
ÒªÇóɾ³ýaccessÖÐÊý¾Ý.
°ï°ïæ°É£¬
Ñ»·ÓÃÊÂÎñ³ÉÅúµ¼Èë.
¸ø´úÂë°É
C# code:
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Jet OLEDB:Database Password=");
con.Open();
......
ÈçºÎÔÚoffice2007ÖÐÉèÖÃÁ¬½ÓÊý¾Ý¿âaccessµÄÃÜÂ룿
ÈçºÎ²Ù×÷£¬ÇëÈËÖ¸µãһϣ¬×îºÃÏêϸһµã
ÈËÄØ£¿
ÏÈ´ò¿ªAccess£¬ÓÒÉϽǵã´ò¿ª£¬ÕÒµ½ÒªÉèÖõÄÊý¾Ý¿â£¬ÏÂÃæÑ¡ÔñÒÔÖ»¶Á·½Ê½´ò¿ª£¬
Êý¾Ý¿â¹¤¾ß -ÓÃÃÜÂë½øÐмÓÃÜ
Á¬½Ó£ºC# code:
string strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet ......
½«access±íÖÐÊý¾Ýµ¼µ½ Excel ʱ³öÏּǼ¶ªÊ§¸ÃÔõôÑù½â¾ö ´íÎó:ÓÉÓÚ¹¤×÷Ò³ÐÐÊýÏÞÖÆ£¬³öÏÖÐжªÊ§
excelÏÞÖÆ65535Ìõ
Excel µÄÏÞÖÆ
ʹÓà Excel ×÷ΪÊý¾ÝÔ´ÊÜÏÞÓÚ Excel ¹¤×÷²¾ºÍ¹¤×÷±íµÄÄÚ²¿ÏÞÖÆ¡£Õâ°üÀ¨µ«²»ÏÞÓÚÒÔÏÂʼþ£º
¹¤×÷±í´óС£º65,536 ÐУ¬256 ÁÐ
µ¥Ôª¸ñÄÚÈÝ£¨Îı¾£©£º32,767 ¸ö×Ö·û
¹ ......
×÷ÁËÒ»¸ö±¨±í£¬´ò¿ªÊ±ÌرðµÄÂý£¬¶øÇÒ״̬À¸ÖÐÀÏÊÇÌáʾÏÂÃæµÄÄÚÈÝ£º
ÕýÔÚ²éѯÊý¾Ý£¨½ø¶ÈÌõ¡£¡£¡££©
ÕýÔÚÉèÖÃÒ³µÄ¸ñʽ¡£¡£¡£¡£
ÕâÑùµÄÌáʾҪ³öºÃ¼¸±é¡£
ËùÒÔ±¨±í´ò¿ªÐèÒª2·Ö¶àÖÓ£¬ÄÑÒÔÈÌÊÜ°¡¡£
ÕâÊÇʲôÔÒò°¡£¬´ó¼ÒÓÐûÓÐÓöµ½¹ý£¡
°ï濴һϰ¡£¡
¿´Ò»ÏÂÄãÕâ¸ö±¨±íµÄÊý¾ÝÔ´¡£
Ö±½Ó´ò¿ ......
ÔÚ×öÍøÕ¾ÖУ¬ÓÃASPÓïÑÔдÈëÊý¾Ý¿âÊý¾Ýʱ£¬Óиö×Ö¶Î--ÀàÐÍΪ£ºÎı¾ ¡£
¿ÉÔÚдÈëÊý¾Ý¿âÊý¾Ýʱ£¬´Ë×Ö¶ÎÈô²»Ìîд£¬´Ë´ÎËùÓÐÊý¾Ý¶¼½«²»ÄÜÌá½»µ½Êý¾Ý¿â¡£ÎªÊ²Ã´Ñ½£¿±ÀÀ£ing~~
ÁíÍ⼸¸ö×Ö¶ÎÒ²¶¼ÊÇÎı¾ÀàÐÍ£¬¶¼¿ÉÒÔ²»Ìîд¡£¡£¡£¡£Æ«Æ«Õâ¸ö¡£¡£¡£¡£´«µÝÊý¾Ý¹ý³ÌÖÐûÓÐÈκβî±ð¡£¡£¡£
rs("spec")=trim(request.fo ......