OS : Windows 7
IDE : Microsoft Visual Studio Professional 2012
Microsoft .NET Framework 4.5.51209
DeploymentTool : DevExpress 14.1
Form : WinForm
IDE : Microsoft Visual Studio Professional 2012
Microsoft .NET Framework 4.5.51209
DeploymentTool : DevExpress 14.1
Form : WinForm
| Date | Time |
|---|---|
| 20150223 | 114322 |
| 20150211 | 212907 |
| 20150212 | 202059 |
I want to change column format string to datetime.
then, What should I do?
I finally got it.
this.gridView1.CustomColumnDisplayText += (sneder, e) =>
{
if (e.Column.FieldName.Equals("Date"))
{
if (e.Value != null && e.Value.ToString() != "")
{
string strPattern = "yyyyMMdd";
DateTime dtDate;
if (DateTime.TryParseExact(e.Value.ToString(), strPattern, null, System.Globalization.DateTimeStyles.None, out dtDate))
e.DisplayText = string.Format("{0:yyyy-MM-dd}", dtDate);
}
}
if (e.Column.FieldName.Equals("Time"))
{
if (e.Value != null && e.Value.ToString() != "")
{
string strPattern = "hhmmss";
TimeSpan dtTime;
if (TimeSpan.TryParseExact(e.Value.ToString(), strPattern, null, System.Globalization.TimeSpanStyles.None, out dtTime))
e.DisplayText = string.Format("{0}", dtTime);
}
}
};
| Date | Time |
|---|---|
| 2015-02-23 | 11:43:22 |
| 2015-02-11 | 21:29:07 |
| 2015-02-12 | 20:20:59 |
