C# winform中怎么对dataGrid中的列累加求和

[zk911]

问题如题

请过路的朋友看一下

[cansum396]

调用 :Amount((datatable) Datagrid),要求和的列名,1)
public Decimal Amount(DataTable dt,string FieldName,Decimal Curr)
{
Decimal m_Amount=0;
DataTable mdt=new DataTable();
mdt=dt.Copy();
for (int i=0;i<mdt.Rows.Count;i++)
{
if(mdt.Rows[i].RowState.ToString()!="Deleted")
{
if(mdt.Rows[i][FieldName]==DBNull.Value)
{
m_Amount=m_Amount+0;
}
else
{
m_Amount=m_Amount+(Decimal) mdt.Rows[i][FieldName];
}
}
}
if(FieldName=="调整金额")
{
return Math.Round(m_Amount*Curr,2);
}
else
{
return Math.Round(m_Amount*Curr,1);
}
}

[gavinhuanghsc]

累计增量求和?通过数据库实现吧

[zk911]

我想通过datagrid求和 有更好的解决方法吗

[gavinhuanghsc]

貌似没有

[shiling_02404]

DataTable dt=this.DataGrid1.DataSource;
int sumvalue=0; //实际类型依你的而定
for(int i=0;i>dt.Rows.Count;i++)
{
sumvalue=sumvalue+Convert.ToInt32(dr.Rows[i][1]); //把所有行中第一列的值全部加起来.
}

[lnwuyaowei]

cansum396(漆黑的夜)
的方法更有通用性。

[孤剑]

private void button1_Click(object sender, EventArgs e)
{
DataTable dt = this.dataGridView1.DataSource as DataTable;

//
if (null == dt)
{
return;
}

long sum = (long)dt.Compute("sum(number)", string.Empty);

MessageBox.Show(sum.ToString());
}

[孤剑]

namespace Test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void test()
{
//System.Diagnostics.Debug.WriteLine(this.textBox1.SelectionStart.ToString());

}

private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = this.CreateTestDataTable();

for (int i = 0; i < 100; i++)
{
dt.Rows.Add(new object[] { i, i });
}
dt.AcceptChanges();

this.dataGridView1.DataSource = dt;
}

private DataTable CreateTestDataTable()
{
DataTable dt = new DataTable("test");

dt.Columns.Add(new DataColumn("index", typeof(int)));
dt.Columns.Add(new DataColumn("number", typeof(int)));

dt.AcceptChanges();

return dt;
}

private void button1_Click(object sender, EventArgs e)
{
DataTable dt = this.dataGridView1.DataSource as DataTable;

//
if (null == dt)
{
return;
}

long sum = (long)dt.Compute("sum(number)", string.Empty);

MessageBox.Show(sum.ToString());
}

}
}