Date
-
I have a textbox which represent date, but sometime it will be empty.I want to send it as empty to the database. How can I do it
If the string is empty, pass DBNull.Value and make the column nullable in the DB. Use DateTime.TryParse to make sure the string you're passed in is a valid date. The other option is to store it as a string, but of course you can't do anything with it, then.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
If the string is empty, pass DBNull.Value and make the column nullable in the DB. Use DateTime.TryParse to make sure the string you're passed in is a valid date. The other option is to store it as a string, but of course you can't do anything with it, then.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Another option would be to store a default date which is meaningless but avoids a null value in the DB (something I try to avoid if at all possible). e.g 01/01/1900