ASP.NET Grid view Data filed Column Formatting Not working

Question

I have a problem with the GridView column formatting. I have a PhoneNumber that is currently coming from database as (###)###-##### but I want the format to be ############ without spacing and brackets. I have tried every thing like DataFormatString="{0:###-####}" or than converting it into TemplateField and giving it format but not working.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
  <Columns>
    <asp:TemplateField HeaderText="Phone Number">
      <EditItemTemplate>
        <asp:TextBox ID="TextBox1" runat="server" Text='<%# 
            Bind("PhoneNumber") %>'></asp:TextBox>
      </EditItemTemplate>
      <ItemTemplate>
        <asp:Label ID="Label1" runat="server" 
            Text='<%# Bind("PhoneNumber", "{0:d}") %>'></asp:Label>
      </ItemTemplate>
    </asp:TemplateField>
  </Columns>
</asp:GridView>

This is before converting the column to TemplateField:

 <asp:BoundField DataField="PhoneNumber" HeaderText="Phone Number Home" 
     SortExpression="Phone" DataFormatString="{0:######-####}" HtmlEncode="false" />

But nothing is working. I still get the format of phone number like this (123) 123-4567.

score 1 · Accepted Answer · 2017-09-28 16:02:03Z

1

Try to replace Text property in TemplateField:

Text='<%# Bind("PhoneNumber", "{0:d}") %>'

with:

Text='<%# String.Format("{0:##########}", 
                  Convert.ToInt64(DataBinder.Eval(Container.DataItem, "PhoneNumber")))%>'

Use "#" Custom Specifier.

edited Sep 28, 2017 at 16:02

answered Sep 28, 2017 at 6:54

user1773603

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

9 Comments

Simple Code Over a year ago

Input string was not in a correct format. i keep getting this Error i even tried other Formats it doesn't fox it self .

Simple Code Over a year ago

Exception Details: System.FormatException: Input string was not in a correct format.

user1773603 Over a year ago

I have edit my answer with a reference to custom format specifier.

Simple Code Over a year ago

' <ItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# String.Format("{0:F2}", Convert.ToInt64(DataBinder.Eval(Container.DataItem, "LocalPhone")))%>' > </asp:TextBox>'

Simple Code Over a year ago

This is how it looks like with # thing in front but it still giving me error.

|

Marisa · Accepted Answer · 2017-09-27 19:45:38Z

0

Formatting is solely additive, not subtractive. To accomplish this, you would need to expose a version of the values which has non-numerics stripped out, so that your client-side formatting can act upon it.

answered Sep 27, 2017 at 19:45

Marisa

8027 silver badges24 bronze badges

2 Comments

Simple Code Over a year ago

Non-numerics Stripped out ? u mean the Brackets stripped out yes but how ? what code should i use

Marisa Over a year ago

@Haseeb.A When you retrieve the phone number from your datasource, you should either strip the non-numeric characters out and treat it as a string, or strip out the non-numeric characters and treat it as an integer. In either scenario you would then be able to apply formatting. There are plenty of answers on how to strip out values in C#.

dhiman · Accepted Answer · 2017-09-27 19:47:26Z

0

If you are dynamically binding the rows in code behind, you should be formatting the columns in the DataBind event of the gridview.

The semantical column formatting works only when you use bind data semantically, for example declare

answered Sep 27, 2017 at 19:47

dhiman

5274 silver badges10 bronze badges

1 Comment

Simple Code Over a year ago

I didn't quite understand that how i even tried onRoDataBound

Collectives™ on Stack Overflow

ASP.NET Grid view Data filed Column Formatting Not working

3 Answers 3

9 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related