设置一个adodb.connection变量 set rs = connection.execute sql 然后对rs记录集进行显示就行了
之后还要声明变量,如DIM SQL AS STRING 然后就可以写SQL语句了
'M_CONN 是我创建的一个连接 返回值,1 成功 2 错误 0 查询结果为空 Function runsql(rs As ADODB.Recordset, strsql As String) On Error Resume Next 'MsgBox strsql On Error Resume Next rs.Open strsql, m_conn, 1, 3 If Err.Number <> 0 Then runsql = 2 Exit Function End If If rs.EOF Then runsql = 0 Exit Function End If runsql = 1End Function
Dim sql As String sql = "select * from 数据库名字 where 字段名= '" & Trim(Text1.Text) & "' and 字段名='" & Trim(Text2.Text) & "'" Adodc1.RecordSource = sql Adodc1.Refresh
set rs = connection.execute sql
然后对rs记录集进行显示就行了
然后就可以写SQL语句了
Function runsql(rs As ADODB.Recordset, strsql As String)
On Error Resume Next
'MsgBox strsql
On Error Resume Next
rs.Open strsql, m_conn, 1, 3
If Err.Number <> 0 Then
runsql = 2
Exit Function
End If
If rs.EOF Then
runsql = 0
Exit Function
End If
runsql = 1End Function
sql = "select * from 数据库名字 where 字段名= '" & Trim(Text1.Text) & "' and 字段名='" & Trim(Text2.Text) & "'"
Adodc1.RecordSource = sql
Adodc1.Refresh