Error in asp.net at runtime

Question

at local its working perfectly but when i hosted it on server i get runtime error how can i deal with it any help is apprecited Error converting data type nvarchar to decimal.

Sundaram Subramanian · Answer

Check your parameters with SP parameters. You are calling some decimal parameter. Else paste your DB Parameters and ADO.NET Parameters. I will check and update you.

Nilesh Shah · Answer

are you taking any input from user? if yes, then have you taken care so that user can only enter number in textbox and not the alphabets?

Carnation Flowers · Answer

i found error becz i used cookie wich store userid its int value i transfer it into nvachar its worked but still dont understand why its give error as if it was Decimal and another Question can i replace the cookies with session and i wounder if session can be used on Project level or just in some folders thakyou for each help i m wating for answers

Hariharan Krishnamoorthi · Answer

It would be better to share your code in this thread.

Rajkiran Swain · Answer

Example : txtrate_km.Text.IsNullOrEmpty() ? DBnull. value : Decimal.Parse(txtrate_km.Text)

Carnation Flowers · Answer

there is no decimal value at all in this page

Sundaram Subramanian · Answer

Your passing NVARCHAR to Decimal. Pass the parameter as Decimal. Parameter Value is Decimal, but your are pass a nvarchar value to database / SP. Change that to correct Datatype.

Abhilash J A · Answer

Hi Carnations Flower, I would pefer that Anti-CSRF token implementation. ASP.NET provides the Guid class which implements a NewGuid method to generate unique 128-bit integer. Please refer this web page: http://paladion.net/secure-coding-techniques-in-asp-net-part-2/ https://books.google.co.in/books?id=RUnG_uewR8wC&pg=PA378&lpg=PA378&dq=new+HttpCookie+Guid.NewGuid()+asp.net&source=bl&ots=WDPiAtSD2S&sig=bnBC4V0sbhxx8tuUD-MrKExaU7w&hl=en&sa=X&ved=0ahUKEwjgipilrsrUAhUHKo8KHWmyCDkQ6AEISjAG Cheers!!!