è¦å©ç¨æ°æ®æ§ä»¶è¿åæ°æ®åºä¸è®°å½çéåï¼åºå
å¨çªä½ä¸ç»åºæ§ä»¶ï¼åéè¿å®çä¸ä¸ªåºæ¬å±æ§ConnectãDatabaseNameåRecordSource设置è¦è®¿é®çæ°æ®èµæºã
ã
6ï¼3ï¼1 æ°æ®æ§ä»¶å±æ§
1ï¼Connectå±æ§
Connectå±æ§æå®æ°æ®æ§ä»¶æè¦è¿æ¥çæ°æ®åºç±»åï¼Visual Basicé»è®¤çæ°æ®åºæ¯AccessçMDBæ件ï¼æ¤å¤ï¼ä¹å¯è¿æ¥DBFãXLSãODBCçç±»åçæ°æ®åºã
2ï¼DatabaseNameå±æ§
DatabaseNameå±æ§æå®å
·ä½ä½¿ç¨çæ°æ®åºæ件åï¼å
æ¬ææçè·¯å¾åãå¦æè¿æ¥çæ¯å表æ°æ®åºï¼åDatabaseNameå±æ§åºè®¾ç½®ä¸ºæ°æ®åºæ件æå¨çåç®å½åï¼èå
·ä½æ件åæ¾å¨RecordSourceå±æ§ä¸ã
ä¾å¦ï¼è¦è¿æ¥ä¸ä¸ªMicrosoft Accessçæ°æ®åºC:\Student.mdbï¼å设置DatabaseName=âC:ï¼¼Student.mdb"ï¼Accessæ°æ®åºçææ表é½å
å«å¨ä¸ä¸ªMDBæ件ä¸ãå¦æè¿æ¥ä¸ä¸ªFoxProæ°æ®åºå¦C:ï¼¼VB6ï¼¼stu_fox.dbf,åDatabaseName=âC:ï¼¼VB6âï¼RecordSource=âstu_fox.dbfâï¼stu_foxæ°æ®åºåªå«æä¸ä¸ªè¡¨ã
3ï¼RecordSourceå±æ§
RecordSourceç¡®å®å
·ä½å¯è®¿é®çæ°æ®ï¼è¿äºæ°æ®ææè®°å½é对象Recordsetã该å±æ§å¼å¯ä»¥æ¯æ°æ®åºä¸çå个表åãä¸ä¸ªåå¨æ¥è¯¢æè
æ¯ä½¿ç¨SQLæ¥è¯¢è¯è¨çä¸ä¸ªæ¥è¯¢å符串ã
ä¾å¦ï¼è¦æå®Student.mdbæ°æ®åºä¸çåºæ¬æ
åµè¡¨ï¼åRecordSource=âåºæ¬æ
åµâãèRecordSource=âSelect * From åºæ¬æ
åµWhereä¸ä¸=âç©çâ âï¼å表示è¦è®¿é®åºæ¬æ
åµè¡¨ä¸ææç©çç³»å¦ççæ°æ®ã
4ï¼RecordTypeå±æ§
RecordTypeå±æ§ç¡®å®è®°å½éç±»åã
5ï¼EofActionåBofActionå±æ§
å½è®°å½æéæåRecordset对象çå¼å§(第ä¸ä¸ªè®°å½å)æç»æ(æåä¸ä¸ªè®°å½å)æ¶ï¼æ°æ®æ§ä»¶çBofActionåEofActionå±æ§ç设置æè¿åå¼å³å®äºæ°æ®æ§ä»¶è¦éåçæä½ãå±æ§çåå¼å¦è¡¨6.1æ示ã
表6.1 EofActionåBofActionå±æ§
å±æ§
åå¼
æä½
BofAction
0
æ§ä»¶éå®ä½å°ç¬¬â个记å½
1
移è¿è®°å½éå¼å§ä½ï¼å®ä½å°ä¸ä¸ªæ æè®°å½ï¼è§¦åæ°æ®æ§ä»¶å¯¹ç¬¬ä¸ä¸ªè®°å½çæ æäºä»¶Validate
EofAction
0
æ§ä»¶éå®ä½å°æåâ个记å½
1
移è¿è®°å½éç»æä½ï¼å®ä½å°ä¸ä¸ªæ æè®°å½ï¼è§¦åæ°æ® æ§ä»¶å¯¹æåä¸ä¸ªè®°å½çæ æäºä»¶Validate
2
åè®°å½éå å
¥æ°ç空记å½ï¼å¯ä»¥å¯¹æ°è®°å½è¿è¡ç¼è¾ï¼ç§»å¨è®°å½æéï¼æ°è®°å½åå
¥æ°æ®åº
å¨Visual Basicä¸ï¼æ°æ®æ§ä»¶æ¬èº«ä¸è½ç´æ¥æ¾ç¤ºè®°å½éä¸çæ°æ®ï¼å¿
é¡»éè¿è½ä¸å®ç»å®çæ§ä»¶æ¥å®ç°ãå¯ä¸æ°æ®æ§ä»¶ç»å®çæ§ä»¶å¯¹è±¡æææ¬æ¡ãæ ç¾ãå¾åæ¡ãå¾å½¢æ¡ãå表æ¡ãç»åæ¡ãå¤éæ¡ãç½æ ¼ãDBå表æ¡ãDBç»åæ¡ãDBç½æ ¼åOLE容å¨çæ§ä»¶ãè¦ä½¿ç»å®æ§ä»¶è½è¢«æ°æ®åºçº¦æï¼å¿
éå¨è®¾è®¡æè¿è¡æ¶å¯¹è¿äºæ§ä»¶ç两个å±æ§è¿è¡è®¾ç½®ï¼
• DataSourceå±æ§è¯¥å±æ§éè¿æå®â个ææçæ°æ®æ§ä»¶è¿æ¥å°ä¸ä¸ªæ°æ®åºä¸ã
• DataFieldå±æ§è¯¥å±æ§è®¾ç½®æ°æ®åºææçå段ä¸ç»å®æ§ä»¶å»ºç«èç³»ã
ç»å®æ§ä»¶ãæ°æ®æ§ä»¶åæ°æ®åºä¸è
çå
³ç³»
ç¨å¯è§åæ°æ®ç®¡çå¨å»ºç«ä»¥ä¸è®¾è®¡çæ°æ®åºåå
¶è¡¨ï¼è¡¨ä¸æ°æ®å¯èªè¡å½å
¥ã
温馨提示:答案为网友推荐,仅供参考