更好的代码来显示总列的页脚总和? [英] better code to display total sum in footer for perticular column?

问题描述

hi正在使用c#语言在asp.net中使用Windows窗体..

这是我显示网格的代码，但我想显示购买"，销售"和利润"列的总和

hi am using windows forms in asp.net using c# language..

this is my code to display grid but i want to show total sum for Purchase ,sales and Profit column

private void ExpressMoney_Load(object sender, EventArgs e)
       {
           btnDelete.Enabled = false;
           btnUpdate.Enabled = false;

           con.Open();
           da = new SqlDataAdapter("select * from tblExpressMoney where emDelStatus=''0''", con);
           SqlCommandBuilder builder = new SqlCommandBuilder(da);
           ds = new DataSet();
           da.Fill(ds, "tblExpressMoney");

           dataGridView1.DataSource = ds.Tables["tblExpressMoney"];

           dataGridView1.Columns["emID"].HeaderText = "ID";
           dataGridView1.Columns["emNameOfCustomer"].HeaderText = "Name";
           dataGridView1.Columns["emCustomerNo"].HeaderText = "Mobile";
           dataGridView1.Columns["emTransactionNo"].HeaderText = "Transaction No";
           dataGridView1.Columns["emAmtOfTransaction"].HeaderText = "Purchase";
           dataGridView1.Columns["emTransfererAmtPaid"].HeaderText = "Sale";
           dataGridView1.Columns["emAmountOfProfit"].HeaderText = "Profit";
           dataGridView1.Columns["emDate"].HeaderText = "Date";
       }

请建议我如何在表格中显示页脚以及如何显示总金额?
例如
文件->新建->项目-> VisualC#-> Windows窗体应用程序
感谢

please suggest me how to display footer in grid and how to display total sum?
for example
File->New->Project->VisualC#->Windows Forms Application
thanks

推荐答案

检查以下链接

ASP.NET
http://www.ezzylearning.com/tutorial.aspx?tid=1676759 [ ^ ]
http://www.aspdotnet-suresh. com/2011/02/how-to-display-sum-of-columns-total-in.html [ http://csharpdotnetfreak.blogspot.com/2009/07/display-total- in-gridview-footer.html [ ^ ]

Windows窗体
摘要DataGridView [

check below links

ASP.NET
http://www.ezzylearning.com/tutorial.aspx?tid=1676759[^]
http://www.aspdotnet-suresh.com/2011/02/how-to-display-sum-of-columns-total-in.html[^]
http://csharpdotnetfreak.blogspot.com/2009/07/display-total-in-gridview-footer.html[^]

Windows Forms
Summary DataGridView[^]

这篇关于更好的代码来显示总列的页脚总和?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！