Dynamic columns remove groupseparator

[Vishal]

Hi All,

I have created grid with Auto Generate Columns at runtime and have problem in edit mode. We have column with integer value and dont want to display "," while in edit mode.

Read              Edit mode
100001 ----> 100,001

Is there any way that I can set all columns to textbox with no numeric settings? Basically I want to display text in RadTextBox and not RadNumericTextBox.

FYI, I am developing in ASP.Net and VB.Net.

Thanks, Vishal

[Shinu]

Hi Vishal,

When you set the AutoGenerateColumns property of RadGrid to true, the RadGrid control generates a separate column for each data field in the control's assigned datasource.
Based on the datatype of the field, the control will generate:
-GridBoundColumn for string fields
-GridCheckBoxColumn for boolean fields
-GridDateTimeColumn for datetime fields
-GridNumericColumn for numeric fields
    Hence for numeric fields, it will have a RadNumericTextBox in edit mode.
In order to avoid the Group Separator, you can try the following code snippet.

VB:

Protected Sub RadGrid1_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
If TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode Then
        Dim edit As GridEditableItem = DirectCast(e.Item, GridEditableItem)
        Dim rnumtxtColumn As RadNumericTextBox = DirectCast(edit("DataFieldName").Controls(0), RadNumericTextBox)
        rnumtxtColumn.NumberFormat.GroupSeparator = ""
    End If
End Sub

Thanks,
Shinu