I have a DetailsView and a LLBLGenDataSource2 control which I'm using to insert a new row in my database.
The problem I'm having is that any fields that are left empty in the DetailsView get inserted as empty even when the table has column level default values which I want used.
Is there anyway to get the empty fields omited from the insert so the default value is used? I assuming that the value being inserted now is the default value on the entity field.
Otherwise how can I set a custom default value for each field that gets inserted for empty DetailsView fields?