sql - An explicit value for the identity column in table 'tableX' can only be specified when a column list is used and IDENTITY_INSERT is ON." -

i getting error above saying cannot explicitly define identity column without doing these things however, not trying set value of identity column. merely trying execute basic insert statement using user input. i'm stuck , need past this. thoughts?

 public sub executesql(byval sql string)      using myconnection new data.sqlclient.sqlconnection(connstring)         myconnection.open()         using cdmdatabasecommand new data.sqlclient.sqlcommand(sql, myconnection)             cdmdatabasecommand.executenonquery()         end using     end using end sub    dim insertspray string = ""   insertspray = "insert spray values ('" & spraydate & "','" & timestart & "','" & timefinish & "','" & tankvolumestart & "','" & tankvolumefinish & "','" & comment & "','" & vehicleid & "','" & vehicletime & "','" & sitetype & "','" & area & "','" & applicatoroneid & "','" & applicatortwoid & "','" & spraylocationfeature & "','" & spraystartlocationdescription & "','null','null','null','null','" & sprayendlocationdescription & "');"    executesql(insertspray) 

you're not specifying column-list, sql server assumes want insert columns, in table-order.

you need change syntax specify names of columns you're inserting (and leave out identity column, obviously):

insert spray (spraydate, timestart, ...)  values (... 

also note code vulnerable sql injection attacks. should using parameterized queries.