Date Won't Format

[Jonathan Wood]

I have a GridView control that displays the data in a List<object;

My GridView contains the following in its definition:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CssClass="grid" DataSourceID="ObjectDataSource1">
<Columns>
[...]
<asp:BoundField DataField="DueDate" HeaderText="Due Date"
SortExpression="DueDate" DataFormatString="-->{0:d}<--"
HtmlEncodeFormatString="False" />
[...]
</Columns>
[...]
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetWeekDetails" TypeName="DTS.Deliveries">
[...]
</asp:ObjectDataSource>

But the DueDate column is displayed in the format "-->8/21/2008 12:00:00
AM--<". It is obviously using my format string but not to format the date.

The data is of type List<WorkDetailswhere WeekDetails is defined as:

public class WeekDetails
{
public int Week { get; set; }
public string Month { get; set; }
public DateTime DueDate { get; set; }
public int Deliveries { get; set; }
}

Deliveries.GetWeekDetails() is defined as:

public static List<WeekDetailsGetWeekDetails(int contractId, int
categoryId)
{
List<WeekDetailslist = new List<WeekDetails>();
int week = 0;

using (SqlDataReader rdr = DataHelper.ExecDataReader("SELECT DueDate,
TargetDeliveries FROM ScheduledDeliveries" +
" WHERE ContractID=@ContractID AND CategoryID=@CategoryID",
"@ContractID", contractId, "@CategoryID", categoryId))
{
int dueDateOrdinal = rdr.GetOrdinal("DueDate");
int targetOrdinal = rdr.GetOrdinal("TargetDeliveries");
while (rdr.Read())
{
week++;
WeekDetails wd = new WeekDetails();
wd.Week = week;
wd.DueDate = rdr.GetDateTime(dueDateOrdinal);
wd.Month = wd.DueDate.ToString("MMMM");
wd.Deliveries = rdr.GetInt32(targetOrdinal);
list.Add(wd);
}
}
return list;
}

I'm confident my select parameters are correct as they display the correct
results. I wondered if DueDate could've been converted to a string already
and that's why it wasn't formatting, but in the code above, I inserted a
line like string s = String.Format("{0:d}", wd.DueDate) and it appeared as
the date only as expected.

Can anyone guess what else I might try to figure out why my dates won't
format?

Thanks for any tips!

Jonathan

[Jonathan Wood]

Resolved:

http://weblogs.asp.net/rajbk/archive...31/429090.aspx

Jonathan

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eK**************@TK2MSFTNGP04.phx.gbl...

>I have a GridView control that displays the data in a List<object;

My GridView contains the following in its definition:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CssClass="grid" DataSourceID="ObjectDataSource1">
<Columns>
[...]
<asp:BoundField DataField="DueDate" HeaderText="Due Date"
SortExpression="DueDate" DataFormatString="-->{0:d}<--"
HtmlEncodeFormatString="False" />
[...]
</Columns>
[...]
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetWeekDetails" TypeName="DTS.Deliveries">
[...]
</asp:ObjectDataSource>

But the DueDate column is displayed in the format "-->8/21/2008 12:00:00
AM--<". It is obviously using my format string but not to format the date.

The data is of type List<WorkDetailswhere WeekDetails is defined as:

public class WeekDetails
{
public int Week { get; set; }
public string Month { get; set; }
public DateTime DueDate { get; set; }
public int Deliveries { get; set; }
}

Deliveries.GetWeekDetails() is defined as:

public static List<WeekDetailsGetWeekDetails(int contractId, int
categoryId)
{
List<WeekDetailslist = new List<WeekDetails>();
int week = 0;

using (SqlDataReader rdr = DataHelper.ExecDataReader("SELECT DueDate,
TargetDeliveries FROM ScheduledDeliveries" +
" WHERE ContractID=@ContractID AND CategoryID=@CategoryID",
"@ContractID", contractId, "@CategoryID", categoryId))
{
int dueDateOrdinal = rdr.GetOrdinal("DueDate");
int targetOrdinal = rdr.GetOrdinal("TargetDeliveries");
while (rdr.Read())
{
week++;
WeekDetails wd = new WeekDetails();
wd.Week = week;
wd.DueDate = rdr.GetDateTime(dueDateOrdinal);
wd.Month = wd.DueDate.ToString("MMMM");
wd.Deliveries = rdr.GetInt32(targetOrdinal);
list.Add(wd);
}
}
return list;
}

I'm confident my select parameters are correct as they display the correct
results. I wondered if DueDate could've been converted to a string already
and that's why it wasn't formatting, but in the code above, I inserted a
line like string s = String.Format("{0:d}", wd.DueDate) and it appeared as
the date only as expected.

Can anyone guess what else I might try to figure out why my dates won't
format?

Thanks for any tips!

Jonathan