recordsetName.addnew recordsetName.fields("第一个字段").value = aa . . . recordsetName.update datagrid.refresh
AdodcForAttendanceCheck As ADODB.Recordset AdodcForAttendanceCheck.AddNew Set DataGridForAttendanceCheck.DataSource = AdodcForAttendanceCheck 输完数据后再 AdodcForAttendanceCheck.update
Private Sub btn_insert_Click()
With Dg_sub .AllowAddNew = True .AllowUpdate = True If .ApproxCount >= 1 Then .Row = Dg_sub.ApproxCount .col = 0 End If Call set_btn End With
recordsetName.fields("第一个字段").value = aa
.
.
.
recordsetName.update
datagrid.refresh
AdodcForAttendanceCheck.AddNew
Set DataGridForAttendanceCheck.DataSource = AdodcForAttendanceCheck
输完数据后再
AdodcForAttendanceCheck.update
With Dg_sub
.AllowAddNew = True
.AllowUpdate = True
If .ApproxCount >= 1 Then
.Row = Dg_sub.ApproxCount
.col = 0
End If
Call set_btn
End With
end sub
Dg_sub.AllowUpdate = True
Call set_btn
End Sub
On Error GoTo errhandle
.AllowAddNew = False
.AllowUpdate = False
rst.UpdateBatch
Call set_dg
End Function
我写的时候是用
adodc1.recordset.addnew
如果不行就试试这段代码
WITH bd
.allowaddnew=true
.allowupdata=true
end with
adodc1.recordset.addnew
recordsetName.fields("第一个字段").value = trim(edit1.text)
.
其它相应的字段
.
recordsetName.update
datagrid.refresh