ASP.NET GridView Column - formatting telephone number

Question

I am adding a column to my gridview in code-behind as follows:

field = new BoundField();
field.HeaderText = "Phone Number";
field.DataField = "PhoneNumber";
field.HtmlEncode = false;
field.DataFormatString = "{0:###-###-####}";
gridView.Columns.Add(field);

However, the DataFormatString is not working because the PhoneNumber field is a string, not a numeric. Is there anyway to take care of that in the DataFormatString, or do I need to convert the data type before I get to this point?

Zoman · Accepted Answer · 2009-07-24 22:12:12Z

1

This is tricky. I'd probably format it 'manually' in the RowDataBound event of the grid.

answered Jul 24, 2009 at 22:12

Zoman

2,1074 gold badges35 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Cole Over a year ago

I didn't show all of my code - the GridView is also instantiated and loaded from code-behind. Does it still have a RowDataBound event?

JBrooks · Accepted Answer · 2009-07-25 20:20:13Z

0

First choice is to do it in SQL

  select cast(phone as int) as Phone,...

If not, make that column a templated column and then you would have something like:

<asp:TextBox ID="TextBox1" runat="server" 
Text='<%#(DataBinder.Eval(Container.DataItem, "Phone")== System.DBNull.Value)?
"":
String.Format("{0:(###) ###-####}", 
Convert.ToInt64(DataBinder.Eval(Container.DataItem, "Phone"))))
%>'>
</asp:TextBox>

answered Jul 25, 2009 at 20:20

JBrooks

10k2 gold badges31 silver badges32 bronze badges

2 Comments

Mike Cole Over a year ago

I'm adding the column in code-behind. Can I add a templated column in code-behind?

JBrooks Over a year ago

We are talking about addeding a templated column in the .aspx markup. See authors.aspalliance.com/aspxtreme/webforms/controls/…

Collectives™ on Stack Overflow

ASP.NET GridView Column - formatting telephone number

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related