如何将gridview中的数据更新回数据库
Private Sub Huizhongqingdan_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim HuizongDataSet As New DataSet
Dim dbcnt As SqlConnection = New SqlConnection()
dbcnt.ConnectionString = cstring
adp = New SqlDataAdapter("SELECT * FROM [汇总清单表] where 1=1", dbcnt)
BumenCmb.Items.Clear()
try
dbcnt.Open()
adp.Fill(HuizongDataSet)

DataGridView1.DataSource = HuizongDataSet.Tables("汇总清单表")

Catch ex As Exception
MsgBox(ex.ToString(), MsgBoxStyle.Critical, "不可预知错误")
Finally
dbcnt.Close()
End Try

End Sub



Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Try

Dim cBuilder As New SqlCommandBuilder(adp) '创建一个CommandBuilder对象 　　
adp.Update(HuizongDataSet, "汇总清单表") '更新数据集
Catch sqlExc As Exception '异常处理 　　　　　　
MessageBox.Show(sqlExc.ToString, "SQL 异常错误!", MessageBoxButtons.OK, MessageBoxIcon.Error)
Exit Sub
End Try
Else
MsgBox("您没有作任何更改", MsgBoxStyle.Information, "提示")
End If
End Sub

更新不好用 新手求助 表有主键

[解决办法]
参考
http://topic.csdn.net/u/20081013/21/8efdd7f9-4298-407e-a004-97f30f346ae0.html
http://topic.csdn.net/u/20080802/11/ef2d2809-b061-45cd-b56e-1d0bed8d12f2.html
[解决办法]
掉用update方法，修改的依据就是id，需要改那些传过去那些旧ok！
[解决办法]
多条数据同时修改，SqlCommandBuilder还是很方便的。
[解决办法]
建议不要用这个写