ASP.NET GridView issue with DataFormatString in a BoundField

Question

I have a BoundField in a GridView whose datatype (in MSSQL) is time(7). The format is being displayed as:

hh:mm:ss.xxxxxx

I want to add a DataFormatString to this boundfield so that the field displays in the format:

hh:mm:ss

Here is a snippet of the .aspx file that I'm modifying:

<asp:BoundField DataField="ProcTime" HeaderText="ProcTime"

SortExpression="ProcTime" ApplyFormatInEditMode="true" HtmlEncode="true" DataFormatString="{0:F0}" />

I've tried many different format strings (t, T, d, D, m, etc) but it does not change the format of the boundfield.

What am I missing?

David Weiser · Accepted Answer · 2010-06-16 22:32:41Z

1

I figured it out (the link here gives a more in depth example).

In a nutshell, I need to add an event handler to my GridView which fires when the "OnRowDataBound" event happens. This event handler will then be in charge of changing the formatting of the text in a cell.

answered Jun 16, 2010 at 22:32

David Weiser

5,2034 gold badges30 silver badges35 bronze badges

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

Comments

Andrey · Accepted Answer · 2010-06-16 20:50:50Z

0

because you are formatting just a single value and not a set of values you do not need to specify what value to use. So the format"{0:F0}" becomes "{F0}"

answered Jun 16, 2010 at 20:50

Andrey

1,24712 silver badges32 bronze badges

1 Comment

David Weiser Over a year ago

That doesn't seem to make much of a difference.

Collectives™ on Stack Overflow

ASP.NET GridView issue with DataFormatString in a BoundField

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related