Dev 之ASPxGridView后台动态创建超链接以及读取动态字段

  //链接字符串
            string ConStr = "server=10.0.0.1;user id=sa;pwd=;database=db_test";
            //链接
            SqlConnection con = new SqlConnection(ConStr);
            //SQL语句
            string SqlStr = "select * from Class ";
            //适配器
            SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con);
            //实例化DataSet或者DataTable
            // DataSet ds = new DataSet();
            DataTable dsWidth = new DataTable();
            //把执行结果添加到DataSet或者DataTable中
            ada.Fill(dsWidth);
            如需显示在界面上,则给控件赋值.否则执行结束
            ASPxGridView1.DataSource = dsWidth;
            ASPxGridView1.DataBind();

 

            //绑定列的描述
            string name = "";
            //循环出表中所有字段名
            for (int j = 0; j < dsWidth.Columns.Count ; j++)
            {
                后台增加列
                //DevExpress.Web.ASPxGridView.GridViewDataTextColumn datacolumn = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();

                获取字段名
                //name = dsWidth.Columns[j].ColumnName;
                绑定列的字段
                //datacolumn.Caption = name;
                绑定列的字段
                //datacolumn.FieldName = name;

                //datacolumn.UnboundType = DevExpress.Data.UnboundColumnType.Bound;
                //ASPxGridView1.Columns.Add(datacolumn);

 

                //后台增加列 并增加超链接
                GridViewDataHyperLinkColumn colLink = new GridViewDataHyperLinkColumn();
                colLink.Caption = name;
                colLink.FieldName = name;      //Column parameter, "Id" is URL link ("<a href="3">Edit</a> ")
                colLink.PropertiesHyperLinkEdit.Text = name;      // Display text
                colLink.PropertiesHyperLinkEdit.TextField = name;   //Display content of column "Content", alternative to PropertiesHyperLinkEdit.Text
                colLink.PropertiesHyperLinkEdit.NavigateUrlFormatString = "/Default.aspx?={0}";   //The URL is replaced {0} to "Id" to especific Row ("/Default.aspx?=3")
                colLink.Visible = true;
                colLink.Width = 50;
                ASPxGridView1.Columns.Add(colLink);      //Add column to ASPxGrid

 

===============================  下面是只显示动态绑定的写法

 

     //链接字符串
            string ConStr = "server=10.72.5.6;user id=sa;pwd=zxm10;database=db_test";
            //链接
            SqlConnection con = new SqlConnection(ConStr);
            //SQL语句
            string SqlStr = "select * from Class ";
            //适配器
            SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con);
            //实例化DataSet或者DataTable
            // DataSet ds = new DataSet();
            DataTable dsWidth = new DataTable();
            //把执行结果添加到DataSet或者DataTable中
            ada.Fill(dsWidth);
          

 

            //绑定列的描述
            string name = "";
            //循环出表中所有字段名
            for (int j = 0; j < dsWidth.Columns.Count ; j++)
            {
               
                //获取字段名
                name = dsWidth.Columns[j].ColumnName;
                //后台增加列 并增加超链接
                GridViewDataHyperLinkColumn colLink = new GridViewDataHyperLinkColumn();
                colLink.Caption = name;
                colLink.FieldName = name;      //Column parameter, "Id" is URL link ("<a href="3">Edit</a> ")
                colLink.PropertiesHyperLinkEdit.Text = name;      // Display text
                colLink.PropertiesHyperLinkEdit.TextField = name;   //Display content of column "Content", alternative to PropertiesHyperLinkEdit.Text
                colLink.PropertiesHyperLinkEdit.NavigateUrlFormatString = "../UISite/SiteMonitor.aspx?id=";   //The URL is replaced {0} to "Id" to especific Row ("/Default.aspx?=3")
                colLink.Visible = true;
                colLink.Width = 50;
                ASPxGridView1.Columns.Add(colLink);      //Add column to ASPxGrid

            }

            //绑定
            ASPxGridView1.DataSource = dsWidth;
            ASPxGridView1.DataBind();