1,453
社区成员




Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cnstr As String
Dim sql As String
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
cnstr = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=hxzl_dbf" '本句须改为你的数据连接句
sql = "select name,price,total from products"
con.Open cnstr
rs.CursorLocation = adUseClient
rs.Open sql, con, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = rs
DataGrid1.Refresh