C# database insert query problem

Question

I have built a connection of my C# program with SQL Server. The table in which i am inserting data has a primary key. what should i insert for the primary key as it should be on auto increment.

Answer 1

no need to insert any value for the primary key if it's set (and should be) as auto-increment.

Answer 2

is it required to set auto increment in SQL Server? because it is marking auto increment as error

Answer 3

Can you post your code. I have the feeling that your are trying to fill the primary key when it want to fill the sql server wants to fill it.

Answer 4

I have resolved the issue. the primary key was not set on auto increment that's what the issue was.