form load connect.Open "file name=F:\aa.udl" RefreshRstPrivate Sub RefreshRst(aaa As String) 'oSql = "select * from 图书" oSql = "select * from 图书 where 1=1 " & aaa Set rst = New ADODB.Recordset rst.Open oSql, connect, adOpenStatic, adLockReadOnly Set DataGrid1.DataSource = rst End Sub
connect.Open "file name=F:\aa.udl"
RefreshRstPrivate Sub RefreshRst(aaa As String)
'oSql = "select * from 图书"
oSql = "select * from 图书 where 1=1 " & aaa
Set rst = New ADODB.Recordset
rst.Open oSql, connect, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = rst
End Sub