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

How to format Time in GridDateTimeColumn?

14 Answers 3188 Views

Grid

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

14 Answers, 1 is accepted

answered on 16 Jan 2014, 05:24 PM

I got the exception "Input string was not in a correct format."
This is how I query data:

DataTable dt = new DataTable();

using (SqlConnection con = new SqlConnection(connectionString))

{

using (SqlCommand cmd = new SqlCommand("usp_GetData", con))

{

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@ExecutionDate", RadSelectToDoDate.SelectedDate);

using (SqlDataAdapter sda = new SqlDataAdapter())

{

cmd.Connection = con;

con.Open();

sda.SelectCommand = cmd;

sda.Fill(dt);

return dt;

}

Regards,
Oleg

answered on 17 Jan 2014, 09:53 AM

Hi Oleg,

Make sure that your column is of DateTime datatype. Below is a sample code snippet that i tried to fill the radgrid with the value selected from a dropdownlist. Please provide your full code snippet if this doesn't help:

ASPX:

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"

DataTextFormatString="{0:t}" DataTextField="OrderDate" DataValueField="OrderDate"

AutoPostBack="true" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">

</asp:DropDownList>

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" AllowPaging="true"

AllowMultiRowSelection="true" OnNeedDataSource="RadGrid1_NeedDataSource">

<MasterTableView>

<Columns>

<telerik:GridDateTimeColumn DataField="OrderDate" FilterControlAltText="Filter OrderDate column"

DataFormatString="{0:t}" HeaderText="OrderDate Time" UniqueName="OrderDate" PickerType="TimePicker">

</telerik:GridDateTimeColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

C#:

bool IsSelected = false;

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

cmd.Connection = conn;

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "StoredProcedure2";

if (IsSelected)

{

cmd.Parameters.AddWithValue("@OrderDate", DropDownList1.SelectedItem.Text);

}

else

{

cmd.Parameters.AddWithValue("@OrderDate", 4);

}

DataSet dt = new DataSet();

SqlDataAdapter adp = new SqlDataAdapter();

conn.Open();

adp.SelectCommand = cmd;

adp.Fill(dt);

RadGrid1.DataSource = dt;

conn.Close();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

IsSelected = true;

RadGrid1.Rebind();

}

Thanks,
Shinu

answered on 09 Jun 2016, 08:53 AM

Hi ,

<telerik:GridDateTimeColumn CurrentFilterFunction="GreaterThanOrEqualTo" HeaderText="Start_Time" DataField="Start_Time" DataType="System.DateTime" EditDataFormatString="HH:mm:ss" FilterControlAltText="Filter Start_Time column" FilterDateFormat="HH:mm:ss" PickerType="TimePicker" UniqueName="Shift_Start_Time">
</telerik:GridDateTimeColumn>

SQL database binding with entity framework, I have start_time column with datatype= time(7) , if I use datetime as datatype I can able to edit and save, but when I use system.timespan in radgrid or time(7)in database table. I am facing this issue.

I want to know for inserting and updating a time 24hrs format what can I do, using radgrid and entity framework.

answered on 09 Jun 2016, 11:10 AM

Thanks vasil for your support,

I tried that demo link which you have sent. but while updating and adding new record I'm facing issue.

find the codes below,

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" DataSourceID="EntityDataSource1">

<GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>

<ExportSettings ExportOnlyData="True" IgnorePaging="True">

</ExportSettings>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="EntityDataSource1" EditMode="InPlace" CommandItemDisplay="Top">

<CommandItemSettings ShowExportToExcelButton="True" />

<Columns>

<telerik:GridBoundColumn DataField="ID" DataType="System.Int64" FilterControlAltText="Filter ID column" HeaderText="ID" ReadOnly="True" SortExpression="ID" UniqueName="ID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Shift_Name" FilterControlAltText="Filter Shift_Name column" HeaderText="Shift_Name" SortExpression="Shift_Name" UniqueName="Shift_Name">

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn CurrentFilterFunction="GreaterThanOrEqualTo" HeaderText="Start_Time" DataField="Start_Time" DataType="System.DateTime" EditDataFormatString="HH:mm:ss" FilterControlAltText="Filter Start_Time column" FilterDateFormat="HH:mm:ss" PickerType="TimePicker" UniqueName="Shift_Start_Time">

                    </telerik:GridDateTimeColumn>

                      <telerik:GridDateTimeColumn CurrentFilterFunction="GreaterThanOrEqualTo" HeaderText="End_Time" DataField="End_Time" DataType="System.DateTime" EditDataFormatString="HH:mm:ss" FilterControlAltText="Filter End_Time column" FilterDateFormat="HH:mm:ss" PickerType="TimePicker" UniqueName="End_Time">

                    </telerik:GridDateTimeColumn>

<telerik:GridCheckBoxColumn DataField="IsActive" FilterControlAltText="Filter IsActive column" HeaderText="IsActive" SortExpression="IsActive" UniqueName="IsActive">

</telerik:GridCheckBoxColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=dbEntities" DefaultContainerName="dbEntities" EnableDelete="True" EnableFlattening="False" EnableInsert="True" EnableUpdate="True" EntitySetName="Shift" EntityTypeFilter="Shift">

</asp:EntityDataSource>

<telerik:RadScriptManager ID="RadScriptManager1" Runat="server">

</telerik:RadScriptManager>

I have datatype for start_time and end_time as time(7) in my database. Here If I click to edit it is showing Error while setting property 'Shift_End_Time': 'Cannot convert the value of parameter 'Shift_End_Time' to the type 'System.TimeSpan'.'

Also I want to add other column values in the same record while I am editing( like last_updated_time),but I don't want that column to be displayed in grid, by codebehind/some solutions to save the other columns in database,just to be happen same while updating and adding new records it should automatically save last_updated_time.

Thanks,

Archie

answered on 09 Jun 2016, 11:36 AM

Hi Archana,

Did you tried the TemplateColumn instead of DateTimeColumn:

<telerik:GridTemplateColumn HeaderText="Additional times" UniqueName="TemplateColumn1">

<ItemTemplate>

<asp:Label runat="server" ID="time" Text='<%# Eval("Shift_End_Time") %>'>

</asp:Label>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadTimePicker UseTimeSpanForBinding="true" ID="picker2" runat="server" DbSelectedDate='<%# Bind("Shift_End_Time") %>' >

</telerik:RadTimePicker>

</EditItemTemplate>

</telerik:GridTemplateColumn>

I have also noticed that you call the column "Start_Time" and "Shift_Start_Time", make sure it is addressed correctly.

Regards,
Vasil
Telerik

Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.

answered on 13 Jun 2016, 07:33 AM

Thanks Vasil, This works Perfectly!!

I'm facing one more issue, could you please help me out!!!

1) I want to insert created datetime and last updated datetime in entity database table when ever I insert or update a record??

but this columns I don't want to be visible in radgrid. It should be done in code behind automatically when I insert a new record/ update a record.

2) Dropdown with manual binding is not allowing me to insert/update, attached my code snippets below,

<telerik:GridTemplateColumn UniqueName="CheckBoxCol1" HeaderText="Reason_Type" >

<ItemTemplate>

<%# DataBinder.Eval(Container.DataItem, "Reason_Type")%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="RadReasonType" Runat="server">

<Items>

<telerik:RadComboBoxItem Value="Downtime" Text="Downtime" />

<telerik:RadComboBoxItem Value="Rework" Text="Rework" />

<telerik:RadComboBoxItem Value="Rejection" Text="Rejection" />

</Items>

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

Let me know,where I'm wrong and what to change further...

Thanks in advance,

Archie