GridView绑定固定行列的空数据以及加入页尾

最新推荐文章于 2023-02-14 11:18:43 发布

zjh_1451312

最新推荐文章于 2023-02-14 11:18:43 发布

阅读量596

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 文章标签： textbox string null object c

本文链接：https://blog.youkuaiyun.com/zjh_1451312/article/details/6121736

C# 专栏收录该内容

8 篇文章

订阅专栏

本文介绍如何在GridView中绑定具有固定行数和列数的空数据，并展示了如何添加页脚。通过创建DataTable并填充数据，然后将数据源绑定到GridView，实现了表格的初始化。同时，在RowDataBound事件中，对页脚单元格进行操作，显示总计。通过对TextBox控件的检查和转换，计算特定列的总和。

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

public void BindNullGV(GridView gv,int rcount,int ccount)
    {
        DataTable dt = new DataTable("test");
        for (int j = 0; j < ccount; j++)
        {
            string cname = "C" + j.ToString();
            DataColumn col = new DataColumn(cname, typeof(decimal));
            dt.Columns.Add(col);
        }
        DataRow row;
        for (int i = 0; i < rcount; i++)
        {
            row = dt.NewRow();
            for (int c = 0; c < ccount; c++)
            {
                row[c] = c + 1;
            }
            dt.Rows.Add(row);
        }
        gv.DataSource = dt;
        gv.DataBind();
    }

protected void gvInfor_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[6].Text = "Total:";
            e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[7].Text = rsn.ReturnTotal(7, gvInfor, "1").ToString();
            e.Row.Cells[9].Text = rsn.ReturnTotal(9, gvInfor, "1").ToString();
        }
    }

public decimal ReturnTotal(int col, GridView gv,string status)
    {
        decimal char_total = 0;
        string strqty = null;
        int textid = 0;
        foreach (GridViewRow gvr in gv.Rows)
        {
            if (status == "1")
            {
                textid = col + 1;
                if (null != ((TextBox)gvr.Cells[col].FindControl("TextBox" + "" + textid.ToString() + "")).Text.Trim())
                {
                    if ("" == ((TextBox)gvr.Cells[col].FindControl("TextBox" + "" + textid.ToString() + "")).Text.Trim())
                    {
                        strqty = "0";
                    }
                    else
                    {
                        strqty = ((TextBox)gvr.Cells[col].FindControl("TextBox" + "" + textid.ToString() + "")).Text.Trim();
                    }
                    char_total += Convert.ToDecimal(strqty);

                }
            }
            else
            {
                if (null != gvr.Cells[col].Text.ToString())
                {
                    if ("" == gvr.Cells[col].Text.Trim())
                    {
                        strqty = "0";
                    }
                    else
                    {
                        strqty = gvr.Cells[col].Text.Trim();
                    }
                    char_total += Convert.ToDecimal(strqty);

                }
            }
        }

return char_total;

}