[Solved] Creating a currency column

[Hilda Kenny]

Hi, i have a value e.g.  23.0000   how do make this a euro value such as €23.00    ?   thanks for any help.

[Richard Slade]

Hello,

Your column needs to be a decimal column and you can then format that column as currency.
For exmaple.

Me.RadGridView1.Columns.Add(New GridViewDecimalColumn("Currency"))
Me.RadGridView1.Columns(0).FormatString = "{0:C}"

hope that helps
Richard

[Hilda Kenny]

Hi, thanks for the response. I added it in the property designer but the € sign doesn't come up, an unrecognizable symbol appears instead. I have attached a screenshot.  thanks.

[Richard Slade]

Hello,

there is no screenshot. Please can you attach
thanks
richard

[Richard Slade]

Hello,

This will format your column with a Euro symbol.

Imports Telerik.WinControls
Imports Telerik.WinControls.UI
Imports System.Globalization

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Me.RadGridView1.Columns.Add(New GridViewDecimalColumn("Currency"))

        Dim rowInfo As GridViewRowInfo = Me.RadGridView1.Rows.AddNew()
        rowInfo.Cells(0).Value = "2.32"
        rowInfo = Me.RadGridView1.Rows.AddNew()
        rowInfo.Cells(0).Value = "4.36"

    End Sub

    Private Sub RadGridView1_CellFormatting(ByVal sender As System.Object, _
        ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles RadGridView1.CellFormatting

        If e.Column.Name = "Currency" Then
            e.CellElement.Text = String.Format(New CultureInfo("fr-FR"), "{0:C}", e.CellElement.Value)
        End If
    End Sub
End Class

Hope this helps
Richard

[Hilda Kenny]

Thanks I'll give it a go

[Richard Slade]

Ok, great. Let me know how you get on and if you find this is a solution for you, please remember to mark as answer so others can find the answer too.

All the best
Richard

[Hilda Kenny]

It worked thank you very much