 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / October 2005convert 01/01/0001 to empty string
I am using ObjectDataSource bind to DetailView which will contain one of the column with the value type is date. whenver the value of this column is empty . then it will be display the date in the format ( 01/01/0001), How can I convert it to empty string or just string? Thank you very much tan DateTime type Don't Allow null or empty string.. the only way i found to workaround this is to convert it to string and check if it's 01/01/0001.. I did myDatetime Class to do this for me when i use ToString() , ToShortDateString(),etc... >I am using ObjectDataSource bind to DetailView which will contain one of >the column with the value type is date. whenver the value of this column is [quoted text clipped - 4 lines] > > tan create class, inherit from DateTime and overload ToString() method >I am using ObjectDataSource bind to DetailView which will contain one of >the column with the value type is date. whenver the value of this column is [quoted text clipped - 4 lines] > > tan I can not inherit from DateTime, in .net 2.0 is a sealed class, any suggestions? Tan > create class, inherit from DateTime and overload ToString() method > [quoted text clipped - 6 lines] >> >> tan If you are using .NET 2.0 you can use System.Nullable<T> Look up System.Nullable in the help file. >I can not inherit from DateTime, in .net 2.0 is a sealed class, any >suggestions? [quoted text clipped - 10 lines] >>> >>> tan Otis Isn't it simpler to assume that "01/01/0001" is a default value in the table in question, and that changing that default value to <null> would simplify the checking/text assignment task ? Then, checking for IsDBNull / System.DbNull is simple, or use the faster : bool isNull = (dr[ordinal]==System.DBNull.Value); Juan T. Llibre, ASP.NET MVP ASP.NET FAQ : http://asp.net.do/faq/ Foros de ASP.NET en Español : http://asp.net.do/foros/ ====================================== > If you are using .NET 2.0 you can use System.Nullable<T> > Look up System.Nullable in the help file. >>I can not inherit from DateTime, in .net 2.0 is a sealed class, any >>suggestions? [quoted text clipped - 10 lines] >>>> >>>> tan Maybe 01/01/0001 is a default value assigned in the table ? Check the table's design and see if it is a default value. If it is a default value, change the default value to null or empty. Juan T. Llibre, ASP.NET MVP ASP.NET FAQ : http://asp.net.do/faq/ Foros de ASP.NET en Español : http://asp.net.do/foros/ ====================================== >I am using ObjectDataSource bind to DetailView which will contain one of the column with >the value type is date. whenver the value of this column is empty . then it will be [quoted text clipped - 4 lines] > > tan Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.