How to set auto increment primary key on button click?

Question

0.00/5 (No votes)

See more:

Hi,
I have a sql table having fields ItemID(set as primary key), ItemCategoryID,newid(set as uniqueidentifier)

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        int ItemID = 1123342;
        int ItemCategoryID =1;
}

SqlCommand cmd = new SqlCommand("insert into Item(ItemID,ItemCode,ItemCategoryID,ItemDescription) values(@ItemID,@ItemCategoryID)", con);
cmd.Parameters.AddWithValue("@ItemCode", txtItemCode.Text);
cmd.Parameters.AddWithValue("@ItemDescription", txtItemDescription.Text);
cmd.Parameters.AddWithValue("@ItemID", ItemID);
cmd.Parameters.AddWithValue("@ItemCategoryID",ItemCategoryID);
cmd.ExecuteNonQuery();
}
Whenever I click submit button at first the value will be inserted to db. But in the second click it shows that :

SQL

Violation of PRIMARY KEY constraint 'PK_Item'. Cannot insert duplicate key in object 'dbo.aItem'. The duplicate key value is (1123342).
The statement has been terminated.

Posted 26-Mar-14 0:26am

My Doubt

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Akshay_Randive · Accepted Answer · 2014-03-26T00:51:00

Solution 1

you cannot have same values in primary column it needs to have distinct values

Posted 26-Mar-14 0:51am

Akshay_Randive

Naz_Firdouse · Accepted Answer · 2014-03-26T00:52:00

Solution 2

since ItemID is primary key, it should be unique. When you click for the second time, the same value for ItemID gets passed and hence you are getting the message. Make sure you change the ItemID for each and every item.

Posted 26-Mar-14 0:52am

Naz_Firdouse

Comments

My Doubt 26-Mar-14 7:11am

Yes you are right. But I need to know how to increment the ItemID on every click. It is initially set as ItemID = 1123342.

Naz_Firdouse 26-Mar-14 7:30am

Define ItemID as a global variable and increment its value on button click itself so that whenever you click , its value gets incremented and you can insert them in DB

Naz_Firdouse 26-Mar-14 7:31am

if it sovles your issue, vote up and mark as answer

My Doubt 27-Mar-14 0:09am

I think I need to create an sp to solve this problem.