Thank you very much Dparsons! I am debugging the whole thing now and hopefully will be able to replicate what you have shown me.

Well this is where I am stuck....

Message="Conversion failed when converting the nvarchar value
'The Company has been Added' to data type int."

this is my @message but it isnt populating my Label as it should be

lblmessage.txt = sMessage


more help would be a blessing!

you are trying to convert an string into an int???

HTH

Gonzalo

================================================== =========
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
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

This is an error being thrown from your stored procedure; somewhere along the way you are taking a string value and trying to assign it to an int value. I can't help you any further then that, you will need to look at your procedure code.

================================================== =========
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
================================================== =========

Thanks guys I will review my procedure and let you know how it turns out. FUnny thing is I dont think I have an INT in there except the PK. I wonder if the SCOPE_INDENTITY is what is causing this?

In any event thank you again i will update you!

Looking over the error, I assume that this:
'The Company has been Added'
is the output of your stored procedure which is an nvarchar. Somewhere along the way you are trying to assign it to an int variable (this is an educated guess in any event). What I would do is, assuming you are using SQL Server, go into query analyzer and execte the stored procedure there and see if that error message is returned (it should be). If it is not, you stated in one of your post that there are alot of other parameters that you did not show us, verifiy that the datatype for each parameter is correct.

So your SqlDbType is SqlDbType.Int, Varchar, etc and the values being passed in match the expected type.

hth.

================================================== =========
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
================================================== =========