Option ExplicitPublic Rs As New ADODB.Recordset Public adoRs As New ADODB.Recordset Public Conn As New ADODB.Connection Dim i As Integer Dim j As IntegerPublic Sub Make_Connection() Dim strConn As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\TEST!\People.mdb;Persist Security Info=False"
Public adoRs As New ADODB.Recordset
Public Conn As New ADODB.Connection
Dim i As Integer
Dim j As IntegerPublic Sub Make_Connection()
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\TEST!\People.mdb;Persist Security Info=False"
Conn.CursorLocation = adUseClient
Conn.Open strConn
End SubPrivate Sub DataGrid1_DblClick() On Error Resume Next
adoRs.AddNew
adoRs(0) = Me.DataGrid1.Columns(0).Text
adoRs(1) = Me.DataGrid1.Columns(1).Text
adoRs(2) = Me.DataGrid1.Columns(2).Text
adoRs.Update
End Sub
Private Sub Form_Load()
Call Make_Connection
If Rs.State <> adStateClosed Then Rs.Close
Rs.Open "Select * from Man", Conn, adOpenStatic, adLockOptimistic
Set Me.DataGrid1.DataSource = Rs
Call Make_Connection2
End SubPublic Sub Make_Connection2()
For i = 0 To 2
adoRs.Fields.Append "n * " & i + 1, adVariant, , adFldMayBeNull + adFldIsNullable + adFldUpdatable
Next i
adoRs.Open Set Me.DataGrid2.DataSource = adoRs
End Sub
'
不是简单的移动
如:
01 aa
02 bb
03 cc
拖动第三记录放在01与02之间
在里表现为:
01 aa
02 cc
03 bb
01,02,03为表里的序号字段