΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000No.19No.1P.17-18




Visual BasicݷʽӿڵıȽϺ̽

ժ Ҫ Visual Basic3ֲͬݷʽӿڽбȽϣ໥תϵ 
ؼʣݷʽӿ DAOӿ RDOӿ ADOӿ
1 Visual Basicеݷʽӿ
ݷʽӿ1ģͣ˷ݵĸ档Visual BasicУõݷʽӿ3֣ADOActiveX Data ObjectsRDORemote Data ObjectsDAOData Access ObjectsݷʼĲϽ3ֽӿڷֱ˸üĲͬչ׶Ρ
2 3ֽӿڵıȽ
DAOݷʶǵ1Ľӿڣ¶Microsoft Jetݿ棨Microsoft AccessʹãVisual BasicͨODBCֱӵݿһֱӵAccessݿ⡣
RDOԶݶ1ODBCġݷʽӿڣͬʹõDAO styleһṩ1ӿڣʽչʾODBCĵײ㹦ܺԡRDOڷJetISAMݿⷽܵƣִֻͨODBCʹϵݿ⡣ǣRDOṩʴ洢̺͸ӽĸ͸ӵĶԼ
ADOΪMicrosoftºǿݷʷOLE DBƵģ1ʹõӦóӿڡOLE DBΪκԴṩ˸ܵķʣЩԴϵͷǹϵݿ⡢ʼļϵͳıͼΡԶҵȵȡADOڹؼInternetʹٵǰ˺Դ֮ʹٵĲЩΪṩܵĽӿڡ
3 Visual Basicжֽӿڵʵ
ͨһЩʵADORDODAOĲ֮ͬһȽϣDAOԽϼ򵥣ֻRDOADOбȽϡ
3.1 ĳݿ
1RDOҪ1ӣṩ1ַRDOҪ1rdoQueryʱǲҪӵģ1rdoResultsetʱҪġ
Dim cn As New rdoConnection
Const ConnectionStringuidjxypwd123driverSQLServer_serversalesserverdatabasesalesdsn
ַ1ضSQL ServerODBCûDSN´1ӡ1б׼ĵODBCַ
ڴLoad¼УαԼ¼ʱȱʡ£RDOʹrdUseIfNeededαͣ͵SQL ServerϷ˵αꡣʾָrdUseNoneӶʹȱʡ涨ءrdDriverNoPrompt־ζûID벻ƥ䣬Ӧó򽫲һPrivate Sub Form_Load
With cn
cnConnectConnectString
cnLoginTimeout10
cnCursorDriverrdUseNone
cnEstablishConnection rdDriverNoPrompt
End With
End Sub
2ADOҪADOн1ݿӣȴ1ɱADODBõADOЩԺôӺgenerateضԣ
Dim cn As New ADODBConnection
Dim rs As New ADODBRecordset
Dim Qy As New ADODBCommand
洴1ַRDOʾ2£ʹODBCġǣDSNӲԽʡʱ䣬ܣ
Const ConnectionStringuidjxypwd123driverSQLServer_serversalesserverdatabasesalesdsn
󣬴1Form_Load¼ĳݿADOӡôRDOǺƵģֻԡad忪ʼģǡrd塣ǲҪָʾΪΪADOȱʡΪʾѡиģʹADO PropertiesϣʾΪRDOУOpenConnectionΪADOУProperties Prompt壩ԡͬʱʹα򲻱ضָRDOеCursorDriverrdUseNoneΪADOȱʡ涨α
Private Sub Form_Load
With cn
佨DSN
ConnectionStringConnectString
ConnectionTimeout15
䣮PropertiesPrompt壩adPromptNever
This is the default prompting mode in ADO
Open
End With
End Sub
3.2 зضĴ洢
1RDOڴ洢˵ض򷵻ذѯĶǺͨġдֱÿ򽫲ʹԼĲѯRDOУͨMoreResultsÿδ1ÿζMoreResultsĵöرյǰĽƶ1еĻ
Private Sub MultipleRSButton_Click
sqlSelect * from Employees Where age is not null_  Select * from Employees where age is null
Set rscnOpenResultsetsql
rdoGrid1ShowData rs
iMsgBoxһ壬vbYesNoCancel
If ivbYes Then
If rsMoreResults Then
rdoGridlShowData rs
End If
End If
End Sub
2ADOĴ˵ADOдضSPADOĽRDOĲ֮ͬڣADOõNextRecordsetڸ÷Уеһ¼ĳADO Recordsetһ¼ĶȡǵһͬRDOеADO¼ṩֵ֧Ļ
Private Sub MultipleRSButton_Click
Dim rs As New ADODBRecordsetsqlSelect * from Employees Where age is not null_  Select * from Employees where age is null
rsOpen sqlcn
Do
iMsgBoxһ壬vbYesNoCancel
If ivbYes Then
ADOGridlShowData rs
Set rsrsNextRecordset
End If
Loop Until rsStateadStateClosed
End Sub
4  
3ݷʽӿDAOڵϵͳӦóСΧطֲʹãRDOѱ֤SQL ServerOracleԼ͹ϵݿ⿪߾ѡõѽӿڡADODAORDOĺ̲ADO 20ڹRDOƣһ˵2ģ֮һƵӳϵADOչDAORDOʹõĶģͣζٵĶ󡢸ԡͲԼ¼
3ֽӿµADOǱRDODAOӼ򵥡Ķģ͡¹̣ӦʹADOΪݷʽӿڡ
ADOԶִݷӦóݵġADOװDAORDOĹԵʱ򣬱뽫ҪתΪADO﷨ĳЩ£⽫ζִĳЩܵ1ת£ѵADO¹дӦóͬʱҪעǣADOǰ֧DAOйܡADOҪRDOĹԣԱOLE DBԴ⻹Զ̺DHTML
һ˵ADOݻУϰѴDAOӦóֲADOϿΪʱ̫磬ΪǰADO֧ݶ壨DDLûȡֻDAOڿͻӦó򣬶JetݿʹDDLôھͿֲADO
Ϻͨѧѧ빤ϵ200030
ոڣ19990710
