CODEWITHSUNDEEP
c#winformstelerikradgrid
SOFKiNG
SOFKiNG

Reputation: 385

RadGrid Column Accept Only Decimals?

I have RadGrid and need to set column only accept Decimals (money format) and disable other characters. How do I set a column to accept only Decimals format?

Upvotes: 0

Views: 2967

Answers (1)

Diana Nassar
Diana Nassar

Reputation: 2303

You can use a GridNumericColumn:

<telerik:GridNumericColumn DataField="MoneyAmount" DataType="System.Decimal" NumericType="Currency" HeaderText="Money Amount" SortExpression="MoneyAmount" UniqueName="MoneyAmount" DataFormatString="{0:C}"> 
</telerik:GridNumericColumn>

EDIT

If you are indeed asking about winforms, then the equivalent for the above is GridViewDecimalColumn:

GridViewDecimalColumn currencyColumn = new GridViewDecimalColumn("Currency");
currencyColumn.FormatString = "{0:c}";
myGrid.Columns.Add(currencyColumn);

EDIT2

Try:

GridViewDecimalColumn unitPriceColumn = this.radGridView1.Columns["UnitPrice"] as GridViewDecimalColumn;
unitPriceColumn.FormatString = "Price: {0:C}";
unitPriceColumn.FormatInfo = CultureInfo.CreateSpecificCulture("en-GB");
unitPriceColumn.NullValue = 0;

Check more on: http://www.telerik.com/help/winforms/gridview-columns-data-formatting.html

Upvotes: 1

Related Questions