[Solved] NeedDataSource Format Columns

[Phillip]

<telerik:RadGrid ID="RadGrid1" runat="server"
    OnNeedDataSource="RadGrid1_NeedDataSource" Skin="Default">
    <MasterTableView AutoGenerateColumns="true">
    </MasterTableView>
</telerik:RadGrid>

Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs)
     Dim dt As DataTable
     If Session("dt") Is Nothing Then
         dt = New DataTable()
         dt.Columns.Add("money")
         For i As Integer = 1 To 10
             dt.Rows.Add(i)
         Next
         Session("dt") = dt
     Else
         dt = TryCast(Session("dt"), DataTable)
     End If
     RadGrid1.DataSource = dt
 End Sub

How do I format the money column to US currency or any of other formats available in radgrid?  Thanks

[Princy]

Hello Philip,

The following code snippet shows how to change the format of AutoGenerated columns in RadGrid.

VB.Net

Protected Sub RadGrid1_ColumnCreated(sender As Object, e As GridColumnCreatedEventArgs)
    If e.Column.UniqueName = "money" Then
        Dim boundColumn As GridBoundColumn = TryCast(e.Column, GridBoundColumn)
        boundColumn.DataFormatString = "{0:c}"
    End If
End Sub

Thanks,
Princy.