1,451
社区成员
发帖
与我相关
我的任务
分享
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\收集\特别sql\date.mdb;Persist Security Info=False"
rs.Open "select * from c", cn, adOpenStatic, adLockOptimistic
Set fpSpread1.DataSource = rs
fpSpread1.Refresh
End Sub
Private Sub fpSpread1_Click(ByVal Col As Long, ByVal Row As Long)
Dim i As Integer
rs.MoveFirst
rs.Move Row - 1
For i = 0 To rs.Fields.Count - 1
Debug.Print rs.Fields(i)
Next i
End Sub
Private Sub Form_Unload(Cancel As Integer)
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub