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");