I have a column with which get's edited using the ListViewDateTimeEditor.
The question is, how do I format the value that gets submitted to the ListView.
To be clear, I have already formatted the ListViewDateTimeEditor to use the following:
Dim Editor As New ListViewDateTimeEditorTryCast(Editor.EditorElement, BaseDateTimeEditorElement).Format = DateTimePickerFormat.CustomTryCast(Editor.EditorElement, BaseDateTimeEditorElement).CustomFormat = "MM/dd/yyyy"e.Editor = Editor
Even with this formatting, it still submits the full DateTime to the ListView when finished editing. How do I make it output only the formatted Date value, without the Time?
2 Answers, 1 is accepted
0
Brandon
Top achievements
Rank 1
Rank 1
answered on 22 Jan 2019, 09:25 PM
Not sure if it's the proper way, but I figured out at least one way to do it.
I captured and processed it in the ListView's ItemEdited event.
Private Sub lvEquip_ItemEdited(sender As Object, e As ListViewItemEditedEventArgs) Handles lvEquip.ItemEdited If e.VisualItem.Data.ListView.CurrentColumn.Name = "Col23" Then Dim DT As DateTime DateTime.TryParse(e.VisualItem.Data("Col23"), DT) e.VisualItem.Data("Col23") = DT.ToShortDateString End IfEnd Sub0
Hi Brandon,
Your appraoch is ok if you are storing the data as a string. If you are storing a DateTime object you can use the CellFormatting event and change the text of the cell which would not affect the actual value:
I hope this will be useful. Let me know if you have additional questions.
Regards,
Dimitar
Progress Telerik
Your appraoch is ok if you are storing the data as a string. If you are storing a DateTime object you can use the CellFormatting event and change the text of the cell which would not affect the actual value:
Private Sub RadListView1_CellFormatting(ByVal sender As Object, ByVal e As ListViewCellFormattingEventArgs) Dim cell As DetailListViewDataCellElement = TryCast(e.CellElement, DetailListViewDataCellElement) If cell IsNot Nothing AndAlso cell.Data.Name = "Date" Then Dim value As Date = CDate(cell.Row("Date")) cell.Text = value.ToShortDateString() End IfEnd SubI hope this will be useful. Let me know if you have additional questions.
Regards,
Dimitar
Progress Telerik
Get quickly onboard and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.