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

[Solved] GridDateTimeColumn with InPlace edit

9 Answers 702 Views

Grid

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

Eric asked on 26 Dec 2007, 04:36 AM

My grid is bound to my class. One of the fields is a date which I bind to a GridDateTimeColumn.

Using in place edit when I attempt to add a new record I keep getting the error

The string was not recognized as a valid DateTime. ---> System.FormatException: The string was not recognized as a valid DateTime.

The code in my aspx page:

<telerik:GridDateTimeColumn
                DataField="StartDate"
                HeaderText="Start Date"
                UniqueName="Start Date"
                PickerType="DatePicker" />

Just checking to see if there is something I am missing. I would like the date value to default to the current date/time. Do I need to handle an event for the grid such as the edit item being created and default the editor?

9 Answers, 1 is accepted

answered on 22 Feb 2008, 01:38 AM

I have the same problem using this code:

    
              <telerik:GridDateTimeColumn UniqueName="Bezahlt" PickerType="DatePicker" HeaderText="Bezahlt" DataFormatString="{0:d}" DataField="Wann">  
        
               <ItemStyle Width="120px" /> 
        
             </telerik:GridDateTimeColumn>

(I'm using the German UICulture)

I think with "Prometheus" you should simplify the whole thing, without the need to construct a special template column.

answered on 15 May 2008, 07:38 AM

Hello Daniel,

Can you please verify that the relevant column in the underlying data source is of type DateTime? I tried to recreate the issue in a sample project very similar to this integration example but without much success. Can it be that you are attempting to set initial date selected in the editor (wiring the ItemCommand event as shown here) and the value you pass is not valid date time?

The answers to these questions can lead us to the core of the problem to eliminate it accordingly.

Kind regards,
Stephen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

answered on 20 May 2008, 02:33 PM

I've figured it out. Its an issue if the data source column name has a space in it.

Take for instance this table:

    
            CREATE TABLE [dbo].[TelerikTest]( 
        
                [ID] [int] IDENTITY(1,1) NOT NULL, 
        
                [DateTime Column] [smalldatetime] NOT NULL, 
        
             CONSTRAINT [PK_TelerikTest] PRIMARY KEY CLUSTERED  
        
            ( 
        
                [ID] ASC 
        
            )WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] 
        
            ) ON [PRIMARY]

With this webpage:

    
            <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> 
        
            <%@ Register assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI" tagprefix="asp" %> 
        
            <%@ Register assembly="Telerik.Web.UI, Version=2007.3.1314.20, Culture=neutral, PublicKeyToken=121fae78165ba3d4" 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"> 
        
                <div> 
        
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"  
        
                        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"  
        
                        SelectCommand="SELECT [ID], [DateTime Column] FROM [TelerikTest]"> 
        
                    </asp:SqlDataSource> 
        
                </div> 
        
                <asp:ScriptManager ID="ScriptManager1" runat="server"> 
        
                </asp:ScriptManager> 
        
                <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"  
        
                    DataSourceID="SqlDataSource1" GridLines="None"> 
        
            <ExportSettings> 
        
            <Pdf PaperSize="Letter" FontType="Subset"></Pdf> 
        
            <Excel Format="Html"></Excel> 
        
            </ExportSettings> 
        
            <MasterTableView CurrentResetPageIndexAction="SetPageIndexToFirst" Dir="LTR"  
        
                        Frame="Border" TableLayout="Auto" CommandItemDisplay="Top" datakeynames="ID"  
        
                        datasourceid="SqlDataSource1"> 
        
            <RowIndicatorColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType" Visible="False"> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </RowIndicatorColumn> 
        
            <ExpandCollapseColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType" Visible="False" Resizable="False"> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </ExpandCollapseColumn> 
        
                <Columns> 
        
                    <telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="ID"  
        
                        DataType="System.Int32" FilterListOptions="VaryByDataType"  
        
                        ForceExtractValue="None" HeaderText="ID" ReadOnly="True" SortExpression="ID"  
        
                        UniqueName="ID"> 
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridDateTimeColumn DataField="[DateTime Column]" PickerType="TimePicker"  
        
                        UniqueName="TimeIn" HeaderText="Time In" > 
        
                        </telerik:GridDateTimeColumn> 
        
                </Columns> 
        
            <EditFormSettings> 
        
            <EditColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType"></EditColumn> 
        
            </EditFormSettings> 
        
            </MasterTableView> 
        
                </telerik:RadGrid> 
        
                </form> 
        
            </body> 
        
            </html>

This webpage, as is, will give you the error when you click on Add New Record.

If, you change the Data Source to

    
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"  
        
                        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"  
        
                        SelectCommand="SELECT [ID], [DateTime Column] as DateTime_Column FROM [TelerikTest]"> 
        
                    </asp:SqlDataSource>

and change the grid's definition accordingly, there isn't a problem.