¼±£¬VC+ADO¶ÁÈ¡AccessÊý¾Ý±íµÄÎÊÌ⣡£¡
ΪʲôÎÒÓÃVC+ADOÔÚ¶ÁÈ¡AccessÊý¾Ý¿âµÄ±íʱ£¬µ±¼Ç¼ÊýÉÙÓÚ15000Ìõʱû´í£¬¶ø¼Ç¼Êý´óÓÚ15000Ìõʱ¾Í¶Áȡʧ°Ü£¬±íÄÚÓÐVALUE£¬STIE_NAME,X,Y,LINE ÎåÁУ¬ÎÒÊÇÕâÑù×öµÄ£¬Ïȶ¨ÒåÒ»¸ö½á¹¹Ìå
struct BusPoint
{
CString m_VALUE[30000];
CString m_SITE_NAME[30000];
double m_X[30000],m_Y[30000];
CString m_LINE[30000];
};
ÔٰѶÁÈ¡µÄ×ֶδ洢ÔڽṹÌåBusPointÖУ¬Çë´óÏÀÃǰï°ï°É£¡Ð»Ð»ÁË£¡
struct BusPoint
{
CString m_VALUE;
CString m_SITE_NAME;
double m_X,m_Y;
CString m_LINE;
};
¶ÁȡһÌõÈ»ºó
BusPoint *pBP = new BusPoint;
pBP->m_VALUE = ....
....
ÓÃVector´æÊÔһϣ¡£¡Òª²»¾Í°Ñ¶ÁÊý¾Ý¿âµÄʱºòÅÅÐòһϣ¬¼¸Íò¸ö»¹Ã»ÓÐ×ö¹ý£¡£¡
Access²Ù×÷¼¸ÍòÐÐÓÐÎÊÌâ
лл£¬ÎÒÈ¥¿´¿´£¡
ͬΪ¶ÑÕ»µÄÎÊÌ⣬ͬ½áͬ½á....Ado²Ù×÷¼¸ÍòÐÐÊÇûÓÐÎÊÌâµÄ..
·¹ý£¬·¢ÏÖÄ㶨ÒåµÄ¶ÑÕ»ºÃÏñ̫СÁ˰É
Ïà¹ØÎÊ´ð£º
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
mdb.OleFunction("Create", ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......