Error in asp.net at runtime

Carnation Flowers

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.

Know the answer? Post it — somebody with the same question will find it here.

Sundaram Subramanian9y ago
Accepted 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.
Abhilash J A9y ago
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!!!
Nilesh Shah9y ago
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 Flowers9y ago
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 Krishnamoorthi9y ago
It would be better to share your code in this thread.

Example :

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

Carnation Flowers9y ago
there is no decimal value at all in this page
Sundaram Subramanian9y ago
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.