使用DataGridView更新数据库表的C#

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace DataGridViewUpdateDatabase
{
    public partial class Form1 : Form
    {
        private SqlConnection connection;
        private SqlDataAdapter dataAdapter;
        private DataTable dataTable;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // 连接数据库
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
            connection = new SqlConnection(connectionString);

            // 查询数据
            string query = "SELECT * FROM YourTable";
            dataAdapter = new SqlDataAdapter(query, connection);
            dataTable = new DataTable();
            dataAdapter.Fill(dataTable);

            // 绑定数据
            dataGridView.DataSource = dataTable;
        }

        private void dataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            // 获取修改后的数据
            string updatedData = dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();

            // 构建更新语句
            string updateQuery = "UPDATE YourTable SET YourColumn = @UpdatedData WHERE ID = @ID";
            SqlCommand command = new SqlCommand(updateQuery, connection);
            command.Parameters.AddWithValue("@UpdatedData", updatedData);
            command.Parameters.AddWithValue("@ID", dataGridView.Rows[e.RowIndex].Cells["ID"].Value);

            // 更新数据库
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
        }
    }
}