如何在Visual Basic中从DataGridView更新Access数据库

Imports System.Data.OleDb

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\database.accdb"

Using connection As New OleDbConnection(connectionString)
    connection.Open()
    ' 执行数据库操作
End Using

Dim updateQuery As String = "UPDATE TableName SET Column1 = @Value1, Column2 = @Value2 WHERE ID = @ID"

For Each row As DataGridViewRow In dataGridView1.Rows
    If Not row.IsNewRow Then
        Dim command As New OleDbCommand(updateQuery, connection)
        command.Parameters.AddWithValue("@Value1", row.Cells("Column1").Value)
        command.Parameters.AddWithValue("@Value2", row.Cells("Column2").Value)
        command.Parameters.AddWithValue("@ID", row.Cells("ID").Value)
        command.ExecuteNonQuery()
    End If
Next

connection.Close()