SQL error

[Daven81]

guys i encounter an error like this when i try to add a new record and i dont understand it. i am using vb.net with sqlserver
"An explicit value for the identity column in table supplier can only be specified when a column list is used and IDENTITY_INSERT is ON."
please help

 

[Robby]

DO you have an ID column in Supplier?

 

[Daven81]

yes i do. on another form i use the same coding and can add the data

 

[csharpener]

the error is a bit vague but it appears to me that the record you are trying to insert has an int identity or autonumber and the code you are using is trying to assert a primary key value. check the INSERT statement to see if your dataset or code is trying to specify what the primary key value will be - SQL server is probably handling this management itself and saying to your vb.net code "Bugger Off thats my job PaL"...