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.

 

Answer 1

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. 

Answer 2

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?

Answer 3

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 

Answer 4

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

Answer 5

Example :

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

Answer 6

there is no decimal value at all in this page

Answer 7

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.  

Answer 8

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