?? mdlcommon.bas
字號:
Attribute VB_Name = "mdlCommon"
Option Explicit
Public Sub OpenTable(pAdo As Adodc, pRecordSource As String) '打開一個表,得到一個數(shù)據(jù)集
With pAdo
.ConnectionString = "dsn=hotel"
.CommandType = adCmdUnknown
.RecordSource = pRecordSource
.Refresh
End With
End Sub
Public Function get_test() As ADODB.Recordset
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
conn.ConnectionString = "dsn=test"
rs.Open "select * from test where age>20", conn
get_test = rs
End Function
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -