Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, _ ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then e.Item.Cells(0).Text = Format(System.Convert.ToDateTime(e.Item.Cells(1).Text),_ "yyyy-M-d") End If End Sub方法很多的
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem,_
"CreateDate","{0:yyyy-M-d}") %>' />
</ItemTemplate>
</asp:TemplateColumn>
ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
e.Item.Cells(0).Text = Format(System.Convert.ToDateTime(e.Item.Cells(1).Text),_
"yyyy-M-d")
End If
End Sub方法很多的
<HeaderStyle Width="200px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<ItemTemplate>
<asp:Label runat="server" Text='<%# Convert.ToDateTime( DataBinder.Eval(Container.DataItem, "CreateDate") ).ToShortDateString() %>' />
</ItemTemplate>
</asp:TemplateColumn>
其他:DataFormatString="{0:d}"
BoundColumn列:DataFormatString="{0:d}"
HyperLinkColumn列:DataTextFormatString="{0:d}"
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if( e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )
{
DataRow row = ( (DataRowView)e.Item.DataItem).Row ;
if (!row.IsNull("日期"))
{
DateTime dt = (DateTime)row["日期"];
e.Item.Cells[3].Text = dt.ToString("yyyy年MM月dd日"); //string.Format("{0}年{1:00}月{2:00}日" , dt.Year , dt.Month , dt.Day );
}
else{
e.Item.Cells[日期所在列序号].Text = " ";
}
}
}
<HeaderStyle Width="200px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
select to_date(字段名,'yyyy-mm-dd') 字段名 from 表名;
select to_char(字段名,'yyyy-mm-dd') 字段名 from 表名;
或
<asp:BoundColumn DataField="f_time" HeaderText="回复时间" DataFormatString="{0:d}">
<HeaderStyle Width="200px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
让查询后的显示数据格式进行转换
|先天性缺乏人民币|
|================|