Hi EC Teo,

I hate to be blunt, but why can't check it for null and then set it to an empty string if that is acceptible in your data?

if (myParam == null)
  myParam = "";

Tim

>I m using dataset (.xsd) to connect to mysql database.
>
>In my webform, i have detailsView, enable inserting.
>
>Every thing work fine, until when I insert new a record to mysql. System prompt me error :
>
>Value cannot be null.
>Parameter name: @custPo
>
>if i didn't key in anything to custPo field.
>
>How to make system automatically convert null value to empty string?
>
>TIA.