'窗体上放1个DataGird、3个CommandButton Option Explicit Public mCnnString As String Public mRst As New ADODB.RecordsetPrivate Sub Command1_Click() '保存按钮 mRst.UpdateBatch End SubPrivate Sub Command2_Click() '增加按钮 mRst.AddNew End SubPrivate Sub Command3_Click() '删除按钮 mRst.Delete End SubPrivate Sub Form_Load() mCnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb" & ";Persist Security Info=False" If mRst.State = adStateOpen Then mRst.Close mRst.CursorLocation = adUseClient mRst.Open "Select * From Table1", mCnnString, adOpenStatic, adLockBatchOptimistic, adCmdText Set DataGrid1.DataSource = mRst DataGrid1.Refresh End SubPrivate Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) mRst.Close Set mRst = Nothing End Sub
...
Rec!字段="值"
Rec.Update
...
Option Explicit
Public mCnnString As String
Public mRst As New ADODB.RecordsetPrivate Sub Command1_Click() '保存按钮
mRst.UpdateBatch
End SubPrivate Sub Command2_Click() '增加按钮
mRst.AddNew
End SubPrivate Sub Command3_Click() '删除按钮
mRst.Delete
End SubPrivate Sub Form_Load()
mCnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb" & ";Persist Security Info=False"
If mRst.State = adStateOpen Then mRst.Close
mRst.CursorLocation = adUseClient
mRst.Open "Select * From Table1", mCnnString, adOpenStatic, adLockBatchOptimistic, adCmdText
Set DataGrid1.DataSource = mRst
DataGrid1.Refresh
End SubPrivate Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
mRst.Close
Set mRst = Nothing
End Sub
事务开始Conn.BeginTrans
事务回滚Conn.RollbackTrans
事务结束Conn.CommitTrans
可用mRst.fields(Index)=textbox的方法赋值,再用update将修改的数据写入到数据库