如何利用SQL数据库计算DataGridView中各行金额合计

// 假设已经连接到了名为"数据库名"的SQL数据库

// 获取DataGridView中每一行的金额值
List<decimal> amounts = new List<decimal>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
    decimal amount = Convert.ToDecimal(row.Cells["金额字段名"].Value);
    amounts.Add(amount);
}

// 构建SQL查询语句
string query = "SELECT SUM(金额字段名) FROM 表名";

// 执行SQL查询，并获取计算结果
decimal totalAmount = 0;
using (SqlConnection connection = new SqlConnection("连接字符串"))
{
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    totalAmount = Convert.ToDecimal(command.ExecuteScalar());
}

// 在DataGridView中显示计算结果
dataGridView1.Rows.Add();
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["金额字段名"].Value = totalAmount;