Display Custom Error Message for Primary Key and Composite Key errors in MySQL

Shailend...

Hi,

I have AllocatedSubjects table.

Create table AllocatedSubjects(Subjectid number(2), FacultyId number(2), SemNo number(2), PRIMARY KEY(SubjectId,FacultyId));

It generates an error message when the same entry is there. Can I display the proper error message instaed?

Mudassar

0 1

You can catch the Exception in code and then display appropriate error message

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html