Error During update datagrid

[123ASP]

hi, I have a datagrid that contain a date field. if the field has a adate before I update the row, it make the update, but if a edit a record that has no date in the column field, I get the following error, any idea how to fix it.

thanks Al
Cast from type 'DBNull' to type 'Date' is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Cast from type 'DBNull' to type 'Date' is not valid.

Source Error:
Line 64: vinitialcontact =dr("initialcontact")
Line 65: vfollowup= dr("followup")
Line 66:vnextfollowupdate = dr("nextfollowupdate")
Line 67:end while

 

[Isadore]

123: My initial guess when I read this a day or two ago was that you would have to, in code behind, prevent the NULL from being read in the first place, some type of Not DBIsNull type of statement. Any luck on this problem?

 

[mulema]

Hi! 123ASP,
Did you get a solution to your problem.
I am facing the same issue, and would like to know how you got it working.
Thanks

 

[123ASP]

Actually, I was in a car accident and was hurt. Did not have the time to fix the issue. If you already have the answer,I would appreciate to share it with me.
thanks

Al