将DataGridView数据保存到Access数据库

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path_to_access_database.accdb";
OleDbConnection connection = new OleDbConnection(connectionString);

string insertQuery = "INSERT INTO TableName (Field1, Field2, Field3) VALUES (@Value1, @Value2, @Value3)";
OleDbCommand command = new OleDbCommand(insertQuery, connection);
command.Parameters.AddWithValue("@Value1", dataGridView.Rows[rowIndex].Cells[0].Value);
command.Parameters.AddWithValue("@Value2", dataGridView.Rows[rowIndex].Cells[1].Value);
command.Parameters.AddWithValue("@Value3", dataGridView.Rows[rowIndex].Cells[2].Value);

connection.Open();
command.ExecuteNonQuery();
connection.Close();