Private Sub Form1_Load()
Private cnn As ADODB.Connection
Private mRs As ADODB.Recordset
Dim strSQL As String
' 把cnn设为adodb的连接
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Password=kikuchi;Persist Security Info=True;User ID=kikuchi;Data Source=SCAW"
cnn.Open
'把mRs作为Recordset
Set mRs = New ADODB.Recordset
'选中两个表md1,mdb中条件一致(where m.sort=b.sort)的全部记录11个项目
strSQL = "select m.reno, m.siname, m.position,m.ksname,m.post,m.address,m.tel, m.fax,m.mobile,m.email,b.stname from md1 m,mdb b where m.sort=b.sort "
mRs.CursorLocation = adUseClient
mRs.Open strSQL, cnn, adOpenStatic, adLockReadOnly, adCmdText
End Sub
以下是根据三个检索条件设置 Command1,但显示在dagagrid里的只有5个项目
private Sub Command1_Click()
Dim strSQL As String
Dim nm As String
Dim ksm As String
Dim sbt As String
nm = Text1.Text
ksm = Text2.Text
sbt = Combo1.Text
If Len(nm) >= 6 Or Len(ksm) >= 20 Then
MsgBox "输入错误"
ElseIf Len(nm) = 0 And Len(ksm) = 0 And Len(sbt) = 0 Then
strSQL = "select m.siname, m.ksname, m.address,m.tel,b.stname from md1 m,mdb b where m.sort=b.sort"
'检索处理
Else
strSQL = "select m.siname, m.ksname, m.address,m.tel,b.stname from md1 m,mdb b where m.sort=b.sort and m.siname like'" & "%" & nm & "%" & "'" & "and m.ksname like'" & ksm & "%" & "'" & "and b.stname like'" & "%" & sbt & "%" & "'"
End If