Conversion failed when converting the nvarchar value 'Infinity' to data type int. Why?

Question

0.00/5 (No votes)

See more:

I am trying to save my data from a form that I developed. On one record I get this error:

C#

Conversion failed when converting the nvarchar value 'Infinity' to data type int.

The error is coming from this line:

C#

cmd2.ExecuteNonQuery();

Here is my codebehind:

C#

SqlCommand cmd2 = new SqlCommand("Insert into TableFA (User_ID, FT_UNDERGR, DATE, FT_GRAD, FTE_UNDERG, FTE_GRAD, NON_CREDIT, TOTAL_FTE, FCFTUHC, FCFTPBHC, FCPTUHC, FCPTPBHC, NCHC, UnderG12, Postb9, Total123b4b, FTEYR, THCAS, FTE40, HC50, NCA, SUBMITTED, Calendar, LongName) values (@User_ID, @FT_UNDERGR, @DATE, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTPBHC, @NCHC, @UnderG12, @Postb9, @Total123b4b, @FTEYR, @THCAS, @FTE40, @HC50, @NCA, @SUBMITTED, @Calendar, @LongName);", con);
                cmd2.CommandType = CommandType.Text;
                cmd2.Parameters.AddWithValue("@INST_ID", TextBoxUser_ID.Text);
                cmd2.Parameters.AddWithValue("@FT_UNDERGR", TextBoxFTUG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FT_GRAD", TextBoxFTG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FTE_UNDERG", TextBoxTHUGDR.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FTE_GRAD", TextBoxTHGDR.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@NON_CREDIT", TextBoxNCCDR.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@TOTAL_FTE", TextBoxTCNC.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FCFTUHC", TextBoxTNFUG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FCFTPBHC", TextBoxTNFG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FCPTUHC", TextBoxTNCPUG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FCPTPBHC", TextBoxTNCPG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@NCHC", TextBoxTNNCC.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FTEYR", lblYEAR1.Text);
                cmd2.Parameters.AddWithValue("@DATE", TextBoxDATE.Text);
                cmd2.Parameters.AddWithValue("@UnderG12", TextBoxTHUG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@Postb9", TextBoxTHG.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@Total123b4b", TextBoxT1234.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@THCAS", TextBoxTHCAS.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@FTE40", TextBoxFTE40.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@HC50", TextBoxHC50.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@NCA", TextBoxNCC.Text.Replace(",", ""));
                cmd2.Parameters.AddWithValue("@SUBMITTED", lblSub.Text);
                cmd2.Parameters.AddWithValue("@Calendar", TextBoxCal.Text);
                cmd2.Parameters.AddWithValue("@LongName", lblSchool.Text);

                cmd2.ExecuteNonQuery();

Why am I getting this error just on this record and not the others? What did I do wrong?

Posted 8-Dec-15 9:26am

Computer Wiz99

Add a Solution

2 solutions

Solution 1

The error should be very clear, isn't it? It says you are trying to store the string value "Infinity" into a field that can only store integers. The word "infinity" clearly is not an integer, neither is the actual value of infinity, but I digress.

Posted 8-Dec-15 9:43am

ZurdoDev

Comments

Computer Wiz99 8-Dec-15 15:47pm

Where is this value? I am typing in numbers. And why is this just the only record?

ZurdoDev 8-Dec-15 15:58pm

How can we tell where the value is? We can't access your system or run your code. You'll have to find it. If indeed the above code is causing it then it is in one of your controls.

You could always run Sql Server Profiler as well to see the exact sql getting sent to the server.

Computer Wiz99 8-Dec-15 16:06pm

Okay, thanks. I will look again.

ZurdoDev 8-Dec-15 16:08pm

It's there or in a trigger or somewhere. Should be pretty easy to find using profiler.

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)

Computer Wiz99 · Accepted Answer · 2015-12-09T02:53:00

Solution 2

I found out what is was!! Had to change the database numbers it was populating from zeros to a real whole number.

Posted 9-Dec-15 2:53am

Computer Wiz99