Update a value in your dataset with NULL.

[John]

My question is:
How do I update a value in my dataset to Null.
Example: I want to ovverride the Customers name with NULL.

So then I can use this:
drI("PropInspectionDate") = TextBox22.Text

Instead of having to do this:
If Not (TextBox22.Text) Is DbNull.Value Then drI("PropInspectionDate") = TextBox22.Text

Please if you can advice. Thank you

[Administrator]

just do this:

If Not (TextBox22.Text) Is DbNull.Value Then
drI("PropInspectionDate") = TextBox22.Text
else
drI("PropInspectionDate") = DbNull.Value
End if

> My question is:
> How do I update a value in my dataset to Null.
> Example: I want to ovverride the Customers name with NULL.
>
> So then I can use this:
> drI("PropInspectionDate") = TextBox22.Text
>
> Instead of having to do this:
> If Not (TextBox22.Text) Is DbNull.Value Then drI("PropInspectionDate") = TextBox22.Text
>
> Please if you can advice. Thank you