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

VCµÄADO²Ù×÷AccessÊý¾Ý¿âµÄÎÊÌâ - VC/MFC / »ù´¡Àà

´ó¼Ò°ïæһÏÂADOÁ¬½ÓÉÏÁËÊý¾Ý¿â£¬µ«ÊÇÎÒ²Ù×÷µÄʱºò¾Í»á´íÎ󣬲»ÖªµÀΪʲô£¬±ÈÈçÎÒÉùÃ÷ÁË

_RecordsetPt m_pRecordset;À´²Ù×÷m_pRecordset->adoEOF¾Í»á³ö´í£¬²»ÖªµÀΪʲô£¬Ö»ÒªÓõ½m_pRecordsetÕâ¸öÖ¸Õë¾Í»áµ¯

³ö£ºRuntime Error!
  Program:...
  This application has requested the Runtime to terminate it in an unusual way.
  Please contact the application's support team for more information.

Èç¹ûÎҰѹØÓÚm_pRecordsetµÄ¶«Î÷×¢Ê͵ô¾Í¿ÉÒÔÁË£¬²»ÖªµÀΪʲô£¬ÇëÄãÃǰïæÒÔÏ£¬

ÎÒŪÁ˼¸Ì죬ԴÂëÒ²¿´Á˺ܶ൫ÊÇ»¹ÊDz»¶®£¬È˼ÒÔ´Âë¿ÉÒÔµ«ÊÇÎÒ×öµÄʱºò¾Í»á³ö´í£¡

ÏȸÐл´ó¼Ò£¡
m_pRecordsetÕâ¸öÄãû³õʼ»¯¾ÍÄÃÀ´ÓÃ.....

ÎÒ¸ÕдÁËÒ»¸ö²©¿Í
¿´¿´»á²»»á¶ÔÄãÓаïÖú
http://blog.csdn.net/xianglitian/archive/2010/05/22/5617173.aspx

¼ÓÉÏÕâÒ»¾ä m_pRecordset.CreateInstance(__uuidof(Recordset));ÓÃÀ´³õʼ»¯m_pRecordset

ËÆºõÎÒ¼ÓÁ˲»¿ÉÒ﵀ £¬²»ÖªµÀΪʲô = = ¡¢Ë­»á°ïÎÒŪ¸öÏêϸµãµÄ½Ì³Ì

¿´¿´Õâ¸öÌû×Ó
http://http://topic.csdn.net/u/20100429/11/a1a68cd2-d942-4f6b-b387-69a130ec5888.html


ÄãÊÔÊÔm_pRecordset->EOFÕâ¸öÓдíÂð£¿

Êý¾ÝÔ´¸Ä³É¾ø¶Ô·¾¶ÊÔÊÔ¡£ÎÒÕýºÃÔÚѧ£¬ÕâÊÇÎҵģº
class CADODB
{
public:
CADODB();
  virtual ~CADODB();
public:
_RecordsetPtr m_pRecordset;
void OnInitADODB(_bstr_t strConnect,_bstr_t userID,_bstr_t password);
void Select(_bstr_t sqlstr);
void Execute(_bstr_t sqlstr);
void AddNew(_


Ïà¹ØÎÊ´ð£º

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

ACCESS Êý¾Ý²éѯÎÊÌâ ÔÚÏßµÈ - Web ¿ª·¢ / ASP

ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50  
2 40 1
3 30 1
4 ......

¶àÌõ¼þ²éѯaccessÊý¾Ý¿â - .NET¼¼Êõ / ASP.NET

Ò³ÃæÓÐ5¸ödropdownlist£¨ddl1,ddl2,ddl3,ddl4,ddl5£©Ò»¸öTextBox (txt1)
ËûÃÇ¿ÉÒÔÈÎÒâ×éºÏÈ¥²éѯÊý¾Ý¿â
Èç¹ûÆäÖеÄĪһ¸öΪ¿ØÖÆÔò²»²ÎÓë²éѯÌõ¼þÖУ¬
Äܸø¸ö´úÂë×îºÃ£¬¸ø¸ö˼·Ҳ·Ç³£µÄ¸Ðл£¡
string sql=" ......

sqlµ¼accessµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

´úÂëÕâôдµÄ
string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms;
int i = rmdc.ExecuteCommand(sqlCmd);
È»ºóÌáʾ´íÎó
Ö¸¶ ......

AccessÖд´½¨ÊÓͼ - MS-SQL Server / »ù´¡Àà

create view ±íÃû 
as
select a.a1,b.b1 from a inner join b on a.id=b.id
Õâ¸öÓï·¨ÔõôдÉÏÈ¥ÊÇ´íµÄÔÚAccessÀï
ACCESSºÃÏñ²»Ö§³Öcreate view
Äã¿ÉÒÔÔÚACCESSÖе¥»÷¡°ÊÓͼ¡±²Ëµ¥£¬Ñ¡Ôñ¡°SQLÊÓͼ¡±ÃüÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ