Hi Roy,
It seems to be working here just fine. Here's the repro code that I used,
including one without format:
<asp:datagrid id="DataGrid1" runat="server"
AutoGenerateColumns="False">
<columns>
<asp:boundcolumn DataField="final_appvl_dt"
SortExpression="final_appvl_dt" DataFormatString="{0:MMM-dd-yyyy}"
ReadOnly="True" HeaderText="Final Apprvl Date"
ItemStyle-Wrap="false"></asp:boundcolumn>
<asp:boundcolumn
DataField="final_appvl_dt" SortExpression="final_appvl_dt"
ReadOnly="True" HeaderText="Final Apprvl Date"
ItemStyle-Wrap="false"></asp:boundcolumn>
</columns>
</asp:datagrid>
Private Sub Page_Load _
(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
DataGrid1.DataSource = CreateDataSource()
DataGrid1.DataBind()
End If
End Sub
Function CreateDataSource() As DataTable
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add(New DataColumn _
("IntegerValue", GetType(Int32)))
dt.Columns.Add(New DataColumn _
("StringValue", GetType(String)))
dt.Columns.Add(New DataColumn _
("CurrencyValue", GetType(Double)))
dt.Columns.Add(New DataColumn _
("Boolean", GetType(Boolean)))
dt.Columns.Add(New DataColumn _
("final_appvl_dt", GetType(DateTime)))
Dim i As Integer
For i = 0 To 4
dr = dt.NewRow()
dr(0) = i
dr(1) = "Item " + i.ToString()
dr(2) = 1.23 * (i + 1)
dr(3) = (i = 4)
dr(4) = Now.AddDays(i)
dt.Rows.Add(dr)
Next i
Return dt
End Function 'CreateDataSource
Ken
Microsoft MVP [ASP.NET]
Toronto
"Roy" <ro**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hey all,
Ok, I have a boundcolumn in a datagrid which displays a smalldatetime
field from a table. Behold:
<asp:BoundColumn DataField="final_appvl_dt"
SortExpression="final_appvl_dt" DataFormatString="{0:MMM-dd-yyyy}"
ReadOnly="True" HeaderText="Final Apprvl Date"
ItemStyle-Wrap="false"></asp:BoundColumn>
But the DataFormatString part isn't working as I expect. There's no
error and the date follows the format I specified (i.e., Jan 21 1950),
but the time is still displayed? How can I make the time go away?
Thanks!