I use C# & VFP OLDBD Provider.

My table have 4 field. When I insert a record to the table and only fill 2 field eg

dataAdaptar.insertCommand.commandText = "insert into tableA (flda,fldb) values ('a','b')"

C# prompt me error that fldC cannot accept null value. How to set C# insert empty value to the field did not specify in the insert command.


Thanks.