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

¶¨Ê±Ð´ÈëADO accessÊý¾Ý¿â ÄÚ´æÔö¼Ó

  HRESULT hr=pApp->m_pRecordset->Open(sql.AllocSysString(),pApp->m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
        if(!SUCCEEDED(hr))
{
  AfxMessageBox("´³ö´í");
  return false;
}

      if(pApp->m_pRecordset!=NULL)
{
  pApp->m_pRecordset->Close();

        }

˵Ã÷:pApp->m_pRecordset,pApp->m_pConnection¶¼ÊÇÔÚ³ÌÐò¼ÓÔØÊ±³õʼ»¯µÄ£¬ÎÒ¶¨Ê±2ÃëÖÓÈ¥´ò¿ªºÍ¹Ø±ÕÒ»¸ö¼Ç¼¼¯£»

³ÌÐòÖ´ÐÐÁË100´ÎµÄʱºò£¬ÄÚ´æ´ó¸ÅÔö¼ÓÁË80K,ÓÉÓÚϵͳÊÇÒª24СʱÔÚÏߵģ¬ÇëÎʸ÷λ³öÏÖÕâÖÖÇé¿öµÄÔ­ÒòÊÇʲô°¡£¿£¿£¿£¿£¿£¿£¿
    ÏîÄ¿µ÷µ½ÕâÀ│סÁË£¬²âÊÔÁËÒ»Ì죬»¹ÊÇûÓÐɶ½øÕ¹°¡£¿£¿£¿

  ÓÉÓڼǼ¼¯ÊÇÔÚ³ÌÐòÆô¶¯Ê±::CoInitialize(NULL);
HRESULT hr;
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");//´´½¨Connection¶ÔÏó
if(SUCCEEDED(hr))
{
hr = m_pConnection->Open(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=m_data.mdb",
"","",adModeUnknown);


}
}
catch(_com_error e)/
{
CString errormessage;

AfxMessageBox(errormessage
return FALSE;
}
m_pRecordset.CreateIns


Ïà¹ØÎÊ´ð£º

´´½¨ACCESSÎļþµ÷ÓÃOLEFUNCTIONʱ²úÉú´íÎó£¬ÔÚÏßÇóÖú

ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
  mdb.OleFunction("Create", ......

ACCESSÎı¾¿ò³¤¶ÈÊǶàÉÙ? - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿

²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û

ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......

aspÁ¬½ÓACCESSÊý¾Ý¿âµÄÎÊÌ⣡£¡

×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡­¡­
xx.aspΪ£º
<html>
<hea ......

¹ØÓÚVB.NETºÍMS ACCESSµÄÎÊÌâ

ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ