[Solved] Using radtimepicker in a radgrid control

[Tony Abou-Akl]

I have 2 radtimepicker "start Time" and "End Time" in a radgrid. the rad gris is loaded in edit mode. when user change start time or end time I need first to validate if the end time is after the start time and then i can do my update.
here is my column in the rad grid

 

</ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="ScheduleId" DataType="System.String"

 

 

EmptyDataText="&amp;nbsp;" HeaderText="ScheduleId" ReadOnly="True"

 

 

SortExpression="ScheduleId" UniqueName="ScheduleId" Visible="false">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="ListDate" DataType="System.DateTime"

 

 

EmptyDataText="&amp;nbsp;" HeaderText="Date" ReadOnly="True"

 

 

SortExpression="ListDate" UniqueName="ListDate" >

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridTemplateColumn UniqueName="StartDateTime" HeaderText="Start Time" >

 

 

<ItemTemplate>

 

 

<telerik:RadTimePicker ID="radStartTime" Interval="0:30" dbSelectedDate='<%# DataBinder.Eval( Container, "DataItem.StartDateTime")%>'

 

 

runat="server" Skin="Vista">

 

 

<TimeView OnClientTimeSelected="ClientTimeSelected" runat="server" Interval="0:30" StartTime="8:00" EndTime="18:30" ></TimeView>

 

 

</telerik:RadTimePicker>

 

 

</ItemTemplate>

 

 

</telerik:GridTemplateColumn>

 

 

<telerik:GridTemplateColumn UniqueName="EndDateTime" HeaderText="End Time" >

 

 

<ItemTemplate>

 

 

<telerik:RadTimePicker ID="radEndTime" dbSelectedDate='<%# DataBinder.Eval( Container, "DataItem.EndDateTime")%>'

 

 

runat="server" Skin="Vista">

 

 

<TimeView ID="TimeView1" OnClientTimeSelected="ClientTimeSelected" runat="server" Interval="0:30" StartTime="8:00" EndTime="18:30" ></TimeView>

 

 

</telerik:RadTimePicker>

 

 

</ItemTemplate>

 

 

</telerik:GridTemplateColumn>

 

 

 

</Columns>

how can i validate these 2 time control

Thanks
tony

 

[Shinu]

Hi Tony,

I would suggest you to use a Compare Validator to achieve the desired scenario. You may use a single GridTemplateColumn with the Two TimePickers and a Compare Validator in its ItemTemplate. Try the following approach and see whether it helpful.

ASPX:

       <telerik:GridTemplateColumn UniqueName="TempCol" >
                            <HeaderTemplate>
                                <table id="Table1" cellspacing="1" cellpadding="1" width="300" border="1">
                                    <tr>
                                        <td width="50%">
                                            <b>StartDateTime</b></td>
                                        <td width="50%">
                                            <b>EndDateTime</b></td>
                                    </tr>
                                </table>
                            </HeaderTemplate>
                            <ItemTemplate>
                                <table id="Table2" cellspacing="1" cellpadding="1" width="300" border="1">
                                    <tr>
                                        <td width="50%">
                                            <telerik:RadTimePicker ID="RadTimePicker1" runat="server">
                                               </telerik:RadTimePicker>
                                        </td>
                                        <td width="50%">
                                             <telerik:RadTimePicker ID="RadTimePicker2" runat="server">
                                            </telerik:RadTimePicker>
                                            <asp:CompareValidator ID="CompareValidator1" runat="server"  ControlToCompare="RadTimePicker1" ControlToValidate="RadTimePicker2" Operator="GreaterThan" ErrorMessage="End Time must be Greater than Star time"></asp:CompareValidator>

                                        </td>
                                    </tr>
                                </table>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>

Regards
Shinu.

[Tony Abou-Akl]

Hi Shinu

orry for the late reply, I did try your solution but i have one issue with it. when i load my grid with the time i loaded as multiple Edit and i have the dates editable.
So after the grid load I edit the end time and i put the date after the start time, i get the error saying the end time must be after start time. But if i change the start time then it works. I think on the initial load and when i change any of the control, the other control value is not set properly and it giving the validation error

Please help

Thanks
Tony

[Tony Abou-Akl]

hi Shinu

for some reason when i change the date in radtimepicker it always defualt to today's date and i think that's is why not working. Do you have anyidea why

Thanks