Dynamically set ASP.Net GridView header cell name at runtime using C# and VB.Net

Hi makumbisulaiman58,

Refer below code.

Loop through the column names and set column Name as GridView Header cell Text.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
    Me.BindGrid()
    Dim columnNames As List(Of String) = Me.GetColumnName()
        ' Looping through the columnNames.
        For i As Integer = 0 To columnNames.Count - 1
            ' Setting columnNames as GridView Header cell Text.
            gvCustomers.HeaderRow.Cells(i).Text = columnNames(i)
        Next i
    End If
End Sub
Private Sub BindGrid()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
       Using cmd As SqlCommand = New SqlCommand("SELECT Name, Country FROM Customers", con)
            Using sda As SqlDataAdapter = New SqlDataAdapter(cmd)
                Using dt As DataTable = New DataTable()
                    sda.Fill(dt)
                    gvCustomers.DataSource = dt
                    gvCustomers.DataBind()
                End Using
            End Using
        End Using
    End Using
End Sub

Private Function GetColumnName() As List(Of String)
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim columnNames As List(Of String) = New List(Of String)()
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand("SELECT Location FROM ColumnNames", con)
            con.Open()
            Using sdr As SqlDataReader = cmd.ExecuteReader()
               While sdr.Read()
                   columnNames.Add(sdr("Location").ToString())
               End While
            End Using
            con.Close()
        End Using
    End Using
    Return columnNames
End Function