如何编辑DataGridView中的行？MS Access数据库

// 绑定数据到DataGridView
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=your_database.accdb";
string query = "SELECT * FROM your_table";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    OleDbDataAdapter adapter = new OleDbDataAdapter(query, connection);
    DataTable dataTable = new DataTable();
    adapter.Fill(dataTable);
    dataGridView1.DataSource = dataTable;
}

// 启用编辑模式
dataGridView1.ReadOnly = false;

// 双击行启动编辑模式
dataGridView1.CellDoubleClick += DataGridView_CellDoubleClick;

// 双击事件处理程序
private void DataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
    if (e.RowIndex >= 0)
    {
        DataGridViewRow selectedRow = dataGridView1.Rows[e.RowIndex];
        // 编辑选定行的单元格值
        // 例如，修改第一个单元格的值
        selectedRow.Cells[0].Value = "New Value";
    }
}

// 保存修改回数据库
private void SaveChangesToDatabase()
{
    // 使用适当的方法将修改保存回数据库
    // 例如，使用ADO.NET执行更新操作
    string updateQuery = "UPDATE your_table SET column1 = @value WHERE id = @id";
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        connection.Open();
        foreach (DataGridViewRow row in dataGridView1.Rows)
        {
            int id = Convert.ToInt32(row.Cells["idColumn"].Value);
            string value = Convert.ToString(row.Cells["column1"].Value);
            using (OleDbCommand command = new OleDbCommand(updateQuery, connection))
            {
                command.Parameters.AddWithValue("@value", value);
                command.Parameters.AddWithValue("@id", id);
                command.ExecuteNonQuery();
            }
        }
    }
}