error-String was not recognized as a valid DateTime.

Question

Hello everyone, I am getting list of data from datatable with date also. List objTble_accessLog = new List (); if (dt != null && dt.Rows.Count > 0) { objTble_accessLog = dt.AsEnumerable().Select(m => new Tble_accessLog() { accessLogId = m.Field ( "accessLogId" ), FullName = m.Field string >( "FullName" ), AccessDate = m.Field string >( "AccessDate" ), Action = m.Field string >( "Action" ) }).ToList(); cnn.Close(); } return objTble_accessLog; After I am trying to bind this data to listview, then occurred date format error. Here AccessDate string datatype. How can I solve this issue? Please help me.

Nitin Sontakke · Answer

Why not keep AccessDate as DateTime type column? Always remember, once the date is converted to string, all important information is lost. NEVER covert date time to string. Convert to string ONLY WHEN you are putting it in label,textbox, etc.

Nitin Sontakke · Answer

I guess Chetan has already answered. NEVER EVER store dates as strings. Why did they created DateTime type then? You can go through all the trouble that you can for now, but change it as soon as you can. Trust me, you will keep on facing issues. Sorting, add, subtract, everything.

Abhilash J A · Answer

Hello Nitin, Chetan Sir, I have changed AccessDate as Datetime datatype inside DB. Thanks, Abhilash.J.A

Chetan Ranpariya · Answer

Any specific reason you designed that way? Is it not possible now to change it to datetime? If code is not gone to production it is good if change now coz it will save lot of time of dealing with this kind of errors. Anyways can you tell us what value you are getting from the db for that column? And how are you saving that to the db?

Abhilash J A · Answer

Yes Nitin Sir, I have already design sqllite database like that VARCHAR(50) datatype. And now all implemented code are depending upon this datatype format. So... Now, how can solve this issue sir?