Antoine

Posted 21 Jun 2019 Link to this post

• telerik.jpg

Dess | Tech Support Engineer, Sr.

Posted 25 Jun 2019 Link to this post

Hello, Antoine,  

In order to customize the editor in RadGridView, it is necessary to handle the CellEditorInitialized event and apply the desired changes. Please refer to the following code snippet:

private void RadForm1_Load(object sender, EventArgs e)

{

    this.ordersTableAdapter.Fill(this.nwindDataSet.Orders);

 

    this.radGridView1.BestFitColumns();

    GridViewDateTimeColumn dateColumn = radGridView1.Columns["OrderDate"] as GridViewDateTimeColumn;

    dateColumn.Format = DateTimePickerFormat.Custom;

    dateColumn.CustomFormat = "dd/MM/yyyy hh:mm";

 

    this.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized;

}

 

private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)

{

    RadDateTimeEditor editor = e.ActiveEditor as RadDateTimeEditor;

    if (editor != null)

    {

        RadDateTimeEditorElement el = editor.EditorElement as RadDateTimeEditorElement;

        el.CalendarSize = new System.Drawing.Size(400, 300);

        el.ShowTimePicker = true;

    }

}

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

Nikita

Posted 27 Jun 2019 in reply to Dess | Tech Support Engineer, Sr. Link to this post

• RadDateTime.png

Dess | Tech Support Engineer, Sr.

Posted 01 Jul 2019 Link to this post

Hello, Nikita,  

In order to change the font of the grid cells, it is suitable to use the CellFormatting event:

private void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)

{

    e.CellElement.Font = f;

}

 

Font f = new Font("Arial", 10f, FontStyle.Regular);

As to the font of the RadDateTimeEditor, you can specify the font when the editor is initialized as follows:

Font f = new Font("Arial", 10f, FontStyle.Regular);

 

private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)

{

    RadDateTimeEditor editor = e.ActiveEditor as RadDateTimeEditor;

    if (editor != null)

    {

        RadDateTimeEditorElement el = editor.EditorElement as RadDateTimeEditorElement;

        el.CalendarSize = new System.Drawing.Size(400, 300);

        el.ShowTimePicker = true;

 

        el.Calendar.Font = f;

        RadDateTimePickerCalendar calendarBehavior = el.GetCurrentBehavior() as RadDateTimePickerCalendar;

        calendarBehavior.TimePicker.Font = f;

        el.Calendar.ElementRender -= Calendar_ElementRender;

        el.Calendar.ElementRender += Calendar_ElementRender;

    }

}

 

private void Calendar_ElementRender(object sender, RenderElementEventArgs e)

{

    e.Element.Font = f;

}

You can also specify the minutes step by setting the RadDateTimePickerCalendar.TimePicker.TimePickerElement.Step property:

private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)

{

    RadDateTimeEditor editor = e.ActiveEditor as RadDateTimeEditor;

    if (editor != null)

    {

        RadDateTimeEditorElement el = editor.EditorElement as RadDateTimeEditorElement;

        el.CalendarSize = new System.Drawing.Size(400, 300);

        el.ShowTimePicker = true;

 

        el.Calendar.Font = f;

        RadDateTimePickerCalendar calendarBehavior = el.GetCurrentBehavior() as RadDateTimePickerCalendar;

        calendarBehavior.TimePicker.Font = f;

        calendarBehavior.TimePicker.TimePickerElement.Step = 15;

       

        el.Calendar.ElementRender -= Calendar_ElementRender;

        el.Calendar.ElementRender += Calendar_ElementRender;

    }

}

In order to specify working hours, note that you can cancel the ValueChanging event of RadGridView if the selected hour is not allowed. Thus, the user will be restricted according to your custom requirements. You can find below a sample approach:

List<string> non_workingHours = new List<string>() { "12", "1", "2", "3", "4", "5" };

private void radGridView1_ValueChanging(object sender, ValueChangingEventArgs e)

{

    if (e.NewValue is DateTime)

    {

        DateTime newDate = (DateTime)e.NewValue;

        if (newDate != null)

        {

            if (non_workingHours.Contains(newDate.Hour.ToString()))

            {

                e.Cancel=true;

            }

             

        }

    }

}

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.