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

{

if (dgv.DataSource == null) return;

//DataTable dt = (DataTable)dgv.DataSource;

if (dt.Rows.Count < 1) return;

decimal[] tal = new decimal[dt.Columns.Count];

DataRow ndr = dt.NewRow();

string talc = "";

int number = 1;

foreach (DataRow dr in dt.Rows)

{

dr[xh_field] = number++;

int n = 0;

foreach (DataColumn dc in dt.Columns)

{

if (talc == "" && dc.DataType.Name.ToUpper().IndexOf("STRING") >= 0)

{ talc = dc.ColumnName; }

if (dc.DataType.IsValueType)

{

string hej = dr[dc.ColumnName].ToString();

try

{

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

}

catch (Exception) { }

//if (hej != string.Empty) tal[n] += decimal.Parse(hej);

}

n++;

}

}

ndr.BeginEdit();

for (int i = 0; i < dt.Columns.Count; i++)

{

if (tal[i] != 0)

ndr[i] = tal[i];

}

ndr[xh_field] = ((int)(dt.Rows.Count + 1)).ToString();

if (talc != "") ndr[talc] = "合计";

ndr.EndEdit();

dt.Rows.Add(ndr);

dgv.Rows[dgv.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(255, 222, 210);

dgv.Rows[dgv.Rows.Count - 1].ReadOnly = true;

if (dgv.Tag == null)

{

foreach (DataGridViewColumn dgvc in dgv.Columns)

{

dgvc.SortMode = DataGridViewColumnSortMode.Programmatic;

}

}

dgv.Tag = ndr;

}

private void dataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)

{

DataGridView sortDgv = (DataGridView)sender;

int fx = 0;

if (sortDgv.AccessibleDescription == null)

{

fx = 1;

}

else

{

fx = int.Parse(sortDgv.AccessibleDescription);

fx = (fx == 0 ? 1 : 0);

}

sortDgv.AccessibleDescription = fx.ToString();

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