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(_
Ïà¹ØÎÊ´ð£º
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50
2 40 1
3 30 1
4 ......
Ò³ÃæÓÐ5¸ödropdownlist£¨ddl1,ddl2,ddl3,ddl4,ddl5£©Ò»¸öTextBox (txt1)
ËûÃÇ¿ÉÒÔÈÎÒâ×éºÏÈ¥²éѯÊý¾Ý¿â
Èç¹ûÆäÖеÄĪһ¸öΪ¿ØÖÆÔò²»²ÎÓë²éѯÌõ¼þÖУ¬
Äܸø¸ö´úÂë×îºÃ£¬¸ø¸ö˼·Ҳ·Ç³£µÄ¸Ðл£¡
string sql=" ......
´úÂëÕâôдµÄ
string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms;
int i = rmdc.ExecuteCommand(sqlCmd);
È»ºóÌáʾ´íÎó
Ö¸¶ ......
create view ±íÃû
as
select a.a1,b.b1 from a inner join b on a.id=b.id
Õâ¸öÓï·¨ÔõôдÉÏÈ¥ÊÇ´íµÄÔÚAccessÀï
ACCESSºÃÏñ²»Ö§³Öcreate view
Äã¿ÉÒÔÔÚACCESSÖе¥»÷¡°ÊÓͼ¡±²Ëµ¥£¬Ñ¡Ôñ¡°SQLÊÓͼ¡±ÃüÁ ......