Input String Was not in Correct Format

Question

1.00/5 (1 vote)

See more:

When I am Passing the Value of the selected in the Gridview for deletion it throws Input String was not in correct format exception My Code is,

C#

protected void gridview1_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName.ToUpper().ToString() == "DELETEREC")
    {
        try
        {
            ViewState["id"] = e.CommandArgument.ToString().Trim();
            int r = Namespace.SPs.StoredProcedure(Convert.ToInt32(ViewState["id"])).Execute();//Exception thrown Here
            if (r > 0)
            {
                ClientMessaging("Record Deleted Successfully");
                Clear();
                fillgrid();
            }
        }
        catch (SqlException ex)
        {
            ClientMessaging(ex.Message);
        }
    }
}

Posted 16-May-13 1:15am

Rajesh Kumar Sowntararajan

Add a Solution

Comments

NarasimhaMurthy 16-May-13 7:19am

Whats there in Namespace.SPs.StoredProcedure?

Rajesh Kumar Sowntararajan 16-May-13 7:22am

It Calls the Stored Procedure and Connects with SQL Server,Mentioned in the Class File Under the Name Space

ZurdoDev 16-May-13 7:27am

Why? All you have to do is put a breakpoint and see what is happening.

RaisKazi 16-May-13 10:55am

perfect suggesion. :)

3 solutions

Solution 1

There can be many problems with your code.

1) ViewState["id"] can be blank as the argument you are passing may be blank.
2) If you are able to get a value for ViewState["id"], it can be non numeric.
3) If it is not blank and is a numeric value, the possible error is in your class file code or there is something wrong at database level.

Check for these things first as we can't tell from this small piece of code what can be wrong.

Posted 16-May-13 1:34am

Zafar Sultan

Solution 2

C#

ViewState["id"] = e.CommandArgument.ToString().Trim();
           int r = Namespace.SPs.StoredProcedure(Convert.ToInt32(ViewState["id"])).Execute

Here there may be two issues with the code
1.You are Assigning the Command Argument value to the View sate in string format.
2.Again you are converting the string value to the Int32
The conversion should depend on the type of the parameter in the Stored Procedure Method.

if you can put the Method details it would be helpful.

Posted 16-May-13 3:15am

Vipin kumar.P

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)

Rajesh Kumar Sowntararajan · Accepted Answer · 2013-05-16T18:02:00

Solution 3

The Problem is only in my Select Command in the Stored Procedure I didn't select the the Value i was Passing so I had Changed the Select Command then added Datakeynames in Gridview and It worked Perfectly

Thanks All for the Suggestions...

Posted 16-May-13 18:02pm

Rajesh Kumar Sowntararajan