datagridview 合计_datagridview和textbox_vb.net datagridview(4)

{

DataColumn dc = new DataColumn(xh_field, System.Type.GetType("System.Int32"));

dt.Columns.Add(dc);

dgv.Columns[xh_field].DisplayIndex = 0;

dgv.Columns[xh_field].HeaderText = "序号";

dgv.Columns[xh_field].SortMode = DataGridViewColumnSortMode.Programmatic;

dgv.AutoResizeColumn(dgv.Columns[xh_field].Index);

dgv.Columns[xh_field].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

dgv.Columns[xh_field].Visible = true;

}

SumDataGridView(dgv);

}

private void dataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)

{

DataGridView dgv = (DataGridView)sender;

if (dgv.Tag == null || e.RowIndex < 0 || e.RowIndex == dgv.Rows.Count - 1) return;

string col = dgv.Columns[e.ColumnIndex].DataPropertyName;

if (col == string.Empty) return;

if (((DataRowView)dgv.Rows[e.RowIndex].DataBoundItem).Row.Table.Columns[col].DataType.IsValueType)

{

decimal tal = 0;

foreach (DataGridViewRow dgvr in dgv.Rows)

{

if (dgvr.Index != dgv.Rows.Count - 1)

{

string hej = dgvr.Cells[e.ColumnIndex].Value.ToString();

if (hej != string.Empty) tal += decimal.Parse(hej);

}

}

if (tal == 0)

dgv[e.ColumnIndex, dgv.Rows.Count - 1].Value = DBNull.Value;

else

dgv[e.ColumnIndex, dgv.Rows.Count - 1].Value = tal;

}

}

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/tongxinshuyu/article-50071-4.html