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

ADOX+access Ìí¼ÓÁеÄÎÊÌâ

ÎÒÔÚʹÓÃadox+access,ʹÓóÌÐòÌí¼ÓÐÂÁеÄʱºò×ÜÊdzöÏÖ´íÎó,¶¼ÓÐÄÄЩÐèҪעÒâµÄѽ,лл!

ÎҵĴúÂëÊÇÕâÑùµÄ!
C/C++ code:

CoInitialize (NULL);
bsSQL = ...(Êý¾Ý¿âÁ¬½Ó×Ö·û´®)
m_pConnection.CreateInstance(__uuidof(Connection));
m_pCommand.CreateInstance(__uuidof(Command));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pConnection->Open(bsSQL,"","",adModeUnknown);
m_pCommand->ActiveConnection = m_pConnection;

csSQL.Format (_T("alter table pd add COLUMN %s int"),strColumnsName);
m_pConnection->Execute ((_bstr_t)csSQL,NULL,adCmdText);





²»ÖªµÀÊÇÄÄÀï´íÁË,Ï£Íû´ó´óÃÇÖ¸µã,лл!
COLUMN %s int"),---->
COLUMN %s integer"),

ÎÒµÄËùÓеÄsqlÓï¾ä,µ¥¶ÀµÄÔÙÊý¾Ý¿âÉÏÖ´ÐеÄʱºò¶¼ÕýÈ·,µ«ÊÇ,һʹÓÃADOXÖ´ÐеÄʱºò,¾Í»á³ö´í,
Ó¦¸ÃÊÇadoxµÄijЩÃüÁî»òÕßÉèÖóöÎÊÌâÁ˰É!

COLUMN %s int"),---->
COLUMN %s integer"),
ÊÔ¹ýÁË,»¹ÊDz»¶Ô!

ллfeilinhe´ó´ó!


COLUMN %s integer default 0")ÄØ

Ò²ÊÔ¹ýÁË,²»ÐÐ!

¿´¿´Á¬½ÓµÄ´ò¿ª·½Ê½

ÒýÓÃ
try
{
  m_pConnection->Execute ((_bstr_t)csSQL,NULL,adCmdText);
}
catch(_com_error e)
{
  MessageBox(


Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ADOXΪaccessÌí¼ÓÓû§(VC)

ÈçºÎÔÚvcÖÐʹÓÃADOXΪaccessÊý¾Ý¿âÌí¼ÓÒ»¸öÓû§?
лл!
ßí?ÔõôûÈËÀ´¿´¿´Ñ½?
ÎÒŪ ÁË ºÃ¾ÃÁË,¶¼Ã»Ò»µãÍ·Ð÷!
ÄÇλ´ó´óÀ´¾È¾È¼±Ñ½!

ллÁË!

Ìí¼ÓÒ»¸öÓû§ÊÇʲôÒâ˼£¿£¿Ìí¼ÓÒ»ÕÅ±í£¿£¿»¹ÊÇ´´½¨Ò» ......

Access Êý¾Ý²éѯ²»ÍêÕû

select * from ±íÃû
±íÀïÓÐ100ÌõÊý¾Ý£¬¿ÉÊÇÖ»²éѯ³öǰ90Ìõ£¬ÆäÓàµÄ²»ÏÔʾ¡£ÒªÊǸù¾ÝID²éѯ£¬ÆäÓàµÄÒ²¿ÉÒԲ鵽¡£
ÕâÊÇʲôÎÊÌâ°¡£¿

ѹËõMDBÊÔÊÔ¡¡OR¡¡Ð½¨Ò»¸öMDB£¬µ¼Èë¾É±íÊý¾Ý£¬ÔÙ²éѯÊÔÊÔ

ÉÏ´«ÄãµÄ± ......

¹ØÓÚado·ÃÎÊaccess ²»ÄÜÓÃwhereµÄÎÊÌâ

ÎÒÓà ado ·ÃÎÊaccess¿âʱ Óà select * from user_info where user_id=ÕÅÈý ¾Í³ö´í£¬Èç¹ûÈ¥µô where user_id £¬Ö»ÊÇselect * from user_info¾ÍûÎÊÌâ Ϊʲô²»ÄܼÒÑ¡ÔñÄØ °ï°ïæ½â´ðһϠлл
select * from user_in ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ