conversion of char data type to datetime data type resulted in out of range datetime value Error in VB.NET [modified]

[samsonx]

Hi My code displays the error in top

cmd = New SqlCommand("spStudent", con1)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@EnterDate", SqlDbType.DateTime, 8))
cmd.Parameters("@EnterDate").Value = "01/09/2009"
cmd.CommandTimeout = 1800
cmd.ExecuteNonQuery()
Sda = New SqlDataAdapter(cmd)
Sda.Fill(dt)

How to resolve this problem... please help

Regards, Samson

modified on Friday, January 9, 2009 5:35 AM

[Jay Royall]

Try:

cmd.Parameters("@EnterDate").Value = New Date(1, 9, 2009)

[samsonx]

cmd.Parameters("@EnterDate").Value = New Date(1, 9, 2009) This one is Date(year, month, Date) Format. But my Format is MM/dd/yyyy.... Please help further

With Regards, Samson

[Jay Royall]

Ah I see, sorry, I misread your post. Unfortuanately I can't offer any more help, sorry.

[Lost User]

samsonx wrote:

cmd.Parameters("@EnterDate").Value = "01/09/2009"

Convert "01/09/2009" to dateTime variable and then assign the value to parameter. The format of DateTime does not matter during the Saving of information.

[Guffa]

That means that the database doesn't use the same date format that you use, and is parsing it to a completely different date, like perhaps '0001-09-09'. This is outside the range of dates that the datetime type in the database can handle, hence that specific error message. Parse the string into a DateTime value before you put it in the parameter: cmd.Parameters("@EnterDate").Value = DateTime.ParseExact("01/09/2009", "MM/dd/yyyy", CultureInfo.InvariantCulture)

Despite everything, the person most likely to be fooling you next is yourself.

[Lost User]

Try date format with cmd.Parameters("@EnterDate").Value = cdate("#01/09/2009#")

mailto: anubhava.prodata@gmail.com