how to solve this error? LogInTime = A.Field ( "LogInTime" ) == null ? "UnKnown" : A.Field ( "LogInTime" ), " Specified cast is not valid "

It is clear that you cannot possibly assign "Unknown" to the variable of datatype DateTime. So, on left hand side you should have a variable of data type String and you should assign formatted date time to it. Something as follows, just as an example: String loginTime = A.Field ("LoginTime") == null ? "Unknown" : A.Field ("LoginTime").ToString("dd-MMM-yyyy"); Hope it helps!

Prakash you are correct ,but i think data is not coming correctly,means parse problem.

If you want LogInTime variable as DateTime object then use: LogInTime = A.Field ("LogInTime") == null ? DateTime.Min : DateTime.ParseExact(A.Field ("LogInTime"), "mm/dd/yyyy", null); else LogInTime = A.Field ("LogInTime") == null ? "Unknown" : A.Field ("LogInTime")

Hi Abhilash, Check DBNull.Value instead of Null

Abilash what output your getting can u show me?

Actually I want, if " LogInTime " is null return " unknown " Here LogInTime is datetime format in mysql server.

Answers

C# - Specified cast is not valid in Datetime

Abhilash J A

10.6k

how to solve this error?

LogInTime = A.Field<DateTime>("LogInTime") == null ? "UnKnown" : A.Field<DateTime>("LogInTime"),

"Specified cast is not valid"

Answers (6)

Next Recommended Forum

Age Comparison - Cinema Admittance Programme

Get already coloured word using word addin in C#

Leaderboard

View all

Rodrigo Diaz

Magnus Mårtensson

Tuhin Paul

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

186

13k

10.5k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

288.8k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Ravi Prajapati

Lalji Dhameliya

Saksham Gupta

Gajendra Jangid

Amirthathasan Jothikumar

Forum Statistics

Please welcome our newest member Amapola karlen.
3,077,165 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 5 new threads, 19 new posts, and 169 new users.
In last week, the most popular thread is 'Object reference not set to an instance of the Object.'.