how to group employees based on department in GridView using VB.Net

Question

i m using gridview to display employ records from sql server database i want to group data of employees based on there department like a row for each department and followed by the associated employees

AnandM · Accepted Answer

Hi asitmisraPlease refer below articleMerge GridView Cells or Columns in a Row in ASPNet using C VBNet

asitmisra · Answer

Protected Sub OnDataBoundsender As Object e As EventArgs        For i As Integer  EmpdataRowsCount  1 To 1 Step 1            Dim row As GridViewRow  EmpdataRowsi            Dim previousRow As GridViewRow  EmpdataRowsi  1            For j As Integer  0 To rowCellsCount  2                39run this loop for the column which you thing the data will be similar                If DirectCastrowCellsjFindControl34lblDesignation34 LabelText  DirectCastpreviousRowCellsjFindControl34lblDesignation34 LabelText Then                    If previousRowCells2RowSpan  0 Then                        If rowCells2RowSpan  0 Then                            previousRowCells2RowSpan  2                        Else                            previousRowCells2RowSpan  rowCells2RowSpan  1                        End If                        rowCells2Visible  False                    End If                End If

how to group employees based on department in GridView using VB.Net

Company

Explore

Follow us

Contact Us