Batch Edit with DatePicker

[Rich]

Is it possible to get a DatePicker as the editor when doing client-side batch editing? I've tried:

<telerik:GridDateTimeColumn DataField="FirstPaymentDate" PickerType="DatePicker" HeaderText="1st Pmt. Due" UniqueName="FirstPaymentDate" HeaderStyle-Width="100px" ItemStyle-Width="100px" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AllowSorting="false" />

 and

<telerik:GridTemplateColumn HeaderText="1st Pmt. Due" UniqueName="FirstPaymentDate" DataType="System.DateTime" HeaderStyle-Width="100px" ItemStyle-Width="100px" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AllowSorting="false"><br>                                <ItemTemplate><br>                                    <asp:Label runat="server" ID="date"Text='<%# Eval("FirstPaymentDate") %>'><br>                                    </asp:Label><br>                                </ItemTemplate><br>                                <EditItemTemplate><br>                                    <telerik:RadDateTimePicker ID="picker1" runat="server" DbSelectedDate='<%# Bind("date") %>'><br>                                    </telerik:RadDateTimePicker><br>                                </EditItemTemplate><br>                            </telerik:GridTemplateColumn>

 and in neither case do I get a DatePicker control when I click to enter edit mode.

I've searched extensively and haven't been able to find an example that does this. Is it possible? Can someone provide or point me to an example?​

[Konstantin Dikov]

Hi Rich,

With the columns definition that you are using, the rendered editor should be a RadDatePicker and I am assuming that you are not seeing the calendar icon due to the fact that your column width is set to 100px and the default width of the editor is higher. If you set the Width to 200px for example you will notice that you will see correctly the calendar icon.

If you need to change the width of the editor with Batch Editing you could get reference to the editor on the server-side OnPreRender event of the grid (as demonstrated in our help article "Batch Editing Server-side API"):

Another option is to add the following code in your OnPreRender event, which will set the width of all editors to "100%":

GridTableView masterTable = (sender as RadGrid).MasterTableView;
foreach (GridColumn column in masterTable.RenderColumns)
{
    if ((column is IGridEditableColumn) && (column as IGridEditableColumn).IsEditable && masterTable.GetBatchColumnEditor(column.UniqueName) != null)
    {
        Control container = (masterTable.GetBatchColumnEditor(column.UniqueName) as IGridColumnEditor).ContainerControl;
        if (container != null && container.Controls.Count > 0)
        {
            (container.Controls[0] as WebControl).Width = Unit.Percentage(100);
        }
    }
}

Hope this helps.

Regards,
Konstantin Dikov
Telerik

[Rich]

Thanks Konstantin.

Increasing the width solved my problem. I knew it was supposed to generate a default editor but couldn't figure out why it wasn't.

[Augusto]

The solution to set with in edit mode "not using templates "  is:

for datetime column as:

<telerik:GridDateTimeColumn DataField="N_ENTRADA" HeaderText="Entrada" UniqueName="N_ENTRADA" Visible="true" ReadOnly="false" DataFormatString="{0:dd/MM/yyyy}" HeaderStyle-Width="118"> </telerik:GridDateTimeColumn>

Solution:
RadDatePicker fechaEntrada = (RGridNomina.MasterTableView.GetBatchColumnEditor("N_ENTRADA") as GridDateTimeColumnEditor).PickerControl;
            fechaEntrada.Width = Unit.Pixel(110);

 

For numeric column as :

<telerik:GridNumericColumn HeaderStyle-Width="100" ItemStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" DecimalDigits="2" Aggregate="Sum" FooterText=" " DataField="N_CONCEPTO01" HeaderText="Concepto_01"  UniqueName="N_CONCEPTO01"  Visible="false" ReadOnly="false"></telerik:GridNumericColumn>

 

Solution:

RadNumericTextBox unitsNumericTextBox = (RGridNomina.MasterTableView.GetBatchColumnEditor("N_CONCEPTO01") as GridNumericColumnEditor).NumericTextBox;
unitsNumericTextBox.Width = Unit.Pixel(80);

[Augusto]

Should be into  protected void RGridXXX_PreRender(object sender, EventArgs e)
        {

}