I have two GridDateTimeColumn in RadGrid1
<telerik:GridDateTimeColumn DataField="FromDate" DataFormatString="{0:d}" FilterControlWidth="98px" HeaderButtonType="TextButton" HeaderStyle-Width="125" HeaderText="From Date ">
<ColumnValidationSettings EnableModelErrorMessageValidation="true" EnableRequiredFieldValidation="true">
<RequiredFieldValidator ErrorMessage="* required" ForeColor="Red"></RequiredFieldValidator>
<ModelErrorMessage BackColor="Red" />
</ColumnValidationSettings>
</telerik:GridDateTimeColumn>
<telerik:GridDateTimeColumn DataField="ToDate" DataFormatString="{0:d}" FilterControlWidth="98px" HeaderButtonType="TextButton" HeaderStyle-Width="125" HeaderText="To Date">
<ColumnValidationSettings EnableModelErrorMessageValidation="true" EnableRequiredFieldValidation="true">
<RequiredFieldValidator ErrorMessage="* required" ForeColor="Red"></RequiredFieldValidator>
<ModelErrorMessage BackColor="Red" />
</ColumnValidationSettings>
</telerik:GridDateTimeColumn>
And I want to add compareValidator in RadGrid1_ItemCreated. Like this
Private Sub RadGrid1_ItemCreated1(sender As Object, e As GridItemEventArgs) Handles RadGrid1.ItemCreated
If (TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode) Then
Dim fromDatecolumnEditor As GridDateTimeColumnEditor = TryCast(DirectCast(e.Item, GridEditableItem).EditManager.GetColumnEditor("FromDate"), GridDateTimeColumnEditor)
Dim toDatecolumnEditor As GridDateTimeColumnEditor = TryCast(DirectCast(e.Item, GridEditableItem).EditManager.GetColumnEditor("ToDate"), GridDateTimeColumnEditor)
Dim datecell As TableCell = DirectCast(toDatecolumnEditor.PickerControl.Parent, TableCell)
Dim compareValidator As New CompareValidator()
compareValidator.ID = "compareValidator"
compareValidator.ControlToValidate = toDatecolumnEditor.PickerControl.ID
compareValidator.ValueToCompare = fromDatecolumnEditor.PickerControl.ID
compareValidator.[Operator] = ValidationCompareOperator.GreaterThanEqual
compareValidator.Type = ValidationDataType.[Date]
compareValidator.ForeColor = Drawing.Color.Red
compareValidator.ErrorMessage = "To date must be later than from date."
datecell.Controls.Add(compareValidator)
End If
But, it is not work. Please help.
It works if make change to
'compareValidator.ValueToCompare = DateTime.Now.ToShortDateString