Date Formating

[Seli]

Hello

I would like to format a date in the DataGrid to be 3.3.2004 and not with the time (default?) 3.3.2004 00:00:00!

<aspataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 80px; POSITION: absolute; TOP: 264px
runat="server"> AutoGenerateColumns="True" </aspataGrid

DataGrid1.DataSource=ds.Tables["Products"].DefaultView
DataGrid1.DataBind()

DataGrid1.Columns[0].DataFormatString = "{0:d}"

The last line does not work

Thank
Seli

 

[Scott Mitchell [MVP]]

I would like to format a date in the DataGrid to be 3.3.2004 and not with the time (default?) 3.3.2004 00:00:00!!

<aspataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 80px; POSITION: absolute; TOP: 264px"
runat="server"> AutoGenerateColumns="True" </aspataGrid>

DataGrid1.DataSource=ds.Tables["Products"].DefaultView;
DataGrid1.DataBind();

DataGrid1.Columns[0].DataFormatString = "{0:d}";

Two things:

1.) You need to set the DataFormatString *before* the call to DataBind()
2.) The Columns[0] returns a DataGridColumn class instance. This class
doesn't have a DataFormatString. The BoundColumn class does. So you
need to cast Columns[0] to a BoundColumn before trying to muddle with
the DataFormatString property. Something like:

((BoundColumn) DataGrid1.Columns[0]).DataFormatString = "{0:d}";

Remember to place this **before** the DataBind() call...

Happy Programming!

--

Scott Mitchell
(e-mail address removed)
http://www.4GuysFromRolla.com
http://www.ASPFAQs.com
http://www.ASPMessageboard.com

* When you think ASP, think 4GuysFromRolla.com!