C# Date functions

[Branislav Vidovic]

Hi, I am hving troubles with inserting Date in my database. I have a field in my table in the databse whicih is Date/Time format. For example if I want to insert s specific date (let's say it is 19th july 2007) i need to insert 19.7.2007. Now that is not the problem. I have a string which is formated correctly. It goes as "19.7.2007". But when I insert it to database it reports error, because the dataset for that table needs a varaiable that is Date format and not a string. In visual Basic.NET i used Cdate function for converting strings in dates. What functions should I use in C#?

[Luc Pattyn]

Hi, .NET has a DateTime struct that holds both date and time information. And that is what everyone seems to be using to insert date information into a database (unless the field is defined as a string that is). :)

Luc Pattyn

---

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }

---

[Mike Dimmick]

DateTime.Parse, DateTime.ParseExact, DateTime.TryParse, DateTime.TryParseExact. If you know the format, prefer (Try)ParseExact. Use the Try version if you would prefer to test whether the format matches rather than getting a FormatException exception.

Stability. What an interesting concept. -- Chris Maunder