Inline Add a record in Telerik Grid Throws error Specifies cast is not valid

[Hrushikesh Mokashi]

Hi,

I m using telerik grid with inline Add/edit.
In this grid i have 2 template columne having rad datepicker control in edit template.
when i click on edit link in grid it shows all columns in edit mode but when i click on Add new record it throws an error "Specifies cast is not valid"
as i have bound my raddatepicker as below

<

Telerik:GridTemplateColumn DataField="TransDate" Display="False"

 

HeaderText="Trans Date" UniqueName="TransDate">

 

<EditItemTemplate>

 

 

<Telerik:RadDatePicker ID="rdpTransDate" Runat="server"

 

 

Width="116px" SelectedDate='<%# Bind("TransDate") %>'>

 

<DateInput Height="22px" runat="server">

 

</DateInput>

 

 

<Calendar UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False"

 

 

 

 

ViewSelectorText="x" runat="server">

 

 

 

</Calendar>

 

 

 

</Telerik:RadDatePicker>

 

 

 

</EditItemTemplate>

 

 

 

<ItemTemplate>

 

 

 

<asp:Label ID="TransDateLabel" runat="server" Text='<%# Eval("TransDate") %>'></asp:Label>

 

 

 

</ItemTemplate>

 

 

 

</Telerik:GridTemplateColumn>

When i press 'Add New Record' it throws an error on line

 

 

 

<Telerik:RadDatePicker ID="rdpTransDate" Runat="server"

 

Width="116px" SelectedDate='<%# Bind("TransDate") %>'>

i believe when i try to add a new record the bind is throwing an error.

Please let me know how to resolve this issue.

Thanks in advance.

Hrushikesh

 

 

 

 

 

 

[Shinu]

Hi Hrushikesh,

I would suggest you to use the DbSelectedDate property instead of the SelectedDate property for RadDatePicker.

ASPX:

<Telerik:RadDatePicker ID="rdpTransDate" Runat="server" Width="116px" DbSelectedDate ='<%# Bind("TransDate") %>'>

You can also refer the following online demo.
Data binding

Thanks
Shinu.

[Hrushikesh Mokashi]

Thanks Shinu,

It's working with DbSelecteddate.