If Trim(entry.Value) = "" Then entry.Value = Nothing End If

ksk wrote:

If Trim(entry.Value) = "" Then entry.Value = Nothing End If

Is this a test?

if(entry.Value.Trim().Length<=0) { entry.Value = null; }

btw: 1) it's better not to use old VB5-6 native keywords like 'Trim'. Better use the .NET framework, so use the 'Trim' method on string 2) I personally don't think it's wise to use 'null' for string values, unless you absolutely have to.

Otis wrote:

2) I personally don't think it's wise to use 'null' for string values, unless you absolutely have to.

Pff I couldn't agree more. string.Empty is the natural state of an empty string. Making System.String nullable is in my opinion the biggest mistake in the .Net framework design

Same for people still using Guid.Empty and *.MinValue to instead of nullable types, and people that set all their database fields on nullable by default. The Horror

• Wiebe