在传递带有已修改行的DataRow集合时,Update需要有效的UpdateCommand

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True";
        string selectCommand = "SELECT * FROM Customers";
        string updateCommand = "UPDATE Customers SET CompanyName=@CompanyName, ContactName=@ContactName WHERE CustomerID=@CustomerID";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlDataAdapter adapter = new SqlDataAdapter(selectCommand, connection);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
            adapter.UpdateCommand = builder.GetUpdateCommand();
            adapter.UpdateCommand.CommandText = updateCommand;

            DataTable table = new DataTable();
            adapter.Fill(table);

            DataRowCollection rows = table.Rows;
            foreach (DataRow row in rows)
            {
                row["CompanyName"] = "New Company Name";
                row["ContactName"] = "New Contact Name";
            }

            adapter.Update(table);
        }
    }
}