如何给Dev ASPxGridView后台增加列

转帖|其它|编辑:郝浩|2011-04-01 13:22:57.000|阅读 2092 次

概述:本文主要讲述如何给Dev ASPxGridView后台增加列,希望对大家有帮助。

# 界面/图表报表/文档/IDE等千款热门软控件火热销售中 >>

  本文主要讲述如何给Dev ASPxGridView后台增加列,希望对大家有帮助。

public void BindRecordList()

{

    String sqlAll=”select ID,”;

     if (ASPxGridView1.Columns.Count == 0)

            {

                //手动绑定数据

  DevExpress.Web.ASPxGridView.GridViewDataTextColumn dl = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();

dl.Caption = "显示出来的头部";

               dl.FieldName = "AgentId";

                gvRecordList.Columns.Add(dl);

                //从数据库中取的要绑定的列名与描述

                DataTable dsWidth = gd.getGradeReg();

                String Sqlcolumn=””;

                for (int i = 0; i < dsWidth.Rows.Count; i++)

                {

 DevExpress.Web.ASPxGridView.GridViewDataTextColumn datacolumn = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();

                    //绑定列的描述

                    datacolumn.Caption = dsWidth.Rows[i]["GrShow"].ToString();

                    //绑定列的字段

                    datacolumn.FieldName = dsWidth.Rows[i]["GrName"].ToString().Trim();

                    datacolumn.UnboundType = DevExpress.Data.UnboundColumnType.Bound;

                    ASPxGridView1.Columns.Add(datacolumn);

                    //取得sql语句中的字段

                    Sqlcolumn+=” , “+ dsWidth.Rows[i]["GrName"].ToString().Trim()

                }

            }

            DataSet dsRecord = null;

            try

            {//取得完整的sql语句

                sqlAll += ColonmFileds + " from Recording " + sqlQuery();

                dsRecord = SQLHelper.Query(sqlAll);

                //绑定数据源

                ASPxGridView1.DataSource = dsRecord.Tables[0].DefaultView;

                ASPxGridView1.DataBind();

            }

            catch

            {

                throw;

            }

        }

GridView在后台动态绑定列或者增加列的语句为:

for (int i = 0; i < dsWidth.Rows.Count; i++)

            {

                BoundField bf = new BoundField();

                bf.DataField = dsWidth.Rows[i]["GrName"].ToString().Trim();//字段名

                bf.HeaderText = dsWidth.Rows[i]["GrShow"].ToString();//列名

                GridView1.Columns.Insert(i, bf);

            }


标签:

本站文章除注明转载外,均为本站原创或翻译。欢迎任何形式的转载,但请务必注明出处、不得修改原文相关链接,如果存在内容上的异议请邮件反馈至chenjj@evget.com

文章转载自:网络转载

为你推荐

  • 推荐视频
  • 推荐活动
  • 推荐产品
  • 推荐文章
  • 慧都慧问
扫码咨询


添加微信 立即咨询

电话咨询

客服热线
023-68661681

TOP