Error converting datetime to string

Question

I am getting an error when I attempt to display a datetime value in a textbox:

My code is:

txtStartDate.Text = rdrGetUserInfo.IsDBNull(14) ? String.Empty : Convert.ToString(rdrGetUserInfo.GetString(14));

The error message is: ex.Message = "Unable to cast object of type 'System.DateTime' to type 'System.String'."

Any ideas how I can resolve this?

score 7 · Accepted Answer · answered Mar 24 '10 at 15:32

7

Try:

txtStartDate.Text = rdrGetUserInfo.IsDBNull(14) ? String.Empty : Convert.ToString(rdrGetUserInfo.GetDateTime(14).ToString());

answered Mar 24 '10 at 15:32

Leniel Maccaferri

Do you still need the `Convert.ToString()`? – Joel Mar 24 '10 at 15:35
Maybe no... I don't have a compiler right here. I think you can convert a DateTime to String directly with Convert.ToString() if it has a method overload for DateTime. – Leniel Maccaferri Mar 24 '10 at 15:39
Thanks that works. Though how do I get just the date, not the date and time? – user279521 Mar 24 '10 at 15:41
Try to ShortDateString() this way: rdrGetUserInfo.GetDateTime(14).ToShortDateString() – Leniel Maccaferri Mar 24 '10 at 15:41

1 Answers1