How to format a date field in the SPGridView control

Ever use the SPGridView control and have the need to format a date column? It’s actually pretty simple.

 

BoundField field1 = new BoundField();
field1.HeaderText = “Date Field”;
field1.DataField = “DateField”;
field1.HtmlEncode = true;
field1.DataFormatString = @”{0:M/dd/yyyy}”;
_ResultsGridView.Columns.Add(field1);

The key is to set HtmlEncode to true and set the DataFormatString with the appropriate date format.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.