将dataGridView中的列值插入数据库表

using System;
using System.Data.SqlClient;

// 数据库连接字符串
string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=YourDatabase;Integrated Security=True";

try
{
    // 连接数据库
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        
        // 遍历 dataGridView 中的行
        foreach (DataGridViewRow row in dataGridView.Rows)
        {
            // 获取每一行的列值
            string column1Value = row.Cells["ColumnName1"].Value.ToString();
            string column2Value = row.Cells["ColumnName2"].Value.ToString();
            // ...
            
            // 创建插入语句
            string insertQuery = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2)";
            
            // 创建参数并设置值
            SqlCommand command = new SqlCommand(insertQuery, connection);
            command.Parameters.AddWithValue("@Value1", column1Value);
            command.Parameters.AddWithValue("@Value2", column2Value);
            
            // 执行插入语句
            command.ExecuteNonQuery();
        }
    }
    
    Console.WriteLine("数据插入成功！");
}
catch (Exception ex)
{
    Console.WriteLine("发生错误：" + ex.Message);
}