怎么样给grideview中的某一列求和

[gylc168]

grideview从数据库读取数据，行数是不固定的，我求某一列的和，比如这一列是“Menoy”，该怎么做呢？
另外我想找到grideview中的某个特定的单元格，比如从左到右，从上到下，最后一列与最后一行的交叉的那个单元格，该怎么做呢？

[小_虎]

我以前发过一个帖子。你可以看下：

http://topic.csdn.net/u/20090909/22/40ba837f-b68c-4e3f-aa2e-3a5ddf9c5fd9.html

[cpp2017]

１.可以用sql做sum
2. 可以用DataTable的compute计算. Object o = dt.Compute("SUM(字段)","");

3. 循环各个gridviewrow，累加计算

[gylc168]

[Quote=引用 2 楼 cpp2017 的回复:]
１.可以用sql做sum
2. 可以用DataTable的compute计算. Object o = dt.Compute("SUM(字段)","");

3. 循环各个gridviewrow，累加计算
[/Quote]

能具体一点吗？

[cpp2017]

１。Object o = dt.Compute("SUM(字段)","");
2. GridView1.Rows[n].Cells[n]

[yao991118]

http://wukai520.520.blog.163.com/blog/static/112302290200931511133413/

[小_虎]

1楼这么好的例子这么不看下呢。

[边城的刀声]

    /// <summary>
    /// 数据源为DataTable的GridView列汇总器
    /// </summary>
    public class GridViewTotaller
    {
        #region Variables
        private GridView gridView;
        public string DispHTMLFormat = "{0}";

        #endregion

        #region Constructor
        public GridViewTotaller(GridView gridView)
        {
            this.gridView = gridView;
        }
        #endregion

        /// <summary>
        /// 汇总Grid某一列的数据
        /// </summary>
        /// <param name="totalFld">要统计的列名</param>
        /// <param name="cellIndex">要统计列的index</param>
        /// <param name="format">格式,默认值为空</param>
        public void Total<T>(String totalFld, Int32 cellIndex, String format) where T : struct, IFormattable
        {
            DataTable dt = (DataTable)gridView.DataSource;
            if (dt.Rows.Count <= 0) return;
            Object oValue = dt.Compute(String.Format("sum({0})", totalFld), "");
            T value = (T)(oValue == DBNull.Value ? 0 : Convert.ChangeType(oValue, typeof(T)));
            gridView.ShowFooter = true;
            gridView.FooterRow.HorizontalAlign = HorizontalAlign.Right;
            gridView.FooterRow.Cells[cellIndex].Text += String.Format(DispHTMLFormat, String.Format("{0}", value.ToString(format, null)));
        }

        public void Total<T>(String totalFld, Int32 cellIndex) where T : struct, IFormattable
        {
            Total<T>(totalFld, cellIndex, null);
        }

        /// <summary>
        /// 汇总Grid某一列的数据
        /// </summary>
        /// <param name="grd">gridView</param>
        /// <param name="totalFld">要汇总的字段</param>
        /// <param name="cellIndex">要显示的单元格索引</param>
        public static void TotalInfo(GridView grd, String totalFld, Int32 cellIndex)
        {
            GridViewTotaller totaller = new GridViewTotaller(grd);
            totaller.Total<Decimal>(totalFld, cellIndex, "N2");
        }
    }

[itnodezhangbing]

不好意思，打错字了。

[a12321321321312321]

[Quote=引用 6 楼 jxyxhz 的回复:]
1楼这么好的例子这么不看下呢。
[/Quote]
顶

[gylc168]

[Quote=引用 4 楼 cpp2017 的回复:]
１。Object o = dt.Compute("SUM(字段)","");
2. GridView1.Rows[n].Cells[n]
[/Quote]

关键是行数不固定啊，你这N没用的

[cpp2017]

Rows.Count-1


Rows[0].Cells.Count-1

[cpp2017]

不能动下脑筋么？

[laomengzi]

学习！