how to solve its error?

Question

1.00/5 (1 vote)

See more:

hi , i need using C# and SQL for using Insert,delete,update,search ... which how to save value textbox into sql ? i searched alot on google and tried by this code which is same as in many website for insert first but it points an error on cmd.ExecuteNonQuery(); which says SQLEXCEPTION was unhandled (Cannot insert explicit value for identity column in table 'book' when IDENTITY_INSERT is set to OFF.) ... may u help me to solve this error ... i need it very much.

many thanx

C#

private void button1_Click(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection("Data Source =PERSIAN-PC\\SQLEXPRESS;Initial catalog=library;Integrated Security=True");
            
    SqlCommand cmd = new SqlCommand("INSERT INTO book (ide, name, year) VALUES (@a,@b,@c)", con);
    cmd.Connection = con;
    cmd.Parameters.AddWithValue("@a", textBox1.Text);
    cmd.Parameters.AddWithValue("@b", textBox2.Text);
    cmd.Parameters.AddWithValue("@c", textBox3.Text);
    con.Open();
    cmd.ExecuteNonQuery(); // here is the error????
    con.Close();
}

Posted 9-Sep-12 3:55am

lida zar

Updated 9-Sep-12 3:59am

WebMaster

v2

Add a Solution

Comments

[no name] 9-Sep-12 9:57am

The error is very clear, either turn IDENTITY_INSERT on or stop trying to insert a value into the identity column.

lida zar 9-Sep-12 10:15am

thanx

[no name] 9-Sep-12 10:16am

either turn IDENTITY_INSERT on or stop trying to insert a value into the identity column

lida zar 9-Sep-12 10:02am

how to solve this ???

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

Sandeep Mewara · Accepted Answer · 2012-09-09T04:06:00

(Cannot insert explicit value for identity column in table 'book' when IDENTITY_INSERT is set to OFF.)
It looks like your ID column is set as IDENTITY column in your database.
2 options:
1. Either set this column to allow having values inserted by query OR
2. Don't pass/try to insert ID value. It will automatically get filled when you insert a new book.

Identity columns are generally primary key column and are set to self increment with every insert - this helps in maintaining a unqiue automatic ID generation. I would suggest to follow option 2 and don't pass ID at all. Let DB handle it by itself.

Do:

C#

SqlCommand cmd = new SqlCommand("INSERT INTO book (name, year) VALUES (@b,@c)", con);
cmd.Parameters.AddWithValue("@b", textBox2.Text);
cmd.Parameters.AddWithValue("@c", textBox3.Text);

Ashraff Ali Wahab · Accepted Answer · 2012-09-09T04:01:00

When you created the Book table you have created the ide column as IDENTIY column.
You can do any if the below two things

1.Recreate the book table without the identity keyword for ide column
2.Modify the book table to accept insert for identity column using the below statement

SET IDENTITY_INSERT book ON

WebMaster · Accepted Answer · 2012-09-09T04:05:00

Solution 2

In order to insert into a table containing an identity column Set IDENTITY INSERT ''tablename'' On.

http://sqlserverplanet.com/sql-server/cannot-insert-explicit-value-for-identity-column-in-table-table-when-identity_insert-is-set-to-off[^]

Posted 9-Sep-12 4:05am

WebMaster

v2

how to solve its error?

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0