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

can't Bind RadDatePicker

7 Answers 345 Views

Calendar

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

mac asked on 17 Jul 2008, 06:02 PM

working in an EditFormTemplate within a radgrid. I am trying to bind the SelectedDate.

    
             <td style="width: 8px; height: 42px;">  
        
                        <telerik:RadDatePicker    SelectedDate='<%# Bind("DOB") %>' 
        
                         ID="tbBdate" runat="server" Culture="English (United States)" MinDate="1920-01-01">  
        
                        </telerik:RadDatePicker> 
        
                    </td>

I have also tried SelectedDate='<%# DataBinder.Eval(Container.DataItem,"DOB") %>'

I seem to always be having problems with this ctrl.

thanks
Mac

this is my current error

    
            Specified cast is not valid.   
        
            Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.   
        
            Exception Details: System.InvalidCastException: Specified cast is not valid.  
        
            Source Error:   
        
            Line 97:             DOB (if avail)</td> 
        
            Line 98:         <td style="width: 8px; height: 42px;">  
        
            Line 99:             <telerik:RadDatePicker    SelectedDate='<%# Bind("DOB") %>' 
        
            Line 100:             ID="tbBdate" runat="server" Culture="English (United States)" MinDate="1920-01-01">  
        
            Line 101:

7 Answers, 1 is accepted

answered on 18 Jul 2008, 02:36 PM

Hello Mac,

What is the DOB stored as in your data source? If you are storing it as something other than a datetime type then you will definitely get the exception. I was not able to reproduce the problem when testing the RadDatePicker in a RadGrid. Here is a sample I produced which uses the Northwind database.

    
            <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml"> 
        
            <head runat="server"> 
        
                <title>Untitled Page</title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server"> 
        
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server" />   
        
                    <telerik:RadGrid ID="RadGrid1" runat="server"  
        
                        AutoGenerateEditColumn="True"  
        
                        AutoGenerateColumns="false" 
        
                        AllowAutomaticUpdates="true" 
        
                        DataSourceID="SqlDataSource1"> 
        
                        <MasterTableView DataKeyNames="OrderID" DataSourceID="SqlDataSource1"> 
        
                            <Columns> 
        
                                <telerik:GridTemplateColumn DataField="OrderID"> 
        
                                    <ItemTemplate> 
        
                                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("OrderID") %>' /> 
        
                                    </ItemTemplate> 
        
                                    <EditItemTemplate> 
        
                                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("OrderID") %>' /> 
        
                                    </EditItemTemplate> 
        
                                </telerik:GridTemplateColumn> 
        
                                <telerik:GridTemplateColumn DataField="ShippedDate"> 
        
                                    <ItemTemplate> 
        
                                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("ShippedDate") %>' /> 
        
                                    </ItemTemplate> 
        
                                    <EditItemTemplate> 
        
                                        Shipped:  
        
                                        <telerik:RadDatePicker ID="RadDatePicker1" runat="server" 
        
                                            SelectedDate='<%# Bind("ShippedDate") %>' 
        
                                            MinDate="1/1/1950" 
        
                                            Culture="English (United States)"> 
        
                                        </telerik:RadDatePicker> 
        
                                    </EditItemTemplate> 
        
                                </telerik:GridTemplateColumn> 
        
                                <telerik:GridTemplateColumn DataField="ShipName"> 
        
                                    <ItemTemplate> 
        
                                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("ShipName") %>' />                          
        
                                    </ItemTemplate> 
        
                                    <EditItemTemplate> 
        
                                        Name: 
        
                                        <telerik:RadTextBox ID="RadTextBox1" runat="server" Text='<%# Bind("ShipName") %>' /> 
        
                                    </EditItemTemplate> 
        
                                </telerik:GridTemplateColumn> 
        
                                <telerik:GridTemplateColumn DataField="ShipAddress"> 
        
                                    <ItemTemplate> 
        
                                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("ShipAddress") %>' /> 
        
                                    </ItemTemplate> 
        
                                    <EditItemTemplate> 
        
                                        Address: 
        
                                        <telerik:RadTextBox ID="RadTextBox2" runat="server" Text='<%# Bind("ShipName") %>' /> 
        
                                    </EditItemTemplate> 
        
                                </telerik:GridTemplateColumn> 
        
                            </Columns> 
        
                        </MasterTableView> 
        
                    </telerik:RadGrid> 
        
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"  
        
                        ConnectionString="Data Source=.\SQLSERVER;Initial Catalog=Northwind;User ID=sa;Password=********"  
        
                        ProviderName="System.Data.SqlClient"  
        
                        SelectCommand="SELECT OrderID, ShippedDate, ShipName, ShipAddress FROM Orders"  
        
                        UpdateCommand="UPDATE Orders SET ShippedDate = @ShippedDate, ShipName = @ShipName, ShipAddress = @ShipAddress WHERE (OrderID = @OrderID)"> 
        
                        <UpdateParameters> 
        
                            <asp:Parameter Name="ShippedDate" /> 
        
                            <asp:Parameter Name="ShipName" /> 
        
                            <asp:Parameter Name="ShipAddress" /> 
        
                            <asp:Parameter Name="OrderID" /> 
        
                        </UpdateParameters> 
        
                    </asp:SqlDataSource> 
        
                </form> 
        
            </body> 
        
            </html>

I hope this is helpful. If you continue to have problems or if my example did not accurately demonstrate the functionality you are trying to implement, please let me know.

Sincerely,
Kevin Babcock

answered on 21 Jul 2008, 03:51 PM

Thanks for looking at this

FORM Tempte

             ...  
        
               </Columns> 
        
                       <EditFormSettings EditFormType="Template" CaptionFormatString="Please Add Your New Employee" ColumnNumber="3" > 
        
                    <FormTemplate> 
        
                    <table style="width: 480px">  
        
                <tr> 
        
                    <td colspan="3">  
        
                        Insert New Employee Information:</td> 
        
                    <td colspan="1">  
        
                    </td> 
        
                    <td colspan="1" style="width: 7px">  
        
                    </td> 
        
                    <td colspan="1" style="width: 7px">  
        
                    </td> 
        
                </tr> 
        
                <tr> 
        
                    <td style="height: 12px" nowrap="noWrap">  
        
                        First Name</td> 
        
                    <td style="width: 8px; height: 12px;">  
        
                        <asp:TextBox ID="tbFname" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox></td>  
        
                    <td style="height: 12px" nowrap="noWrap">  
        
                        Last Name</td> 
        
                    <td style="height: 12px">  
        
                        <asp:TextBox ID="tbLname" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox></td>  
        
                    <td style="width: 7px; height: 12px;" nowrap="noWrap">  
        
                        Email:</td> 
        
                    <td style="width: 7px; height: 12px;">  
        
                        <asp:TextBox ID="tbEmail" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox></td>  
        
                </tr> 
        
                <tr> 
        
                    <td nowrap="noWrap" style="height: 19px">  
        
                        DOB (if avail)</td> 
        
                    <td style="width: 8px; height: 19px;">  
        
                        <telerik:RadDatePicker ID="RadDatePicker1" SelectedDate='<%# Bind("DOB") %>' runat="server">  
        
                        </telerik:RadDatePicker> 
        
                    </td> 
        
                    <td nowrap="noWrap" style="height: 19px">  
        
                        Telephone:</td> 
        
                    <td style="height: 19px">  
        
                        <telerik:RadMaskedTextBox ID="tbTel" runat="server" Mask="(###) ###-####" InvalidStyleDuration="100" Text='<%# Bind("Telephone") %>' TextWithLiterals="() -" Width="125px">  
        
                        </telerik:RadMaskedTextBox></td>  
        
                    <td style="width: 7px; height: 19px;" nowrap="noWrap">  
        
                        SIN</td> 
        
                    <td style="width: 7px; height: 19px;">  
        
                        <telerik:RadMaskedTextBox ID="tbSin" runat="server" Mask="###-###-###" InvalidStyleDuration="100" Text='<%# Bind("SIN") %>' TextWithLiterals="--" Width="125px">  
        
                        </telerik:RadMaskedTextBox></td>  
        
                </tr> 
        
                <tr> 
        
                    <td nowrap="noWrap" style="height: 9px">  
        
                    </td> 
        
                    <td style="width: 8px; height: 9px;">  
        
                    </td> 
        
                    <td nowrap="noWrap" style="height: 9px">  
        
                    </td> 
        
                    <td style="height: 9px">  
        
                    </td> 
        
                    <td style="width: 7px; height: 9px;" nowrap="noWrap">  
        
                    </td> 
        
                    <td style="width: 7px; height: 9px;">  
        
                    </td> 
        
                </tr> 
        
                <tr> 
        
                    <td nowrap="noWrap">  
        
                        Street</td> 
        
                    <td style="width: 8px">  
        
                        <asp:TextBox ID="tbStreet" runat="server" Text='<%# Bind("Streeet") %>'></asp:TextBox></td>  
        
                    <td nowrap="noWrap">  
        
                        City</td> 
        
                    <td> 
        
                        <asp:TextBox ID="TBCity" runat="server" Text='<%# Bind("City") %>'></asp:TextBox></td>  
        
                    <td style="width: 7px" nowrap="noWrap">  
        
                    </td> 
        
                    <td style="width: 7px">  
        
                    </td> 
        
                </tr> 
        
                <tr> 
        
                    <td nowrap="noWrap">  
        
                        Postal</td> 
        
                    <td style="width: 8px">  
        
                        <asp:TextBox ID="tbPostal" runat="server" Text='<%# Bind("Postal") %>'></asp:TextBox></td>  
        
                    <td nowrap="noWrap">  
        
                        Province</td> 
        
                    <td> 
        
                        <asp:DropDownList ID="DDProvince" runat="server"    
        
                        DataSourceID="XmlDataSource1"   
        
                        DataTextField="text" SelectedValue ='<%# Bind("Province") %>'   
        
                        DataValueField="value" > 
        
                        <asp:ListItem Selected="True" Text="Select" Value=""></asp:ListItem> 
        
                        </asp:DropDownList></td>  
        
                    <td style="width: 7px" nowrap="noWrap">  
        
                    </td> 
        
                    <td style="width: 7px">  
        
                </tr> 
        
                 <tr> 
        
                                            <td align="right" colspan="2">  
        
                                                <asp:Button ID="btnUpdate" Text='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "Insert", "Update") %>' 
        
                                                    runat="server" CommandName='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "PerformInsert", "Update")%>'>  
        
                                                </asp:Button>&nbsp;  
        
            <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" 
        
            CommandName="Cancel"></asp:Button></td>  
        
                                        </tr> 
        
            </table> 
        
                           </FormTemplate>

SQL table

    
            CREATE TABLE [ApplicantProfile] (  
        
                [KeyID] [int] IDENTITY (1, 1) NOT NULL ,  
        
                [FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [Telephone] [char] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [DOB] [smalldatetime] NULL ,  
        
                [SIN] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [Streeet] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [Province] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [Postal] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,  
        
                [TS] [datetime] NOT NULL CONSTRAINT [DF_ApplicantProfile_TS] DEFAULT (getdate()),  
        
                CONSTRAINT [PK_ApplicantProfile] PRIMARY KEY  CLUSTERED   
        
                (  
        
                    [KeyID]  
        
                )  ON [PRIMARY]   
        
            ) ON [PRIMARY]  
        
            GO

DataSource

    
            <asp:SqlDataSource ID="SqlDataSource1" runat="server"   
        
            ConnectionString="<%$ ConnectionStrings:DevConnectionString %>"   
        
            InsertCommand="INSERT INTO [ApplicantProfile] ([FirstName], [LastName], [Telephone],   
        
            [Email], [DOB], [SIN], [Streeet], [City], [Province], [Postal])   
        
            VALUES (@FirstName, @LastName, @Telephone, @Email, @DOB, @SIN, @Streeet, @City, @Province, @Postal)"   
        
            SelectCommand="SELECT * FROM [ApplicantProfile] WHERE ([LastName] = @LastName)" UpdateCommand="UPDATE [ApplicantProfile] SET [FirstName] = @FirstName, [LastName] = @LastName, [Telephone] = @Telephone, [Email] = @Email, [DOB] = @DOB, [SIN] = @SIN, [Streeet] = @Streeet, [City] = @City, [Province] = @Province, [Postal] = @Postal WHERE [KeyID] = @KeyID">  
        
                <SelectParameters> 
        
                    <asp:ControlParameter ControlID="RadTextBox1" DefaultValue="mcdell" Name="LastName" 
        
                        PropertyName="Text" Type="String" /> 
        
                </SelectParameters> 
        
                <InsertParameters> 
        
                    <asp:Parameter Name="FirstName" Type="String" /> 
        
                    <asp:Parameter Name="LastName" Type="String" /> 
        
                    <asp:Parameter Name="Telephone" Type="String" /> 
        
                    <asp:Parameter Name="Email" Type="String" /> 
        
                    <asp:Parameter Name="DOB" Type="DateTime" /> 
        
                    <asp:Parameter Name="SIN" Type="String" /> 
        
                    <asp:Parameter Name="Streeet" Type="String" /> 
        
                    <asp:Parameter Name="City" Type="String" /> 
        
                    <asp:Parameter Name="Province" Type="String" /> 
        
                    <asp:Parameter Name="Postal" Type="String" /> 
        
                </InsertParameters> 
        
            </asp:SqlDataSource>

Current Error

Specified cast is not valid.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Specified cast is not valid.

Source Error:


            Line 124:            DOB (if avail)</td>
Line 125:        <td style="width: 8px; height: 19px;">
Line 126: <telerik:RadDatePicker ID="RadDatePicker1" SelectedDate='<%# Bind("DOB") %>' runat="server">Line 127:            </telerik:RadDatePicker>
Line 128:        </td>

Source File: c:\websites\hrapps\Forms\comps\CreateApplicant.ascx Line: 126

Accepted