DataFormatString not working in gridview column [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 8 months ago.

Improve this question

I have an ASP.NET 3.5 application with a gridview in a page.

I want to format one of the columns as a datetime. I've tried:

<asp:BoundField DataField="StatusDate" HeaderText="as of" SortExpression="StatusDate" DataFormatString="{0:d}" />

The problem is no matter what I do, my formatting never changes. I've tried the other date formatting strings (general, sortable, longdate, the list goes on), but the format of this column never changes.

I don't think I'm doing anything wrong, but this is driving me nuts when I try to sort based on this column. Because the default is formatting the column as a string, it doesn't sort correctly when I sort by the column header.

Anyone seen this and have some kind of workaround? I've seen articles mentioning adding a custom sort method, but I'm trying to stick to out-of-the-box functionality if I can.

Try setting .HtmlEncode = false, though the note says it should work fine 3.5+ without that flag set. — Marc
– Marc, Commented Mar 4, 2013 at 17:50
Please see my answer for the first question - string format issue. For sorting, what kind of data source are you using? — Win
– Win, Commented Mar 4, 2013 at 18:06

TylerH · Accepted Answer · 2025-04-01 19:09:39Z

2

I've actually had this issue a few times and have come up with the following solution. First off I place all of my data in a DataTable for storage.

Secondly, the column of which I need to format something specifically I also implicitly define the data type.

    DataTable table = new DataTable();
    table.Columns.Add("decimalNumber").DataType = System.Type.GetType("System.Decimal");
    table.Columns.Add("date").DataType = System.Type.GetType("System.DateTime");

Then when I call it in the GridView

    <asp:BoundField DataField="decimalNumber" DataFormatString="{0:C}" />
    <asp:BoundField DataField="date" DataFormatString="{0:dd/MM/yyyy}" />

And the results will look like this: $0.00 & 19/11/2014.

edited Apr 1 at 19:09

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Nov 19, 2014 at 19:01

user1500419

313 bronze badges

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

Comments

Win · Accepted Answer · 2013-03-04 18:00:24Z

0

You cannot format as datetime from string.

However, You can use the following approach. Output is basically same as using BoundField.

<asp:TemplateField HeaderText="as of" SortExpression="StatusDate">
   <ItemTemplate>
      <asp:Literal ID="Literal1" runat="server" 
        Text='<%# string.Format("{0:d}",  Convert.ToDateTime(Eval("StatusDate"))) %>'>        
      </asp:Literal>
   </ItemTemplate>
</asp:TemplateField>

edited Mar 4, 2013 at 18:00

answered Mar 4, 2013 at 17:55

Win

62.4k13 gold badges106 silver badges190 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:28:49Z

0

The problem is that the datatype of your data/column is a string. Your DataFormatString property will only work on a datetime column. The solution to this problem can be found in this SO answer.

Formatting applied to boundfields in gridview is not working

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Jun 13, 2014 at 11:27

Stuart

6697 silver badges20 bronze badges

Comments

Fatemeh M. Rezaie · Accepted Answer · 2016-05-18 11:39:01Z

0

Because the data type of the source of that column is not datetime!

answered May 18, 2016 at 11:39

Fatemeh M. Rezaie

16310 bronze badges

Collectives™ on Stack Overflow

DataFormatString not working in gridview column [closed]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related