Testing for null value in a dataset

[Guest]

I have a dataset with a datatable that has a datacolumn of type Date. I have the following code in my application
If IsDBNull(drEmployee.DateStart) = True Then drEmployee.DateStart = Date.Parse("01-Jan-2000"
When this line runs, I get an error message "Cannot get value because it is DBNull", which of course is what I am trying to test for. The dataset was generated using VS designer from an Access database and I have not altered any settings in the XSD. The column in Access is set to "Required = no". Where am I going wrong?

 

[Guest]

I should add that I have tried setting msprop:nullValue="_null" in the XSD but then the designer comes up with an error stating "Custom tool error: Failed to generate code. System error."

 

[Andy Gaskell]

If drEmployee is strongly typed try this:
If drEmployee.IsDateStartNull() Then drEmployee.DateStart =
Date.Parse("01-Jan-2000")

If it's not try this:
If drEmployee.IsNull("DateStart") Then drEmployee.DateStart =
Date.Parse("01-Jan-2000")

I have a dataset with a datatable that has a datacolumn of type Date. I

have the following code in my application:

If IsDBNull(drEmployee.DateStart) = True Then drEmployee.DateStart = Date.Parse("01-Jan-2000")
When this line runs, I get an error message "Cannot get value because it

is DBNull", which of course is what I am trying to test for. The dataset
was generated using VS designer from an Access database and I have not
altered any settings in the XSD. The column in Access is set to "Required =
no". Where am I going wrong?