0

How to change the DataTable format to "N2" and Show in DataGridView in vb.net?. I want to change the format of the DataTable without going through the DataGridView format and displaying in the DataGridView. Please recommend the best solution. I tried but the result is still in the datagridview has not changed.

Thanks

Private Sub ImprovedCode()
    Dim dt As New DataTable("tbl")
    Dim dtColumn As New DataColumn With {.DataType = GetType(DateOnly), .ColumnName = "CreatedDate"}
    dt.Columns.Add(dtColumn)
    Dim dtColumn2 As New DataColumn With {.DataType = GetType(Double), .ColumnName = "Price"}
    dt.Columns.Add(dtColumn2)
    Dim dr As DataRow = dt.NewRow()
    dr(dtColumn) = DateOnly.FromDateTime(Date.Now)
    dr(dtColumn2) = 120000
    Dim dr1 As DataRow = dt.NewRow()
    dr1(dtColumn) = DateOnly.FromDateTime(Date.Now)
    dr1(dtColumn2) = 130000
    dt.Rows.Add(dr)
    dt.Rows.Add(dr1)
    DataGridView1.DataSource = dt
End Sub

RESULT DATAGRIDVIEW

RESULT DATAGRIDVIEW

DESIRED RESULT DATAGRIDVIEW

DESIRED RESULT DATAGRIDVIEW

Svyatoslav Danyliv
  • 21,911
  • 3
  • 16
  • 32
roy
  • 693
  • 2
  • 11

0 Answers0