'举个不绑定的例子
n = 5 'DbGrid1的记录数
ReDim ss(n)
For i = 0 To n
DbGrid1.Row = i
for j= 0 to 2
ss(j) = DbGrid1.Columns(j).Value '循环得到第一列值
next j
cn.Execute "insert into 表 (字段1,字段2,字段3) value ('" & ss(0) & "','" _
& ss(1) & "','" & ss(2) & "')"
Next i
用ADO写吧,将dbgrid绑定ADO,dbgrid修改后,直接updatebatch下ADO就成了。
'数据绑定
Private Sub RstChange(ByVal rSql As String)
Dim sRst As New ADODB.Recordset
On Error GoTo err
sRst.Open rSql, cnn, adOpenDynamic, adLockBatchOptimistic
Set Adodc1.Recordset = sRst
Set DG_1.DataSource = Adodc1.Recordset
DG_1.Refresh
Exit Sub
err:
Showerr err.Description
Exit Sub
End Sub
'数据修改
Private Sub Cmd_Save_Click()
On Error GoTo err
cnn.BeginTrans
Adodc1.Recordset.UpdateBatch
cnn.CommitTrans
sChange = 0
Exit Sub
err:
cnn.RollbackTrans
msgbox err.Description,vbokonly,"提示"
Exit Sub
End Sub