Abort due to constraint violation PRIMARY KEY must be unique..error

Question

0.00/5 (No votes)

See more:

Abort due to constraint violation PRIMARY KEY must be unique, any one tell me what error this.....

C#

private void tsbtnEdit_Click(object sender, EventArgs e)
        {
            try
            {
                frmAddEditEvents obj = new frmAddEditEvents();
                obj.ShowDialog();
                    SQLiteConnection connection = new SQLiteConnection(connectionString);
                    if (grdEvents.Rows.Count > 1 && grdEvents.SelectedRows[0].Index != grdEvents.Rows.Count - 0)
                    {
                        delcmd.CommandText = "UPDATE AddEvent SET ID=" + grdEvents.SelectedRows[0].Cells[0].Value.ToString()+ "";
                        connection.Open();
                        delcmd.Connection = connection;
                        delcmd.ExecuteNonQuery();
                        connection.Close();  

                        grdEvents.Update();
                        MessageBox.Show("Row updated");
                    }
                else
                {
                    MessageBox.Show("Please select any record to update");
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Posted 12-Jul-12 23:57pm

rockpune

Updated 13-Jul-12 3:40am

Sandeep Mewara

v2

Add a Solution

4 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)

AshishChaudha · Answer 1 · 2012-07-13T04:05:00

Dear you are trying to update the ID field which you had defined Primary Key in you table structure. Primary key is always a unique and not supposed to insert a duplicate key and you are forcefully trying to update through a data which is already defined as a primary key.

Following is wrong.

SQL

delcmd.CommandText = "UPDATE AddEvent SET ID=" + grdEvents.SelectedRows[0].Cells[0].Value.ToString()+ "";

Thanks
Ashish

Vani Kulkarni · Answer 2 · 2012-07-13T00:10:00

Solution 1

See below link if it helps:
http://sqlite.phxsoftware.com/forums/t/1418.aspx[^]

Posted 13-Jul-12 0:10am

Vani Kulkarni

Sunny_Kumar_ · Answer 3 · 2012-07-13T00:20:00

Solution 2

Hi darshan_ur,

The problem you stated above explains that you're trying to insert a duplicate value in the column which has a constraint of being Primary Key.

Check the value which you're passing to insert as ID, it must not be a duplicate n that's all.

Hope this helps.

Happy Coding :)

Posted 13-Jul-12 0:20am

Sunny_Kumar_

Comments

rockpune 13-Jul-12 6:34am

i have 2 forms in form1 i have datagridview and second form some textboxs controls have but my proble is when i click on gridview row i want to display that row values into form2 for update bu here it showing

Abort due to constraint violation PRIMARY KEY must be unique

Sunny_Kumar_ 13-Jul-12 6:43am

you get the error while fetching details or updating the table ?

rockpune 13-Jul-12 6:47am

updating hte table

rockpune 13-Jul-12 6:47am

updating the table

rockpune 13-Jul-12 6:49am

i have only one button to save in form2 either i insert data or update data

Sunny_Kumar_ 13-Jul-12 6:55am

that's what i suggested you in my above solution for you & that is to check the value that is being passed to update the table.
I mean the value of:
"grdEvents.SelectedRows[0].Cells[0].Value.ToString()". this must not be the value that is already in the table in Primary key column.

rockpune 13-Jul-12 6:57am

so wat can i do now

Sunny_Kumar_ 13-Jul-12 7:10am

debug the application, use Break on the statement above:

"delcmd.CommandText = "UPDATE AddEvent SET ID=" + grdEvents.SelectedRows[0].Cells[0].Value.ToString()+ "";"

and check what value it passes to the database as ID and I think that's an easy task.

Arjun YK · Answer 4 · 2012-07-13T18:57:00

Solution 4

If it is the problem with the Id column you can use Auto generated column I guess.
And I don think that you can update a primary key column with the same Data which is already in the database column

Posted 13-Jul-12 18:57pm

Arjun YK