This is a migrated thread and some comments may be shown as answers.

Set GridDateTimeColumn Default Insert Value to Today with Batch Edit Mode

12 Answers 713 Views

Grid

This is a migrated thread and some comments may be shown as answers.

12 Answers, 1 is accepted

answered on 30 Oct 2015, 01:07 PM

Hello Amy,

Try the following code snippet in order to set current date to DatePicker when in Insert mode.

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataInsertItem && e.Item.OwnerTableView.IsItemInserted)

{

GridDataInsertItem insertItem = (GridDataInsertItem)e.Item;

(insertItem["DateTimeColumn_UniqueName"].Controls[0] as RadDatePicker).SelectedDate = DateTime.Today;

}

Regards,
Maria Ilieva
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

answered on 06 Nov 2015, 01:07 PM

Hello,

With batch editing you can use the following:

protected void RadGrid1_PreRender(object sender, EventArgs e)

{

GridTableView masterTable = ((RadGrid)sender).MasterTableView;

GridDateTimeColumnEditor editor = masterTable.GetBatchColumnEditor("OrderDate") as GridDateTimeColumnEditor;

RadDatePicker picker = editor.PickerControl;

picker.SelectedDate = DateTime.Today;

}

Regards,
Maria Ilieva
Telerik

answered on 12 Nov 2015, 09:06 AM

Hi Amy,

It appears that we have an issue with setting default insert value when batch editing is enabled and this issue is logged in our system for further investigation.

Meanwhile you can handle the client OnRowCreated event and apply the default date like this:

function RowCreated(sender, args) {

if (args.get_itemIndexHierarchical() < 0) {

args.get_tableView().get_dataItems();

var cell = args.get_tableView().getCellByColumnUniqueName(args.get_gridDataItem(), "HireDate");

args.get_tableView().get_owner().get_batchEditingManager().changeCellValue(cell, new Date().toString());

}

I hope this helps.

Regards,
Maria Ilieva
Telerik

answered on 12 Nov 2015, 09:22 AM

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="true" DataSourceID="SqlDataSource1">

<MasterTableView EditMode="Batch" DataKeyNames="EmployeeID" CommandItemDisplay="Top">

<Columns>

<telerik:GridDateTimeColumn UniqueName="BirthDateColumn" DataField="BirthDate"></telerik:GridDateTimeColumn>

<telerik:GridTemplateColumn Display="false">

<ItemTemplate>

<%(RadGrid1.MasterTableView.GetColumn("BirthDateColumn") as GridEditableColumn).DefaultInsertValue = DateTime.Now.ToString();%>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

Regards,

Edward

answered on 12 Nov 2015, 08:20 PM

Thank you Maria and Edward for your suggestions. Please see the results of my test below:

Maria's suggestion using the OnRowCreated event.
- Sets the initial date with the proper formatting.

- However, the date is not saved when the Save button is clicked. Note that I am saving the grid data using the method as described here - http://www.telerik.com/forums/how-do-i-save-2-radgrids-by-only-1-outside-button.
Edward's suggestion using an additional hidden column.
- Sets the initial date, but does not have the proper formatting.

- The date is not saved when the Save button is clicked.

Almost have a working solution... But is seems that the BatchEditingManager doesn't think that there are table changes when setting the initial date this way.