怎么将gridview中的数据更新回数据库

如何将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还是很方便的。
------解决方案--------------------
建议不要用这个写