I'm getting this common error

Server Error in '/FireworksPermitApp' Application.
--------------------------------------------------------------------------------

Violation of PRIMARY KEY constraint 'PK_tblTempOnlineFWUsers'. Cannot insert duplicate key in object 'tblTempOnlineFWUsers'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblTempOnlineFWUsers'. Cannot insert duplicate key in object 'tblTempOnlineFWUsers'. The statement has been terminated.

Source Error:

The things is, when I check that particular table, the ID is being created and entered. So I really don't know where this error is spinning from. I was thinking that my primary key, which vchUserId, was being duplicated but it's not. So I don't understand. Can someone please help me?

Is your PK an auto inc value?? If it is, are you trying to explicitly insert a value into that column? If you are, don't, as this can cause the type of error you are seeing.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

No, it's not set to auto inc.

Ok, so you are trying to insert a value manually into the PK field. If you are certain that you are not duplicating the ID in your table, this might be a relationship problem with another table; while the pk might be unique in your source table it might conflict else where.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

You're right. For some reason when I click submit, it tries to run the same routine twice. Because when I take the primary key off, it goes thru without the error and enters in the same UserID twice. But with the primary key it throws up that error. I've came to the conclusion that it's running the routine to enter the ID twice. So now I have to figure out why it's doing that.

I don't know if I mention it before but, What I'm thinking is that when I click submit, it enters the userID. Instead of going redirecting it to the wanted page, I get this website certificate page telling me that that it may not be safe I'm thinking when I click continue, it tries to enter that same userID again and throws that error.