We have a currently c#/asp web app using a sql database, i'm trying to find a way to achieve the following...
When the user adds a new part to the database it checks to see if it exists before adding it, if it does find a duplicate it triggers a warning (ideally with some information on what part it has found as a conflict)
I'd like the warning to contain some basic details about the part that already exists if possible and for it to be triggered when the user clicks the save button.
Attached is the page in question (with code behind) from Control\Quotations\Quotati
And an overview of the project to allow context