靠谱朗驰娱乐体育

　　本文主要讲述如何给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=””;

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

&nbsp;               {

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

          &nbsp;         //绑定列的描述

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

 &nbsp;               &nbsp;  //绑定列的字段

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

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

              ;      ASPxGridView1.Columns.Add(datacolumn);

          &nbsp;     ;    //取得sql语句中的字段

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

 &nbsp;       ;       }

       &nbsp; &nbsp;  }

         &nbsp;  DataSet dsRecord = null;

      &nbsp;     try

            {//取得完整的sql语句

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

             &nbsp;  dsRecord = SQLHelper.Query(sqlAll);

            &nbsp;    //绑定数据源

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

                ASPxGridView1.DataBind();

 ;  &nbsp;        }

            catch

      &nbsp;     {

                throw;

            }

        }

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

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

      &nbsp;     {

  &nbsp;        &nbsp;    BoundField bf = new BoundField();

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

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

                GridView1.Columns.Insert(i, bf);

  ;        ;  }