Error converting data type nvarchar to datetime, any suggestion

[Jon Rista]

What is the error you are currently getting?

[Not Active]

Your correct, I forgot the IDE wasn't smart enough to figure out its a nullable type and can be null

---

only two letters away from being an asset

[Jon Rista]

You would think the C# compiler would be intelligent enough to handle that. Maybe the co/contravariance stuff in C# 4.0 will simplify such scenarios...

[suni_dotnet]

"String was not recognized as a valid DateTime." though whatever conversions i used and formats iam getting same error.

[Jon Rista]

Ok, it sounds like your input string is not in a known date time format. Can you paste a copy of the datetime string your inputting?

[suni_dotnet]

i inputed different formats 2008/02/02,02/02/2008,02/02/2008 00:00:00, by changing formatting style from / to -,2008-02-02,02-02-2008...

[Jon Rista]

As far as I can tell, all of those are valid. That would mean that something is happening to your input between the time you enter it, and the time you try to convert it. Debug your code, and look at what you are actually retrieving from your gridview, and make sure your getting the right information.