Catch Exception Descrition

Question

1.00/5 (2 votes)

See more:

Hi I am getting the following error while am trying to delete one record from my Grid.
Can anybody tell me what the exception mean.Thanx in advance..
"Conversion failed when converting the nvarchar value '29g' to data type int"

In my code its the following case

C#

else if (type == "DelDoctor")
     {
         objuserVO.DoctorID = Convert.ToInt32(Session["DoctorID"]);
         objuserVO.Transtype = "DEL";
         objRequestVO.addobject("AddDoctorsProfile", objuserVO);
     }

Posted 27-Aug-12 23:26pm

Radhika Vyas

Updated 27-Aug-12 23:32pm

Mohamed Mitwalli

v3

Add a Solution

Comments

Maciej Los 28-Aug-12 5:37am

29g is not a valid integer value, that's why you get this error-message.
Debug program and check Session["DoctorID"] value.

4 solutions

Solution 4

It is so clear the Convert class never will convert "29g" to int.

Posted 27-Aug-12 23:38pm

WebMaster

Comments

Legor 28-Aug-12 5:50am

5ved for antitrolling (and correctness of the anwer ;)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2012-08-27T23:38:00

Solution 3

The code you are showing is not related to your problem.

Like the error says "29g" cannot be converted to an integer value. Check the data you have entered and remove the "g" or anything which is not an number for all the rows in your database.

Add validation to your data entry to check for non integer values so this does not happen.

Posted 27-Aug-12 23:38pm

Mehdi Gholam

Comments

Legor 28-Aug-12 5:49am

5ved for antitrolling (and correctness of the anwer ;)

Mehdi Gholam 28-Aug-12 6:01am

Thanks Legor!

Legor 28-Aug-12 6:04am

Your welcome, can you please offer the same service for my solution below?

Manas Bhardwaj 28-Aug-12 5:56am

+5

Mehdi Gholam 28-Aug-12 6:01am

Thanks Manas!

Radhika Vyas 28-Aug-12 8:20am

But Session["DoctorID"] is an Object..then what to do?

Mehdi Gholam 28-Aug-12 10:36am

Put a breakpoint on the line an watch it's values, check to see if the value you want is in there.

Legor · Accepted Answer · 2012-08-27T23:36:00

Solution 1

The error message allready says it all. You can not convert the characters '29g' to an integer representation. Of course 29g is not a number. Or can you tell me what would be the result of: "(29g + gst) * 5 = ?"

Posted 27-Aug-12 23:36pm

Legor

Comments

Legor 28-Aug-12 5:48am

It seems some troll, probably the OP downvotes every answer out of missbelief or ignorance.

Mehdi Gholam 28-Aug-12 6:19am

5'ed

pradiprenushe · Accepted Answer · 2012-08-27T23:36:00

Solution 2

Your Session["DoctorID"] contains "29g".
You are converting this value to int.
You cant convert "29g" to integer.
Normally Id fiel should be int. If you have used id field as nvarchar then rather than converting session to int convert to string.

Posted 27-Aug-12 23:36pm

pradiprenushe

Comments

Legor 28-Aug-12 5:49am

5ved for antitrolling (and correctness of the anwer ;) ).