datagridview 合计_datagridview和textbox_vb.net datagridview

datagridview 合计datagridview 合计

DataTable dt= DBUtility.DB.FromSql(sql).ToDataTable();

DataGridViewAddSumRow sumRow = new DataGridViewAddSumRow();

sumRow.Xh_field = "xuhao";

sumRow.DgvName = this.dataGridView1;

sumRow.dataTableName = dt;

sumRow.begin();

*/

using System;

using System.Collections.Generic;

using System.Text;

using System.Windows.Forms;

using System.Data;

using System.Drawing;

using System.ComponentModel;

namespace YL.Code

{

public class DataGridViewAddSumRow

{

private DataGridView dgv = null;

private DataTable dt = null;

private string xh_field = "";

public string Xh_field

{

get { return xh_field; }

set { xh_field = value; }

}

public DataGridViewAddSumRow()

{

}

/// <summary>

/// 设置表格的数据源

/// </summary>

public DataTable dataTableName

{

set

{

this.dt = value;

}

}

/// <summary>

///传递表格的名称

/// </summary>

public DataGridView DgvName

{

set

{

dgv = value;

}

}

/// <summary>

/// 开始添加合计行

/// </summary>

public void begin()

{

initDgv();

}

private void initDgv()

{

if (dgv != null)

{

this.dgv.DataSourceChanged += new EventHandler(dataGridView_DataSourceChanged);

this.dgv.ColumnHeaderMouseClick += new DataGridViewCellMouseEventHandler(dataGridView_ColumnHeaderMouseClick);

this.dgv.CellValueChanged += new DataGridViewCellEventHandler(dataGridView_CellValueChanged);

this.dgv.AllowUserToAddRows = false;

dgv.DataSource = dt;

}

}

/// <summary>

/// 计算合计算

/// </summary>

/// <param>要计算的DataGridView</param>

private void SumDataGridView(DataGridView dgv)

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