radgrid DataFormatString String Value To Decimal

[nitesh monga]

Hi There, I need a litle help with GridBoundColumn DataFormateString Property. I have boundcolumn which shows the values like:

0
1.0
1.88
3.0

The values should appear like:

0.00
1.00
1.88
3.00

 

Is there any easy way that can be used with GridBoundColumns to get the above results. any example will be a gr8 help :).

Thanks & Regards
Nitesh Monga

[Shinu]

Hi Nitesh,

Try setting the DataFormatString of the GridBoundColumn as shown below.

ASPX:

 <telerik:GridBoundColumn  DataType="System.Int32"  DataField="Sum" DataFormatString="{0:F2}"  HeaderText="Sum" SortExpression="Sum" UniqueName="Sum">
                        </telerik:GridBoundColumn>

Thanks
Shinu

[nitesh monga]

Dear Shinu thanks allot for your response i tried that but it didn't worked for me, i found a other way around for this problem. below is the approach i used to fix my problem.

Private Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
        If TypeOf e.Item Is GridDataItem Then

Dim dblVal As String
            dblVal = TryCast(dataItem("sumHrs"), TableCell).Text
            TryCast(dataItem("sumHrs"), TableCell).Text = fixZero(dblVal)
            End If
    End Sub
    Function fixZero(ByVal val As String) As String
        Dim dVal As Decimal
        val = val.Replace(" ", "")
        If val <> "" Then
            dVal = val
        Else
            dVal = 0
        End If
        Dim dc As String
        dc = dVal.Round(dVal, 2).ToString
        If dc.IndexOf(".") <= 0 Then
            dc = dc + ".00"
        Else
            Dim index As Integer
            Dim dec As String
            index = dc.LastIndexOf(".")
            dec = dc.Substring(index)
            If dec.Length = 2 Then
                dc = dc + "0"
            End If
        End If
        val = dc
        Return val
    End Function