Datagridview Cell Style | datagridview formatting code vb.net

This post is about the code to format Datagridview Cell Style. which is given in Visual Basic language.

datagridview formatting

To format datagridview cell style, we have to apply code about each column through code. After which the gridview comes back as per our requirement. The code is given below, you can use it by changing it as per your requirement.

Datagridview Cell Style Code

        Try
            If DgvFilterCashierNm.RowCount > 0 Then
                With DgvFilterCashierNm
                    'id
                    .Columns(0).Width = 80
                    .Columns(0).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft
                    .Columns(0).SortMode = DataGridViewColumnSortMode.NotSortable
                    'counting date
                    .Columns(1).Width = 100
                    .Columns(1).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
                    .Columns(1).SortMode = DataGridViewColumnSortMode.NotSortable
                    'counting time
                    .Columns(2).Width = 80
                    .Columns(2).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
                    .Columns(2).SortMode = DataGridViewColumnSortMode.NotSortable
                    .Columns(2).DefaultCellStyle.Format = "H:mm:ss"
                    'cashier name
                    .Columns(3).Width = 150
                    .Columns(3).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft
                    .Columns(3).SortMode = DataGridViewColumnSortMode.NotSortable
                    'counter number
                    .Columns(4).Width = 20
                    .Columns(4).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
                    .Columns(4).SortMode = DataGridViewColumnSortMode.NotSortable
                    'subtotal amounts OMR
                    .Columns(5).Width = 120
                    .Columns(5).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
                    .Columns(5).SortMode = DataGridViewColumnSortMode.NotSortable
                    .Columns(5).DefaultCellStyle.Format = "0.000"
                    ' 'subtotal amounts AED
                    .Columns(6).Width = 120
                    .Columns(6).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
                    .Columns(6).SortMode = DataGridViewColumnSortMode.NotSortable
                    .Columns(6).DefaultCellStyle.Format = "0.00"
                End With
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

Conclusion

In this post the code for designing the cells of DataGridView is explained. Click if you want to add or remove items in the datagridview or comment if you have any questions.