Converting TextBox.Text to DateTime for instert into SQL Table

Question

Hi I've got a converting problem. I'am trying to convert a text value in a TextBox to DateTime format without the last time information like 2007-06-26 00:00:00 . I just like to insert 2007-06-26 (Swedish time format). I've tryed: string str = Convert .ToDateTime(tbStart.Text).ToShortDateString; But got an error. Thanks in advance

Larry Hojer · Answer

The application is only to be used by companies in Sweden so I don't think it will be a problem. Thanks for your answer again and will consider the culture issue another time when appropriate.

Alan · Answer

That's fine Larry as long as you don't mind the date being displayed in the user's culture rather than the Swedish culture. I thought at first that you always wanted it to be stored in the Swedish culture regardless of the current culture (hence my suggested solution) but now I read it again I think the problem may simply have been that you were using the ToShortDateString() method as though it was a property and hence the original error :)

Larry Hojer · Answer

Hi again I think I've solved the problem. I found a way to format the date type från SQL when populating the TextBox tbStart.Text: this .tbStart.Text = reader.GetDateTime(reader.GetOrdinal( StartDate )).ToShortDateString(); Is this a good way to do this?

Larry Hojer · Answer

Hi Alan thanks for for your answer. Maybe I wasn't detailed enough in my description becuse I still have the same problem when I read data from database. I used your solution with some modifications when adding or updating the database: values.Add( Convert .ToDateTime(tbStart.Text).ToString( yyyy-MM-dd )); And it appears to work. When I read from the database I got this back: 2007-06-19 00:00:00. The data type in the data column is datetime. How can I solve this?

Alan · Answer

This should do it: string str = Convert .ToDateTime(tbStart.Text).ToString(yyyy-MM-dd);