Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: Help with OLEDBType.Date


Message #1 by "Yu, Kevin" <kyu@N...> on Fri, 12 Oct 2001 17:22:13 -0400

I have a problem getting this data format right from a string "21/10/01", I

try datavalue(), but it won't let me 

do it.  strCDate.text is 21/10/01.

my statement looks like this



MyCommand.Parameters.Add(New OLEDBParameter("@CDate", OLEDbType.DATE))

MyCommand.Parameters("@CDate").Value = strCDate.text



error message: System.FormatException: String was not recognized as a valid

DateTime.







Kevin Yu

system.data.oledb

coop student

Western Research Center - Natural Resource Canada

email: kyu@n...

phone:(780) 987-8611




  Return to Index