Violation of PRIMARY KEY constraint 'PK_StudentInf'. Cannot insert
duplicate key in object 'dbo.StudentInf'.
The statement has been
the above message is appearing when i am upadating the record.
I am doing project using asp.net 3.5 c#.net and sqlserver 2005,
i am executing sp for update using sqlhelper block, when i am updating record the above error occuring rarely(not for all records), if i update one record if get an error above second time it is updating nicely,
i am not able to finding the problem when and where it is occuring.
one thing here i am upadating primary column also like hallticket NO.
is there any problem if update primary column .
please tell me the solution it's urgent, and also it is on LIVE.
please give me solution as early as possible.
View Complete Post