VB.NetControls

ASP.Net - Gridview - Dynamic Columns

GridView – Dynamic columns

Sample code

1
2
3
4
BoundField test = new BoundField();
test.DataField = "New DATAfield Name";
test.Headertext = "New Header";
CustomersGridView.Columns.Add(test);c

Here is the UI

1
2
3
4
5
6
7
8
<asp:gridview id="gridViewList" 
    autogeneratecolumns="false"
    emptydatatext="No data available." 
    runat="server">
     <columns>

     </columns>
</asp:gridview>

Here is the complete code

1
2
3
4
5
6
7
8
9
10
11
Dim ds As DataSet _
    = si.DB.DsGet(sql, "aspxConnectionString")

For Each aCol As DataColumn In ds.Tables(0).Columns
    Dim gridCol As BoundField = New BoundField()
    gridCol.DataField = aCol.ColumnName
    gridCol.HeaderText = aCol.Caption
    gridViewList.Columns.Add(gridCol)
Next
gridViewList.DataSource = ds
gridViewList.DataBind()

Reference