I am trying to import from a DGV to a list view and have a column or 2 formatted as currency...
My current code is
Code:
            If m_row.Cells("clmItem").Value IsNot Nothing Then
                Dim item As String = m_row.Cells("clmItem").Value.ToString
                Dim brand As String = m_row.Cells("clmBrand").Value.ToString
                Dim section As String = m_row.Cells("clmSection").Value.ToString
                Dim size As String = m_row.Cells("clmQTY").Value.ToString
                Dim store As String = m_row.Cells("clmStore").Value.ToString
                Dim price As String = m_row.Cells("clmPrice").Value.ToString("{0:C}")
                Dim coupon As String = m_row.Cells("clmCoupon").Value.ToString("{0:C}")
                Dim lvItem As New ListViewItem(New String() {item, brand, section, size, store, price, coupon})

                PriceMatchStore.Shopping_List.Items.Add(lvItem)
                PriceMatchStore.Shopping_List.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent)
                PriceMatchStore.Shopping_List.AutoResizeColumn(3, ColumnHeaderAutoResizeStyle.HeaderSize)
                'PriceMatchStore.Shopping_List.AutoResizeColumn(5, ColumnHeaderAutoResizeStyle.HeaderSize)
            End If
so the Value.ToString("{0:C}") is not working.....
Also i need to delete the cells that end up showing 0 from these 2 columns but I havent figured out how to do that either. Any help would be appreciated.