Cannot insert explicit value for identity column in table 'OS_Mailinglist1' when IDENTITY_INSERT is set to OFF.

Question

0.00/5 (No votes)

See more:

can anyone help me why i am getting this error?thanks in advance..

Cannot insert explicit value for identity column in table 'OS_Mailinglist1' when IDENTITY_INSERT is set to OFF.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert explicit value for identity column in table 'OS_Mailinglist1' when IDENTITY_INSERT is set to OFF.

Source Error:

Line 310:
Line 311:
Line 312: cmd.ExecuteNonQuery();
Line 313: ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Successsfully Registered your Email ID and Area of interest.');", true);
Line 314:

Posted 9-Dec-12 23:55pm

nityasri

Updated 28-Sep-16 21:13pm

Add a Solution

3 solutions

Solution 1

Refer this link from Stackoverflow.com

http://stackoverflow.com/questions/1334012/cannot-insert-explicit-value-for-identity-column-in-table-table-when-identity[^]

Posted 9-Dec-12 23:59pm

Kiran Susarla

Comments

nityasri 10-Dec-12 6:35am

@kiran thank u

Solution 3

Do not put values in identity column.
most of time identity column we consider as id. so make sure if your id is identity column then in insert query consider id.
for example
i am putting a query of stored procedure as follows,
ALTER procedure [dbo].[sp_registration](
@pkid int=null,
@userName nvarchar(100),
@password nvarchar(100),
@email nvarchar(100),
@mode nvarchar(10)
)
as
begin
if @mode='signUp'
begin
insert into registration(userName, email, password, status, createdOn) values(@userName, @email, @password, 1, GETDATE());
end

Posted 28-Sep-16 21:13pm

samlee69

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)

AnkitGoel.com · Accepted Answer · 2012-12-10T00:00:00

Solution 2

this is because you are passing some value in a column which is set as identity (auto-increment).

hope it helps.
otherwise, please send the query u r passing to command object.

Posted 10-Dec-12 0:00am

AnkitGoel.com

Comments

nityasri 10-Dec-12 6:35am

@ankit..thanks a lot

AnkitGoel.com 10-Dec-12 6:37am

please mark as answer if helped you.

nityasri 10-Dec-12 6:50am

This is were i am getting the error...

protected void btnSubscribe_Click(object sender, EventArgs e)
{
string arrvalues = null;
for (int i = 0; i < CBL1.Items.Count ; i++)
{
if (CBL1.Items[i].Selected)
{
arrvalues = arrvalues + CBL1.Items[i].Value + ",";
}
}

if (arrvalues==null)
{

}
else
{
if (arrvalues.EndsWith(","))
{
arrvalues = arrvalues.Remove(arrvalues.Length - 1, 1);
}
My_Util Util = new My_Util();
DataSet ds;
ds = Util.CheckusernameMail(txtEmail.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
//My_Util Util = new My_Util();
Util.SetConnection();
Util.sql_con.Open();
SqlCommand cmd;
// cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_of_interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + pwd.ToString() + "')", Util.sql_con);

cmd = new SqlCommand("update offsale.OS_Mailinglist1 set Area_Of_Interest='" + arrvalues + "' where UserName='" + txtEmail.Text.ToString() + "'", Util.sql_con);
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Area of Interest Updated Successfully');", true);

Util.sql_con.Close();

foreach (ListItem item in CBL1.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
}

txtEmail.Text = "";
Label1.Visible = false;
passwrd.Visible = false;
btnSend.Enabled = true;
btnSubscribe.Enabled = false;

}
else
{
Util.SetConnection();
Util.sql_con.Open();
cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_Of_Interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + ViewState["pwd"].ToString () + "')", Util.sql_con);
// cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_of_interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + passwrd.Text.ToString () + "')", Util.sql_con);

cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Successsfully Registered your Email ID and Area of interest.');", true);

//ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Register your Password to MailingList')", true);
// return;
Util.sql_con.Close();

foreach (ListItem item in CBL1.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
}

txtEmail.Text = "";
Label1.Visible =false ;
passwrd.Visible =false ;
btnSend.Enabled = true;
Label2.Visible = true;
Label2.Text = "Please select your Area of Interest & Subscribe";
btnSubscribe.Enabled = false;

}
}
}

AnkitGoel.com 10-Dec-12 6:54am

r u still getting errors? if yes, i need your table create script