¶¨Ê±Ð´Èë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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......