Error In Viewing Datetime Value In Gridview Itemtemplate

Hi!



I am trying to show the StartTime and the EndTime in one column.



Start - End

9:00:00 - 10:00:00



I tried the following code, but it is returning an error.




<asp:TemplateField HeaderText="Start - End">

<ItemTemplate>

<asp:Literal ID="litTimeRange" runat="server" Text='<%# Eval("timeRange") %>'>

</asp:Literal>

</ItemTemplate>

</asp:TemplateField>



<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ScheduleConnectionString %>"

SelectCommand="SELECT ID, ([StartTime]+ ' - ' + [EndTime]) as timeRange, CompanyName, Purpose, AccountManager, Presenter, ColorCode, Status, Comments FROM Demo_Theatre_DB WHERE (StartTime &gt;= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)) AND (StartTime &lt;= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 1))">

</asp:SqlDataSource>





The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.



[SqlException (0x80131904): The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1932

System.Data.SqlClient.SqlDataReader.HasMoreRows() +150

System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +212

System.Data.SqlClient.SqlDataReader.Read() +9

System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +153

System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153

System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +170

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83

System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770

System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17

System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149

System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70

System.Web.UI.WebControls.GridView.DataBind() +4

System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82

System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69

System.Web.UI.Control.EnsureChildControls() +87

System.Web.UI.Control.PreRenderRecursiveInternal() +50

System.Web.UI.Control.PreRenderRecursiveInternal() +170

System.Web.UI.Control.PreRenderRecursiveInternal() +170

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041




Your will be appreciated.



Thanks!