数据库开发021 DataAdapter对象的Update方法

      当调用Update方法时，DataAdapter将检查参数DataSet每一行的RowState属性，根据RowState属性来检查DataSet里的每一行是否改变及改变的类型，并依次执行所需的INSERT、UPDATE或DELETE语句，将改变提交到数据库中，同时返回影响DataSet
的行数。

Imports System.Data.SqlClient
Public Class Form1
    Dim conn As SqlConnection
    Dim da As SqlDataAdapter
    Dim ds As New DataSet           '必须加“NEW”关键字
    Dim dt As New DataTable
    Private Function GetConnection() As SqlConnection
        Return New SqlConnection(My.Settings.SalesConnectionString)
    End Function

    Private Sub DisplayData1(ByVal str As String) '用DataReader对象
        DataGridView1.DataSource = Nothing

        conn = GetConnection()
        conn.Open()
        Dim comm As New SqlCommand(str, conn)
        Dim dr As SqlDataReader = comm.ExecuteReader
        Dim dt As New DataTable
        dt.Load(dr