In my aspx page, I have a formview and a gridview. I am using the insert template of the form to insert an application number and applicant name both of which the user will enter.
I have a insert stored procedure that checks if that same number exist, it won't enter one, if not it will. ID of that table is autoincrement.
If a new number entered, it should show in the gridview as in my query I am asking to show the max ID. The applicatin number in the grid is a hyperlink which allows the user to go to a details page.
My problem: Whenever I click the save button in the formview, the grid becomes visible with the last created number. It is ok if the system allow to enter a new record. But if the number is a duplicate and the system does not enter a new number, still the grid shows with the last created number.
How can I implement what I want to do.
The stored procedure is:
ALTER
PROCEDURE [dbo].[InsertNewChurchApp]nvarchar
View Complete Post