GridViewDecimalColumn allows decimal data to be displayed and edited. GridViewDecimalColumn can be bound to fields of any numeric type.
Copy[C#] Adding GridViewDecimalColumn
GridViewDecimalColumn decimalColumn = new GridViewDecimalColumn();
decimalColumn.Name = "DecimalColumn";
decimalColumn.HeaderText = "Freight Charges";
decimalColumn.FieldName = "Freight";
decimalColumn.DecimalPlaces = 1;
radGridView1.MasterTemplate.Columns.Add(decimalColumn);
Copy[VB.NET] Adding GridViewDecimalColumn
Dim decimalColumn As New GridViewDecimalColumn()
decimalColumn.Name = "DecimalColumn"
decimalColumn.HeaderText = "Freight Charges"
decimalColumn.FieldName = "Freight"
decimalColumn.DecimalPlaces = 1
RadGridView1.MasterTemplate.Columns.Add(decimalColumn)
Setting a default value for empty cells
You may provide a default value using the following code:
Copy[C#] Setting the default value for empty cells
void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
{
GridSpinEditor spinEditor = this.radGridView1.ActiveEditor as GridSpinEditor;
if (spinEditor != null)
{
if (spinEditor.Value == null)
{
spinEditor.Value = 0.0;
}
}
}
Copy[VB.NET] Setting the default value for empty cells
Private Sub RadGridView1_CellEditorInitialized(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.GridViewCellEventArgs)
Dim spinEditor As GridSpinEditor = TryCast(Me.RadGridView1.ActiveEditor, GridSpinEditor)
If spinEditor IsNot Nothing Then
spinEditor.Value = 0
End If
End Sub
Disable the up and down buttons of the spin editor
The code below demonstrates how you can disable the up and down arrow buttons. Using the commented code you can completely hide them.
Copy[C#] Disable up and down arrow buttons
void radGridView1_CellEditorInitialized1(object sender, GridViewCellEventArgs e)
{
GridSpinEditor spinEditor = this.radGridView1.ActiveEditor as GridSpinEditor;
((GridSpinEditorElement)spinEditor.EditorElement).ShowUpDownButtons = false;
}
Copy[VB.NET] Disable up and down arrow buttons
Private Sub RadGridView1_CellEditorInitialized1(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.GridViewCellEventArgs)
Dim spinEditor As GridSpinEditor = TryCast(Me.RadGridView1.ActiveEditor, GridSpinEditor)
If spinEditor IsNot Nothing Then
Dim element As GridSpinEditorElement = spinEditor.EditorElement
element.ShowUpDownButtons = False
End If
End Sub