In my front end application date format as dd-mm-yyyy when storing in sql server it shows error like error converting varchar to datetime.

Check in your sp whether the parameter datatype is Varchar or DateTime. if it is varchar change it to column datatype (datetime or date). But, before that paste what you have done.

2 solutions

Solution 1

Don't convert the date to a string when creating your SQL - pass it in a parameterised query and pass the date in.

e.g. (snippet)

VB

Dim sql As String = "SELECT [filename] FROM [table] WHERE [filedate] = @FileDate"

Dim cmd As New SqlCommand(conn, sql)

cmd.Parameters.AddWithValue("@FileDate", Date.Now)

Posted 17-Jun-14 1:53am

Duncan Edwards Jones

Comments

vanarajranjit 17-Jun-14 23:38pm

I used like that
Command.parameters. Add("@date",SqlDbType.VarChar.varchar).Value=txtname.Text.

Duncan Edwards Jones 7-Jul-14 4:50am

But a date is not a varchar - if you have a date and the parameter type on the table/database is a date don't convert it back and forth through a string.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thava Rajan · Accepted Answer · 2014-06-17T20:02:00

i Think this will be enough for as a solution to your problem

txtdate.text =format(now,"dd-MMM-yyyy")

as per your previous solution comment
your actual problem is you need to Send it as a varchar
you need to pass it as a datetime,

Command.parameters. Add("@date",SqlDbType.Datetime).Value=Convert.ToDateTime(txtname.Text)

if you have still problem To debug this code put a break point on the line you mention and see what value is set it in to the parameter