Loading

windows application - updating database

morenoa

Hi there ! When I'm trying to update an existing row in a table, i recieve the following error : An unhandled exception of type 'System.Data.ConstraintException' occurred in system.data.dll Additional information: Column 'StudentID, CourseID, Type' is constrained to be unique. Value '1234567, course 06, master' is already present. I use sql server 2000. Does anyone Knows how to fix the problem ? moreno

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

miker22y ago
It looks like you have combined unique key on StudentID, CourseID, and Type. The values you are trying to enter already exist in the database, and that violates the constraint.