Error while inserting data.

  • Thread starter Thread starter Harsha
  • Start date Start date
H

Harsha

Hello all,

I am trying to insert data into a table.. and it is giving the following
error.
"ExecuteNonQuery -- Error Code: 80040E2F Message : A duplicate value
cannot be inserted into a unique index. [ Table name =
CUSTOMIZATION,Constraint name = IN_CUSTOMIZATION ] Minor Err.: 25016 Source
: SQL Server 2005 Mobile Edition ADO.NET".
Please help me how to resolve this. Thnaks in advance.

Harsha.
 
Harsha said:
Hello all,

I am trying to insert data into a table.. and it is giving the following
error.
"ExecuteNonQuery -- Error Code: 80040E2F Message : A duplicate value
cannot be inserted into a unique index. [ Table name =
CUSTOMIZATION,Constraint name = IN_CUSTOMIZATION ] Minor Err.: 25016 Source
: SQL Server 2005 Mobile Edition ADO.NET".
Please help me how to resolve this. Thnaks in advance.

Harsha.
Click to expand...
Well, exactly as it says.... there's a unique constraint on the data....
and the data you are inserting, based on that constraint, already exists
in the table.... so it cannot insert it...

-ca
 
Thank you very much Chris..

Chris Anderson said:
Harsha said:
Hello all,

I am trying to insert data into a table.. and it is giving the following
error.
"ExecuteNonQuery -- Error Code: 80040E2F Message : A duplicate value
cannot be inserted into a unique index. [ Table name =
CUSTOMIZATION,Constraint name = IN_CUSTOMIZATION ] Minor Err.: 25016 Source
: SQL Server 2005 Mobile Edition ADO.NET".
Please help me how to resolve this. Thnaks in advance.

Harsha.
Click to expand...
Well, exactly as it says.... there's a unique constraint on the data....
and the data you are inserting, based on that constraint, already exists
in the table.... so it cannot insert it...

-ca
Click to expand...
 
Back
Top