数据库如何与DataTable同步

关于使用adapter.update更新数据库的问题作一个系统性的总结
首先参照MSDN上的代码，结合access数据库，生成代码如下


  Private Sub modityRow()
  
    Dim connectionString As String = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = mag.mdb"
    Dim queryString As String = "select * from payinfo"
    Dim DS As DataSet = New DataSet
    
    Using connection As New OleDbConnection(connectionString)
    connection.Open()
    Dim adapter As New OleDbDataAdapter()
    adapter.SelectCommand = New OleDbCommand(queryString, connection)
    Dim dbcb As OleDbCommandBuilder = New OleDbCommandBuilder(adapter)
    
    adapter.Fill(DS, "access")
    
    '
    '******************************
    '
    '这里填入修改dataSet的代码
    '
    '******************************
    '