Working with Dataset and Null Values

[gmcordell]

Welcome to VBForums !

If you are using strongly typed dataset (xsd), in dataset designer right click the data column, goto properties. In the properties window see the "NullValue" property. Set it the way you like.

You can set a variable to DbNull by alligning it [b]DbNull.Value[b].

Also, please do a search for "IsDbNull", "Nullable Data Type".

Hi Mate yes its an xsd dataset, the field in question wont allow me to set is as empty. Ive tried adding the following line of code to check and assign the value but im getting an error message.

IIf (IsDBNull(Me.DataSet11.Staff.FindByPayref(EmpVar).Forename1, string.Empty, "Test")

Its stating to many arguement for IsDBNull, ill have a search on the two criteria you just added now.