Question

如何获得GridView中某一列所有值的和.C#,vs2005

Answer 1

在你行绑定的时候
private double sum = 0;//取指定列的数据和，你要根据具体情况对待可能你要处理的是int
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowIndex >= 0)
{
sum += Convert.ToDouble(e.Row.Cells[6].Text);
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[5].Text = "总薪水为：";
e.Row.Cells[6].Text = sum.ToString();
e.Row.Cells[3].Text = "平均薪水为：";
e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();

}
}

Answer 2

foreach (DataGridViewRow row in dgvDetail.Rows)
{
nums += decimal.Parse(row.Cells["Num"].Value.ToString());
total += decimal.Parse(row.Cells["Total"].Value.ToString());
}
这是DataGridView计算'Num'列和'Total列的值'
希望能帮到你

Answer 3

循环行，把你要的列上的值一个一个加起来