GridViewDateTimeColumn queries

[Johan Bjerling]

Hello,

I have a few questions regarding the GridViewDateTimeColumn.

One, is there a way to set the range of dates that you can pick? Or perhaps a way to disable future dates?

Two, is there a way to create a TimePicker column?

Three, when editing an empty DateTime column it seems I have to make a selection, if i leave the selected date as it is (i.e. todays date) that date does not "stick" when I leave the column. The only way to select todays date it seems is to select another date first (using arrow keys) then today's date or to select the date in the actual date picker. Is there a way to make today's date "stick", if you will, without having to make an explicit selection?

Thank you
Johan

[Robert]

Hello Johan,

One:

Yes, you can do this by customizing the editor in the CellBeginEdit or CellEditorInitialized event.

http://www.telerik.com/help/winforms/editors_customizing.html

RadDateTimeEditor editor = radGridView1.ActiveEditor as RadDateTimeEditor;
editor.MinValue = DateTime.Today.AddDays(-10);
editor.MaxValue = DateTime.Today.AddDays(10);

Two:

You should be able to access the RadDateTimeEditorElement on the ActiveEditor and set its properties to support only times. (Do this in the CellEditorInitialized event)

RadDateTimeEditorElement element = (((RadDateTimeEditor)radGridView1.ActiveEditor).EditorElement as RadDateTimeEditorElement);
element.Format = DateTimePickerFormat.Time;

Three:

For this problem, I would probably set up the rows/objects in the table to have a default value of today for that field.

I hope this helps.

- Robert

[Johan Bjerling]

Hi Robert

Thanks for your help.

Regarding point two, the solution you provided only served to change the textbox bit to timeformat.
The dropdown section still showed a calendar.
But that's ok, I can live with a dropdown with the times that I'm interested in allowing users to select.

Thank you
Johan

[narim jacksimov]

I am actually wondering if there is a way to remove the Calendar Dropdown or change it to an updown? 

I tried setting the ShowUpDown property to true but when I do that I get a null reference exception. 

[Jack]

Hello Johan,

As Narim suggested, you may set the ShowUpDown property to true. This will change the down arrow button to up/down button and will hide the calendar popup. Please consider the following code sample:

void radGridView1_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)
{
    RadDateTimeEditor editor = this.radGridView1.ActiveEditor as RadDateTimeEditor;
    if (editor != null)
    {
        RadDateTimeEditorElement editorElement = (RadDateTimeEditorElement)editor.EditorElement;
        editorElement.ShowUpDown = true;
    }
}

Narim, please tell us whether this code works for you. If not, send us your application and I will try to locate the issue.

Another option is to use a masked textbox column. The code below shows how to setup this column to show a date:

GridViewMaskBoxColumn column = new GridViewMaskBoxColumn("maskeddate", "");
column.MaskType = MaskType.DateTime;
column.Mask = "d";
this.radGridView1.Columns.Add(column);

I hope this helps.

All the best,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.