insertCommand.Parameters.Add("@accessPassNo", SqlDbType.Decimal, 17).Value = (this.passTable == PassTable.Access) ? passNo : null;

it may have to be DbNull


>Can you show what do you mean? I can not use inline IIF but I believe with that new code it should work. I'm going to test my new code in a few minutes.