彩票走势图

　　本文主要讲述如何给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;          &nbsp;    //绑定列的描述

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

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

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

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

                    ASPxGridView1.Columns.Add(datacolumn);

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

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

                 }

  &nbsp;         }

&nbsp;           DataSet dsRecord = null;

     &nbsp;      try

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

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

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

          ;     ; //绑定数据源

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

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

         &nbsp;   }

  &nbsp;  &nbsp;      catch

         &nbsp;  {

          &nbsp;&nbsp;    throw;

     &nbsp;      }

        }

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

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

      ;    &nbsp; {

                BoundField bf = new BoundField();

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

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

&nbsp;               GridView1.Columns.Insert(i, bf);

            }