本文主要講述如何給Dev ASPxGridView后臺增加列，希望對大家有幫助。

public void BindRecordList()

{

    String sqlAll=”select ID,”;

     if (ASPxGridView1.Columns.Count == 0)

            {

                //手動綁定數(shù)據(jù)

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

dl.Caption = "顯示出來的頭部";

               dl.FieldName = "AgentId";

                gvRecordList.Columns.Add(dl);

                //從數(shù)據(jù)庫中取的要綁定的列名與描述

                DataTable dsWidth = gd.getGradeReg();

                String Sqlcolumn=””;

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

                 {

 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();

           &nbsp;        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

       &nbsp;    {//取得完整的sql語句

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

                dsRecord = SQLHelper.Query(sqlAll);

          &nbsp;     //綁定數(shù)據(jù)源

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

          &nbsp;&nbsp;    ASPxGridView1.DataBind();

 ;      ;     }

            catch

&nbsp;           {

  &nbsp;             throw;

  &nbsp;  &nbsp;      }

        }

GridView在后臺動態(tài)綁定列或者增加列的語句為：

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);

    ;        }