Error while inserting data.

[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.

 

[Chris Anderson [MVP-VB]]

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.

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

 

[Harsha]

Thank you very much Chris..

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.

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