There's a field in a table of a SQL Server database that doesn't except "NULL" but has a default value of "0". The InsertCommand for the data adapter that vb.net automatically generates doesn't accommodate this. If the field is left blank in the front end program, the update method of the data adapter fails with a message that the field can't be left blank. It doesn't set it to the default value that is set in the SQL Server table. What is the easiest way to get the data adapter to set the field to the default value when the corresponding parameter is null (from being left blank by the user)?