Unhandle exception error

Question

Hi kindly help me out

System.FormatException: Failed to convert parameter value from a String to a DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Data.OleDb.OleDbParameter.CoerceValue(Object value, NativeDBType destinationType)
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbParameter.CoerceValue(Object value, NativeDBType destinationType)
at System.Data.OleDb.OleDbParameter.BindParameter(Int32 index, Bindings bindings)
at System.Data.OleDb.OleDbCommand.CreateAccessor()
at System.Data.OleDb.OleDbCommand.InitializeCommand(CommandBehavior behavior, Boolean throwifnotsupported)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at BO_upload.Form1.button2_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
BO_upload
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Default%20Company%20Name/BO/BO_upload.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Dhanik Sahni · Answer

in your code you can do the following while getting value from DateTimePicker control: string theDate = dateTimePicker1 . Value . ToShortDateString (); or if you'd like to specify the format of the date: string theDate = dateTimePicker1 . Value . ToString ( yyyy-MM-dd );

Dhanik Sahni · Answer

Welcome Praveen.

praveen kumar · Answer

Thank you Dhanik Sahni

praveen kumar · Answer

con.ConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\sharp1\sharp.mdb; con.Open(); OleDbCommand cmd = new OleDbCommand(INSERT into ASSIGN (TR_DATEDVIDTLENCLIENTMTIDPOSTFLAGdictatorid) + values(@TR_DATE@DVI@DTLEN@CLIENT@MTID@POST@FLAG@dictatorid)  con); cmd.Parameters.Add(@TR_DATE OleDbType.Date).Value = dateTimePicker1.Text; cmd.Parameters.Add(@DVI OleDbType.Char 50).Value = textBox1.Text; cmd.Parameters.Add(@DTLEN OleDbType.Char 10).Value = textBox4.Text; cmd.Parameters.Add(@CLIENT OleDbType.Char 50).Value = BO; cmd.Parameters.Add(@MTID OleDbType.Char 50).Value = textBox2.Text; cmd.Parameters.Add(@POST OleDbType.Char 50).Value = M; // cmd.Parameters.Add(@M_TIMET OleDbType.DBTime).Value = time; // cmd.Parameters.Add(@P_TIME OleDbType.DBTime).Value = time; cmd.Parameters.Add(@FLAG OleDbType.Char 50).Value = B; cmd.Parameters.Add(@dictatorid OleDbType.Char 50).Value = textBox3.Text; cmd.ExecuteNonQuery(); con.Close(); con.Open(); OleDbCommand cmd1 = new OleDbCommand(INSERT into LC(MTIDDVITRDATELCRemark) + values(@MTID@DVI@TRDATE@LC@Remark) con); cmd1.Parameters.Add(@MTID OleDbType.Char 50).Value = textBox2.Text; cmd1.Parameters.Add(@DVI OleDbType.Char 50).Value = textBox1.Text; cmd1.Parameters.Add(@TRDATE OleDbType.Date).Value = dateTimePicker1.Text; cmd1.Parameters.Add(@LC OleDbType.Decimal).Value = label7.Text; cmd1.Parameters.Add(@Remark OleDbType.Char 50).Value = BO; cmd1.ExecuteNonQuery(); con.Close();

Rajeesh Menoth · Answer

Hi CultureInfo : It's Provides information about a specific culture. The information includes the names for the culture the writing system the calendar used the sort order of strings and formatting for dates and numbers. using System.Globalization; //namespace DateTime From = DateTime.ParseExact(txtFrom.Text dd/MM/yyyy  CultureInfo.InvariantCulture); Check my codesnippet in C# Corner : http://www.c-sharpcorner.com/code/1459/string-was-not-recognized-as-a-valid-datetime.aspx

Manas Mohapatra · Answer

Hi Praveen It looks like there is wrong format with datetime. Means the string value you are converting is valid to covert it to DateTime object. Go through below link: http://www.c-sharpcorner.com/UploadFile/manas1/string-to-datetime-conversion-in-C-Sharp/ Secondly if you are not able to resolve the problem then provide the value string value which you are try to convert.

Dhanik Sahni · Answer

Please share code so that we will answer this. Normally this kind of error thrown when you are getting wrong string format while converting to date time.