An empty string is not the same as a null. You need to check for this condition and send a DbNull.Value to the database instead.
On 8/10/05, Robert Bilderbach <[EMAIL PROTECTED]> wrote: > just getting started with the bound controls, I have a formview bound > directly to sqlserver. The update works fine as long as I fill out > all fields. I have a closedate field that I want to leave blank ntil > the job is complete, but if I leave it blank I get the following error > on the update: > > String was not recognized as a valid DateTime > > The field allows nulls....what am I doing wrong here? > > Thanks in advance! > -R > > > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hmpsqeg/M=362335.6886445.7839731.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123727731/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
