c# - Look up table allowing null -
i have incident table has incidenttypeid(int) foreign key allowing null.
the incidenttype table has 2 columns id auto increment primary key not null , incidenttype not null nvarchar.
the incidenttype table populating ddl have listitem selected selected , value of "". checking if value "" , if setting selectedvalue of ddl null.
when select ddl fine , works ok.
when try , insert nothing selected , set null sqlexception on foreign key constraint on incidenttype id column not allowing null primary key .
how can round allowing null?
primary key cannot null. not possible entry must have id number. otherwise there noting create.
Comments
Post a Comment