IDE : Microsoft Visual Studio Professional 2012
Microsoft .NET Framework 4.5.51209
DeploymentTool : DevExpress 14.1
Form : XtraReport
Date | Time |
---|---|
20150223 | 114322 |
20150211 | 212907 |
20150212 | 202059 |
I want to change column format string to datetime.
then, What should I do?
Ok, change cloumn's diplay format.
wasting my time...
Ok, reading devexpress doc.
wasting my time...
Ok, google serching.
I finally got it.
private void xrTblCellDate_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { var varDate = GetCurrentColumnValue((sender as XRTableCell).Tag.ToString()); if (varDate != null && varDate.ToString() != "") { string strPattern = "yyyyMMdd"; DateTime dtDate; if (DateTime.TryParseExact(varDate.ToString(), strPattern, null, System.Globalization.DateTimeStyles.None, out dtDate)) (sender as XRTableCell).Text = string.Format("{0:yyyy-MM-dd}", dtDate); } }
private void xrTblCellTime_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { var varTime = GetCurrentColumnValue((sender as XRTableCell).Tag.ToString()); if (varTime != null && varTime.ToString() != "") { string strPattern = "hhmmss"; TimeSpan dtTime; if (TimeSpan.TryParseExact(varTime.ToString(), strPattern, null, System.Globalization.TimeSpanStyles.None, out dtTime)) (sender as XRTableCell).Text = string.Format("{0}", dtTime); } }
Date | Time |
---|---|
2015-02-23 | 11:43:22 |
2015-02-11 | 21:29:07 |
2015-02-12 | 20:20:59 |
댓글 없음:
댓글 쓰기