Set Time Interval for GridDateTimeColumn

[Aniket Braganza]

I know how to set the Time interval for RadDateTimePicker to a value that I need, as well as the number of columns etc. My problems is that I do not know of any way of doing this for the GridDateTimeColumn, to ensure that my intervals for all my time pickers are consistent across my site.

How do I do this?

[Aniket Braganza]

Apparently no one has needed this functionality or no one can help me. I am assuming someone from Telerik would know the answer...

[Konstantin Petkov]

Hi Aniket,

You can get the control for each item in ItemCreated or ItemDataBound (when the data is already respected) Grid events and change control's settings accordingly. See the help article here and the demo below for details:

http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/Programming/AccessingCellsAndRows/DefaultCS.aspx

Of course, you will need the GridDateTimeColumn's PickerType="RadDateTimePicker" setting added.

All the best,
Konstantin Petkov
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Shinu]

Hi Aniket,

Try setting the Time interval for the RadDateTimePicker in the GridDateTimeColumn as shown below.

ASPX:

<telerik:GridDateTimeColumn  PickerType="DateTimePicker"  DataField="DateCol" DataType="System.DateTime" HeaderText="DateCol"
                            SortExpression="DateCol" UniqueName="DateCol" ></telerik:GridDateTimeColumn>

CS:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if ((e.Item is GridEditableItem)&&(e.Item.IsInEditMode))
        {
            GridEditableItem item = (GridEditableItem)e.Item;
            RadDateTimePicker DatTimPkr = (RadDateTimePicker)item["DateCol"].Controls[0];
            DatTimPkr.TimeView.Interval = new TimeSpan(0, 15, 0);
        }
    }

Thanks
Shinu.

[Andrew]

any chance this has been changed in the latest versions of the radgrid so it can be set in the markup?

[Chris]

I'm trying to set the interval to 15mins in the ItemDataBound event as suggested. I can see the interval set correctly in the debugger but the time picker is still showing the hourly interval. The grid is doing an inline edit if that matters.

protected void rgJobSchedule_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridEditableItem && e.Item.IsInEditMode)
        {
            GridEditableItem item = (GridEditableItem)e.Item;
            RadTimePicker DatTimPkr = (RadTimePicker)item["StartTime"].Controls[0];
            DatTimPkr.TimeView.Interval = new TimeSpan(0, 15, 0);
        }
    }

Any ideas?

Thanks,
Chris

[Bodevain Svensson]

See whether you assign the interval for the SharedTimeView will get what you want:

DatTimPkr.SharedTimeView.Interval = new TimeSpan(0, 15, 0);

I recall that the built-in datetime grid column uses shared calendar and timeview internally.

Bodevain

[Chris]

That did the trick. Thanks!!!!!