Formatting of Phone Numbers

[Brian Mains]

Hello,

I'm  binding this data (a phone number):

5555015555

to a radgrid column.  I need it to appear as:

[phone]

But I tried using a format string and it didn't work.  Is the only way to format it through code?

Thanks.

[Princy]

Hello Brian,

The DataFormatString property for phone number will only works if your data type in that column is of type like numeric. This approach does not work if you have data type as string.
One option is converting the data type of that column to something that can be formatted using the format string and do it from code behind.
Another option is using GridTemplateColumn instead of GridBoundColumn and format it like below.

ASPX:

<telerik:GridTemplateColumn HeaderText="Phone Number">
   <ItemTemplate>
        <%# string.Format("{0:(###)###-####}", Convert.ToInt64(Eval("phone"))) %>
   </ItemTemplate>
</telerik:GridTemplateColumn>

Thanks,
Princy.

[J2K]

The simpliest solution I've found is

1) In the datasource, convert the telephone field/column to a big int if it's now stored as string/char: Convert(bigint,Telephone) as Telephone

2) In the Radgrid markup, add this: DataType="System.Int64"    DataFormatString ="{0:(###) ###-####}"