ASP.Net Error: Conversion failed when converting date and/or time from character string

indradeo

SOLVED CLOSED ACTIVE ANSWERED
User: indradeo
Posted: on Jan 04, 2022 12:23 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3105

Server Error in '/' Application.

Conversion failed when converting date and/or time from character string.

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.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string. Source Error:

Line 75:             SqlCommand cmd = new SqlCommand("SELECT  COUNT (STATUS_ID)  FROM comp_box where CLOSING_DATE='GETDATE()'", con);
Line 76:            // SqlCommand cmd = new SqlCommand("SELECT  COUNT (STATUS_ID)  FROM comp_box1 where STATUS_ID='Open' and  COMP_LODGE_DATE='" + Textbox1.Text + "'", con);
Line 77:             count = Convert.ToInt32(cmd.ExecuteScalar());
Line 78:             cmd.Parameters.AddWithValue("@STATUS_ID", STATUS_ID);
Line 79:             Label1.Text = "Open: " + Convert.ToString(cmd.ExecuteScalar());

Source File: c:\Users\Administrator\Documents\Visual Studio 2012\Projects\OCMS_rpt_sms_snd\gridview_filter\gridview_filter\WebForm1.aspx.cs Line: 77 Stack Trace:

[SqlException (0x80131904): Conversion failed when converting date and/or time from character string.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2582782
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6033430
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4291
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +242
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +275
   System.Data.SqlClient.SqlDataReader.Read() +35
   System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +42
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +283
   gridview_filter.WebForm1.display1() in c:\Users\Administrator\Documents\Visual Studio 2012\Projects\OCMS_rpt_sms_snd\gridview_filter\gridview_filter\WebForm1.aspx.cs:77
   gridview_filter.WebForm1.Page_Load(Object sender, EventArgs e) in c:\Users\Administrator\Documents\Visual Studio 2012\Projects\OCMS_rpt_sms_snd\gridview_filter\gridview_filter\WebForm1.aspx.cs:30
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 9

Reply
ANSWER
User: arjunv
Replied: on Jan 06, 2022 05:44 AM
Report

indradeo says:

SqlCommand cmd = new SqlCommand("SELECT  COUNT (STATUS_ID)  FROM comp_box where CLOSING_DATE='GETDATE()'", con);

Replace with below code. Remove single quote from GetData function.

SqlCommand cmd = new SqlCommand("SELECT  COUNT (STATUS_ID)  FROM comp_box where CLOSING_DATE=GETDATE()", con);

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net Error: Conversion failed when converting date and/or time from character string

Server Error in '/' Application.

Conversion failed when converting date and/or time from character string.

Company

Explore

Follow us

Contact Us