'"PROVIDER=MSDASQL;DSN=polo;UID=sa;PWD=****;Database=****;" '以下代码为应用时用到 Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset sql = "select * from [power] where model='" & Modelf & "' and user_id=" & User_id rs.Open sql, conn, adOpenDynamic, adLockOptimistic
Dim rst As New ADODB.Recordset
cnn.open "连接字符串"
rst.open "sql语句",con,1,1
set DataGridl.DataSource = rst
'conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\datebase\xy.mdb;Persist Security Info=False"
'打开SQLSERVER数据库方法
'"PROVIDER=MSDASQL;DSN=polo;UID=sa;PWD=****;Database=****;"
'以下代码为应用时用到
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
sql = "select * from [power] where model='" & Modelf & "' and user_id=" & User_id
rs.Open sql, conn, adOpenDynamic, adLockOptimistic
cnn.CursorLocation = adUseClient
set DataGridl.DataSource = rst