How to get array from column header With LINQ

Question

hi

I want to get an array of the column header after changing the column display index

  dgv.AllowUserToOrderColumns = True

Answer 1

Hi @Mansour_Dalir ,

You can refer to this link to the solution in C#, below is the code in the VB.net.

Private Sub dgv_ColumnDisplayIndexChanged(sender As Object, e As DataGridViewColumnEventArgs) Handles dgv.ColumnDisplayIndexChanged
        Dim g As DataGridView = DirectCast(sender, DataGridView)
        Dim propertyInfo As Reflection.PropertyInfo = GetType(DataGridViewColumn).GetProperty("DisplayIndexHasChanged", Reflection.BindingFlags.NonPublic Or Reflection.BindingFlags.Instance)

        If g.Columns.Cast(Of DataGridViewColumn)().Any(Function(x) DirectCast(propertyInfo.GetValue(x), Boolean)) Then
            Return
        Else
            Dim columnTitlesArray() As String = dgv.Columns.Cast(Of DataGridViewColumn)() _
                                           .OrderBy(Function(column) column.DisplayIndex) _
                                           .Select(Function(column) column.HeaderText) _
                                           .ToArray()
            For Each columnTitle As String In columnTitlesArray
                Console.WriteLine(columnTitle)
            Next
        End If
End Sub 

Answer 2

In some circumstances, this should work:

Dim columns As DataGridViewColumn() = dgv.Columns.OfType(Of DataGridViewColumn).OrderBy(Function(c) c.DisplayIndex).ToArray()

Answer 3

Hi @Mansour_Dalir ,

The following code gets an array of column headers every time the column order changes.

Private Sub dgv_ColumnDisplayIndexChanged(sender As Object, e As DataGridViewColumnEventArgs) Handles dgv.ColumnDisplayIndexChanged
            Dim columnTitlesArray() As String = dgv.Columns.Cast(Of DataGridViewColumn)() _
                                           .OrderBy(Function(column) column.DisplayIndex) _
                                           .Select(Function(column) column.HeaderText) _
                                           .ToArray()
End Sub

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.