We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Update a value in your dataset with NULL.

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

1 Reply

AD Administrator Syncfusion Team January 31, 2003 04:38 PM UTC

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

Loader.
Up arrow icon