Input string was not in correct format

Question

0.00/5 (No votes)

See more:

Hi ,

Here I have write code for gridview to insert record but that is through a error "Input string was not in a correct format"

sqlInsert.Parameters.Add("@Product_Quantity", SqlDbType.Int).Value = Convert.ToInt32(newProduct_Quantity.Text);

while I have checked all things product_quantity is a int field in database and same write in code but I do not know the reason.
while i am able to update and delete row but when insert record then the error is coming.

Posted 29-Sep-10 20:12pm

call to .net

Updated 29-Sep-10 20:15pm

v3

Add a Solution

Comments

[no name] 30-Sep-10 14:45pm

Is that the only parameter?

Please post the entire grid markup

2 solutions

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)

thatraja · Answer 1 · 2010-09-29T20:18:00

Solution 1

Check the value for the parameter @Product_Quantity while debugging, is it numeric value? i think it's not. Basically this error occurs at these times.
Also check if the value is ""(blank string), so convert it.

Posted 29-Sep-10 20:18pm

thatraja

Updated 29-Sep-10 20:27pm

v3

AspDotNetDev · Answer 2 · 2010-09-29T20:22:00

Use int.Parse or int.TryParse rather than Convert.ToInt32. Confirm you are entering a valid string. Split the code into different lines so you can tell exactly where the error is:

C#

int productQuantity = int.Parse(newProduct_Quantity.Text);
sqlInsert.Parameters.Add("Product_Quantity", SqlDbType.Int).Value = productQuantity;

Also note that you don't need the "@" in front of the variable... that will be added for you. If you are calling a stored procedure, make sure the parameter is the right type. If you are using an INSERT statement, make sure all the parameters and values are in an order that corresponds to eachother.