You must Sign In to post a response.

16 Aug 2018 11:40

Joined:	15/05/2013
Level:	Silver
Points:	102

Points:	2

How to set date column null in Hosting Server in asp.net

I set database date column to allowed null. I am passing DBNull.Value the null value into database using Store Procedure and its works on localhost.

but when i hosted my website on server it gives me an error
(String was not recognized as a valid DateTime.)

#769731

16 Aug 2018 12:31

Joined:	09/01/2018
Level:	Bronze
Points:	19

Points:	0

For deep knowledge, you can visit at- http://www.traininginlucknow.in/best-.net-training-in-Lucknow.html

#769736

17 Aug 2018 14:50

Joined:	28/09/2005
Level:	Gold
Points:	637

Points:	2

i think it should work same in all environment s but not sure of exception coming on hosted machine. it is always advisable to keep the date parameter in stored proc as optional by assigning NULL.

Thanks!
B.Ramana Reddy

Submit New Thread

Return to Return to Discussion Forum

How to set date column null in Hosting Server in asp.net

About dotnetspider.com

Quick Links

General

Services