public void TotalRow(DataGridView dg)
{
dg.Rows.Add();
DataGridViewRow dgr = dg.Rows[dg.Rows.Count - 1];
dgr.ReadOnly = true;
dgr.DefaultCellStyle.BackColor = System.Drawing.Color.Khaki;
dgr.Cells[0].Value = "合计";
for (int i = 0; i < dg.Rows.Count - 1; i++)
{
dgr.Cells[3].Value = Convert.ToSingle(dgr.Cells[3].Value) + Convert.ToSingle(dg.Rows[i].Cells[3].Value);
}
}用这种很不错,不过就是提示错误:
绑定数据后,不能在加一行,我应该怎么来做。
在线等,先谢谢了
{
dg.Rows.Add();
DataGridViewRow dgr = dg.Rows[dg.Rows.Count - 1];
dgr.ReadOnly = true;
dgr.DefaultCellStyle.BackColor = System.Drawing.Color.Khaki;
dgr.Cells[0].Value = "合计";
for (int i = 0; i < dg.Rows.Count - 1; i++)
{
dgr.Cells[3].Value = Convert.ToSingle(dgr.Cells[3].Value) + Convert.ToSingle(dg.Rows[i].Cells[3].Value);
}
}用这种很不错,不过就是提示错误:
绑定数据后,不能在加一行,我应该怎么来做。
在线等,先谢谢了
可以在FOOT中做
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
decimal Num = 0;
decimal Money = 0; for (int i = 0; i < dt.Rows.Count; i++)
{
Num = Num + Utilities.ConvertStringToDeciamal(dt.Rows[i]["Num"].ToString());
Money = Money + Utilities.ConvertStringToDeciamal(dt.Rows[i]["Money"].ToString());
}
dr["MerName"] = "合计:";
dr["Num"] = Num;
dr["Money"] = Money;
dt.Rows.Add(dr);
}
}
这是我做的时候的一段代码,dt是DataTable,最后把dt赋给DataGridView