save 0000-00-00 date in mysql

[VBcielle]

can you help me?
below is the value for my date when it is saved ... my problem is when i save the null value ..error says argument prompt cannot be converted to string..

how about if i'll save
dim s as date ="0000-00-00"
tblEmpCRow("dateterminated") =s
instead of
tblEmpCRow("dateterminated") = DBNull.Value

      
       If dtpTerm.Checked Then
            tblEmpCRow("dateterminated") = dtpTerm.Value
            txtTerm.Text = dtpTerm.Text
        Else
            
            tblEmpCRow("dateterminated") = DBNull.Value
            txtTerm.Text = ""
        End If