Format Phone Number String in Datagrid Column

[Dave]

Greetings,

I have a 10 digit phone number stored as a string in a SQL server table. My
datagrid currently displays it as 1234567890, but I would like to format the
column to read:

(123)-456-7890 or even 123.456.7890

Any suggestions for that one?

Thanks,

-Dave

 

[Eliyahu Goldin]

Dave,

You should use either ItemDataBound or PreRender event in codebehind. Get
the value of the cell, format it in the code and put back to the cell. I
don't think there are any standard formatting capabilities for phone
numbers.

Eliyahu

 

[Edge]

Dave,

You should use either ItemDataBound or PreRender event in codebehind.
Get the value of the cell, format it in the code and put back to the
cell. I don't think there are any standard formatting capabilities
for phone numbers.

Eliyahu

There is a third solution: calling a conversion function in the databinding
block.

This is the databinding block:

<%# myFunction(DataBinder.Eval(Container.DataItem,"Telephone") %>

This is the function for VB.NET:

Function myFunction(o As Object) As String
If(IsDbNull(o)) Return ""
Dim str As String = o.ToString()
Return "(" & str.SubString(0,3) & ")-" & str.SubString(3,3) & "-" &
str.SubString(6,4)
End Function

 

[Dave]

Perfect! Thank you both for your help. My column is now properly
formatted.

-Dave