VC+OLEDB+ACCESS,×Ö·û´®³ö´í£¡
VC+OLEDB+ACCESS,×Ö·û´®³ö´í£¡
ÓÃÒÔϵĴúÂ룬ËÑË÷Êý¾Ý¿â£¬Ã»ÎÊÌâ¡£
//hr=pICommandText->SetCommandText(DBGUID_DEFAULT,L"SELECT * from MUTOUTYPE WHERE MuTouID = 1");
if(FAILED(hr))
{
goto Exit;
}
hr=pICommandText->Execute(NULL,IID_IRowsetChange,NULL,NULL,(IUnknown**)& pIRowsetChange);
if(FAILED(hr))
{
goto Exit;
}
½«×Ö·û´®¸ÄΪÏÂÃæ¸ñʽʱ£º
int iNum=1;
str.Format(L"SELECT * from MUTOUTYPE WHERE MuTouID = '%d'",iNum);
hr=pICommandText->SetCommandText(DBGUID_DEFAULT,str.AllocSysString());
if(FAILED(hr))
{
goto Exit;
}
hr=pICommandText->Execute(NULL,IID_IRowsetChange,NULL,NULL,(IUnknown**)& pIRowsetChange);
if(FAILED(hr))
{
goto Exit;
}
Ö´Ðе½ExecuteÓï¾äÍ꣬hr=DB_E_CANTCONVERTVALUE ³ö´í£¬
ÇëÎÊL"SELECT * from MUTOUTYPE WHERE MuTouID = 1"Óë
L"SELECT * from MUTOUTYPE WHERE MuTouID = '1'"Óï¾äÓкÎÇø±ðÄØ£¿
ÔÚ³ÌÐòµÄ×Ö·û´®ÖÐÈçºÎ½«'1'¸ÄΪ1ÄØ£¿{{
Ïà¹ØÎÊ´ð£º
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
win2000ϵͳADOÁ¬½ÓACCESSÊý¾Ý¿â±ØÐèÒª½øÈë×ÀÃæÂð?
ÎÒÓÐÒ»¸ö×°ÁËwin2000-SP4µÄ»ú×Ó,ÒÑ×°ÁËMDAC 2.8 ,дÁ˸öwindows·þÎñ³ÌÐòÊÇÓÃADO²Ù×÷ACCESSÊý¾Ý¿âµÄ,Ææ¹ÖµÄÊÇ´ò¿ªÊý¾Ý¿âÎļþʱ,±ØÐèÒªµÇ¼µ½×ÀÃæ²ÅÄÜÕý³£´ò¿ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......