FormatString RadGridView

[Zerka]

Hi,

I am using RadGridView.  I need to format the column values, so it can display the values with no decimal points. And if the value of the column is 0 then it displays nothing. Can you please help me that what should be the value of FormatString property.

And also how can I format the values of SummaryRowBottom.

Any help would be appreciated.

Regards!

[Richard Slade]

Hello,

To add a summary row, please consider the following code

Dim summary As New GridViewSummaryRowItem()
summary.Add(New GridViewSummaryItem("ColumnName", "{0} is the total of ColumnName", GridAggregateFunction.Sum))
Me.RadGridView1.SummaryRowsBottom.Add(summary)

With formatting values in the way that you want, you need to consider if you are going to be using In grid editing. If not, then it is simply a case of defining a GridViewDecimalColumn and formatting the cells

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

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

Use CellFormatting event

Private Sub RadGridView1_CellFormatting(ByVal sender As System.Object, _
    ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles RadGridView1.CellFormatting
    If TypeOf e.CellElement.RowElement.RowInfo Is GridViewDataRowInfo Then
        If e.CellElement.RowElement.RowInfo.Cells("myValue").Value IsNot Nothing Then
            If e.CellElement.ColumnIndex = Me.RadGridView1.Columns("MyValue").Index Then
                e.CellElement.Value = e.CellElement.Value.ToString().Replace(".", "")
                If e.CellElement.Value.ToString() = "0" Then e.CellElement.Visibility = ElementVisibility.Hidden
            End If
        End If
    End If
End Sub

However, if you are using In grid editing, then the editor will now assume that 2.31 is 231.00. If you are not using this feature, then this shouldn't be an issue.

Let me know if you have further questions
Richard

[Zerka]

Hi

Thank you very much for your help. Actually I solved my problem in this way:

Format String for the column.

 

grdColumnDecimal.DecimalPlaces = 0;

grdColumnDecimal.DataEditFormatString = "{0:N0}";

grdColumnDecimal.FormatString = "{0:###,###}";

Format String for SummaryRowButton

GridViewSummaryRowItem item1 = new GridViewSummaryRowItem();

item1.Add(new GridViewSummaryItem("Total", "{0:###,###}",GridAggregateFunction.Sum));

grdRamme.SummaryRowsBottom.Add(item1);

Regards

 

[Richard Slade]

Hello Michael,

I'm glad you've solved your issue. Actually, I think your way is preferable.
Best regards,
Richard