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

ΪʲôÎÒÓÃ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ÖУ¬

  ÕâÊǶÁÈ¡Êý¾ÝµÄ´úÂ룺
_variant_t var;
long i=0,j=0,k=0,l=0,m=0; //ÓÃÓÚÑ­»·
double m_X,m_Y;//·Ö±ðÓÃÓÚ´æ´¢XºÍY×ֶεĺÍ

//¶¨ÒåÁ½¸öBusPoint½á¹¹Ìå
BusPoint buspoint;
BusPoint1 buspoint1;

//ÓÃtry....catchÓï¾äÈ¥²¶×½³ÌÐòÖÐÔËÐеĴíÎó£¬ÒòΪ¿ÉÄÜ»áÓÐÒâÏë²»µ½µÄ´íÎó³öÏÖ
//¶ÁÈ¡±íÄÚµÄÊý¾Ý´æ´¢ÔÚbuspoint½á¹¹ÌåÖÐ---------------------------------------------------------------------------------
try
{
if(!m_pRecordset->BOF)          //ÅжϼǼָÕëÊÇ·ñÊÇÖ¸ÔÚÊ׼Ǽ
m_pRecordset->MoveFirst();  //½«¼Ç¼ָÕëÒÆµ½Ê׼Ǽ
else
{
AfxMessageBox("±íÄÚÊý¾ÝΪ¿Õ");
return;
}

while(!m_pRecordset->adoEOF)
{   
//¶ÁÈ¡VALUE×Ö¶ÎÖеÄÖµ
var = m_pRecordset->GetCollect("VALUE"); 
if(var.vt != VT_NULL)             


Ïà¹ØÎÊ´ð£º

´íÎóÐÅÏ¢Access violation....

ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â

ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:

<?xml version="1.0" encoding="utf-8"? ......

jspÒ³Ãæµ¼³öÎÊÌ⣿ÄÜ·ñµ¼³öΪDBFºÍACCESS¸ñʽµÄÎļþ

jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡

javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ