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