DataGridView自动添加合计行

最新推荐文章于 2025-07-07 16:04:51 发布

转载最新推荐文章于 2025-07-07 16:04:51 发布 · 404 阅读

文章标签：

#null #string #object #exception #system #class

C# 专栏收录该内容

43 篇文章

订阅专栏

本文介绍了一个用于在DataGridView中自动添加合计行的C#类。该类可以为DataGridView控件设置数据源，并在数据更改时自动更新合计行。此外，还实现了排序功能，确保合计行始终显示在表格底部。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://tech.it168.com/msoft/2008-06-12/200806120637662.shtml

using System; 2using System.Collections.Generic; 3using System.Text; 4using System.Windows.Forms; 5using System.Data; 6using System.Drawing; 7using System.ComponentModel; 8 9namespace OtherTools 10{ 11 class DataGridViewAddSumRow 12 { 13 private DataGridView dgv = null; 14 private DataTable dt = null; 15 public DataGridViewAddSumRow() 16 { 17 } 18 /**//// <summary> 19 /// 设置表格的数据源 20 /// </summary> 21 public DataTable dataTableName 22 { 23 set 24 { 25 this.dt = value; 26 } 27 } 28 /**//// <summary> 29 ///传递表格的名称 30 /// </summary> 31 public DataGridView DgvName 32 { 33 set 34 { 35 dgv = value; 36 } 37 } 38 /**//// <summary> 39 /// 开始添加合计行 40 /// </summary> 41 public void begin() 42 { 43 initDgv(); 44 } 45 private void initDgv() 46 { 47 if (dgv != null) 48 { 49 50 this.dgv.DataSourceChanged += new EventHandler(dataGridView_DataSourceChanged); 51 this.dgv.ColumnHeaderMouseClick += new DataGridViewCellMouseEventHandler(dataGridView_ColumnHeaderMouseClick); 52 this.dgv.CellValueChanged += new DataGridViewCellEventHandler(dataGridView_CellValueChanged); 53 this.dgv.AllowUserToAddRows = false; 54 dgv.DataSource = dt; 55 } 56 } 57 /**//// <summary> 58 /// 计算合计算 59 /// </summary> 60 /// <param name="dgv">要计算的DataGridView</param>

private void SumDataGridView(DataGridView dgv) 62 { 63 if (dgv.DataSource == null) return; 64 //DataTable dt = (DataTable)dgv.DataSource; 65 if (dt.Rows.Count < 1) return; 66 decimal[] tal = new decimal[dt.Columns.Count]; 67 68 DataRow ndr = dt.NewRow(); 69 70 string talc = ""; 71 72 int number = 1; 73 foreach (DataRow dr in dt.Rows) 74 { 75 dr["@xu.Hao"] = number++; 76 int n = 0; 77 foreach (DataColumn dc in dt.Columns) 78 { 79 80 81 if (talc == "" && dc.DataType.Name.ToUpper().IndexOf("STRING") >= 0) 82 { talc = dc.ColumnName; } 83 84 85 if (dc.DataType.IsValueType) 86 { 87 string hej = dr[dc.ColumnName].ToString(); 88 try 89 { 90 if (hej != string.Empty) tal[n] += decimal.Parse(hej); 91 } 92 catch (Exception) { } 93 //if (hej != string.Empty) tal[n] += decimal.Parse(hej); 94 } 95 96 97 n++; 98 } 99 } 100 101 ndr.BeginEdit(); 102 for (int i = 0; i < dt.Columns.Count; i++) 103 { 104 if (tal[i] != 0) 105 ndr[i] = tal[i]; 106 } 107 ndr["@xu.Hao"] = ((int)(dt.Rows.Count + 1)).ToString(); 108 if (talc != "") ndr[talc] = "合计"; 109 ndr.EndEdit(); 110 dt.Rows.Add(ndr); 111 112 dgv.Rows[dgv.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(255, 222, 210); 113 dgv.Rows[dgv.Rows.Count - 1].ReadOnly = true; 114 115 if (dgv.Tag == null) 116 { 117 foreach (DataGridViewColumn dgvc in dgv.Columns) 118 { 119 dgvc.SortMode = DataGridViewColumnSortMode.Programmatic; 120 } 121 } 122 dgv.Tag = ndr; 123 } 124 private void dataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) 125 { 126 DataGridView sortDgv = (DataGridView)sender; 127 int fx = 0; 128 if (sortDgv.AccessibleDescription == null) 129 { 130 fx = 1; 131 } 132 else 133 { 134 fx = int.Parse(sortDgv.AccessibleDescription); 135 fx = (fx == 0 ? 1 : 0); 136 } 137 sortDgv.AccessibleDescription = fx.ToString(); 138 if (sortDgv.Columns[e.ColumnIndex].Name == "@xu.Hao") return; 139 DataGridViewColumn nCol = sortDgv.Columns[e.ColumnIndex]; 140 141 if (nCol.DataPropertyName == string.Empty) return; 142 143 if (nCol != null) 144 { 145 sortDgv.Sort(nCol, fx == 0 ? ListSortDirection.Ascending : ListSortDirection.Descending); 146 147 } 148 //-- 149 DataRow dr = (DataRow)sortDgv.Tag; 150 DataTable dt = (DataTable)sortDgv.DataSource; 151 DataRow ndr = dt.NewRow(); 152 ndr.BeginEdit(); 153 for (int i = 0; i < dt.Columns.Count; i++) 154 { 155 ndr[i] = dr[i]; 156 } 157 dt.Rows.Remove(dr); 158 159 160 //if (e.ColumnIndex != 0) 161 { 162 int n = 1; 163 for (int i = 0; i < sortDgv.Rows.Count; i++) 164 { 165 DataGridViewRow dgRow = sortDgv.Rows[i]; 166 DataRowView drv = (DataRowView)dgRow.DataBoundItem; 167 DataRow tdr = drv.Row; 168 tdr.BeginEdit(); 169 tdr["@xu.Hao"] = n; 170 n++; 171 tdr.EndEdit(); 172 173 } 174 sortDgv.Refresh(); 175 sortDgv.RefreshEdit(); 176 177 } 178 ndr["@xu.Hao"] = ((int)(dt.Rows.Count + 1)).ToString(); 179 ndr.EndEdit(); 180 dt.Rows.Add(ndr); 181 sortDgv.Tag = ndr; 182 183 //-- 184 sortDgv.Sort(sortDgv.Columns["@xu.Hao"], ListSortDirection.Ascending); 185 sortDgv.Columns["@xu.Hao"].HeaderCell.SortGlyphDirection = SortOrder.None; 186 nCol.HeaderCell.SortGlyphDirection = fx == 0 ? SortOrder.Ascending : SortOrder.Descending; 187 sortDgv.Rows[sortDgv.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(255, 255, 210); 188 189 }

190 private void dataGridView_DataSourceChanged(object sender, EventArgs e) 191 { 192 DataGridView dgv = (DataGridView)sender; 193 //DataTable dt = (DataTable)dgv.DataSource; 194 if (dt == null) return; 195 decimal[] tal = new decimal[dt.Columns.Count]; 196 if (dt.Columns.IndexOf("@xu.Hao") < 0) 197 { 198 DataColumn dc = new DataColumn("@xu.Hao", System.Type.GetType("System.Int32")); 199 dt.Columns.Add(dc); 200 dgv.Columns["@xu.Hao"].DisplayIndex = 0; 201 dgv.Columns["@xu.Hao"].HeaderText = "序号"; 202 203 dgv.Columns["@xu.Hao"].SortMode = DataGridViewColumnSortMode.Programmatic; 204 dgv.AutoResizeColumn(dgv.Columns["@xu.Hao"].Index); 205 206 dgv.Columns["@xu.Hao"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; 207 dgv.Columns["@xu.Hao"].Visible = true; 208 } 209 SumDataGridView(dgv); 210 } 211 private void dataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e) 212 { 213 214 DataGridView dgv = (DataGridView)sender; 215 if (dgv.Tag == null || e.RowIndex < 0 || e.RowIndex == dgv.Rows.Count - 1) return; 216 217 string col = dgv.Columns[e.ColumnIndex].DataPropertyName; 218 if (col == string.Empty) return; 219 if (((DataRowView)dgv.Rows[e.RowIndex].DataBoundItem).Row.Table.Columns[col].DataType.IsValueType) 220 { 221 decimal tal = 0; 222 foreach (DataGridViewRow dgvr in dgv.Rows) 223 { 224 if (dgvr.Index != dgv.Rows.Count - 1) 225 { 226 string hej = dgvr.Cells[e.ColumnIndex].Value.ToString(); 227 if (hej != string.Empty) tal += decimal.Parse(hej); 228 } 229 } 230 if (tal == 0) 231 dgv[e.ColumnIndex, dgv.Rows.Count - 1].Value = DBNull.Value; 232 else 233 dgv[e.ColumnIndex, dgv.Rows.Count - 1].Value = tal; 234 } 235 } 236 237 } 238}