Split '. Empty; if dbTime. IndexOf '. ToString Convert. Wednesday, April 2, PM. User posted Try changing your commandtext line to this: AttendanceDataSource. User posted Thanks alot, It worked fine but i must ask why did we convert the value to a string in the if statement? Asked 9 years ago. Active 6 months ago. Viewed k times. I mean, if there is no value inserted, the default value should be null, empty, etc. Improve this question.
David Refoua 3, 1 1 gold badge 28 28 silver badges 51 51 bronze badges. Ozi Oz Ozi Oz 1 1 gold badge 4 4 silver badges 12 12 bronze badges. Add a comment. Active Oldest Votes. DateTimeColumn DateTime, Improve this answer.
If you would like to contact Tim, please e-mail him at chapman. TechRepublic's free SQL Server newsletter, delivered each Tuesday, contains hands-on tips that will help you become more adept with this powerful relational database management system. Automatically subscribe today! The value that you are substituting must be of the same data type as the field that may contain the NULL value.
Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble. Show Comments. Selecting a language below will dynamically change the complete page content to that language. KB Articles: KB Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
0コメント