Conversion failed when converting the varchar value 'StaffNumber' to data type int

Question

0.00/5 (No votes)

See more:

C#

private void btnok_Click(object sender, EventArgs e)
        {
           cmd = new SqlCommand("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + lbstaffno.Text + "'", con);

            con.Open();
           da = new SqlDataAdapter("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + lbstaffno.Text + "'", con);
            da.Fill(ds, "EmployeeDetails");
                dt = ds.Tables["EmployeeDetails"];
                DataView dv = new DataView(dt);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    lbstaffno.Text = dv[0]["StaffNumber"].ToString();
                    lbmembername.Text = dv[0]["Member_Name"].ToString();
                    lbfathersname.Text = dv[0]["Father_Name"].ToString();
                    lbdesignation.Text = dv[0]["Designation"].ToString();
                    lbaddress.Text = dv[0]["Corresponding_address"].ToString();

                    con.Close();
                }

        }

Posted 26-Sep-11 23:24pm

Koushik Uppari

Updated 26-Sep-11 23:28pm

jim lahey

v2

Add a Solution

Comments

hitech_s 27-Sep-11 5:26am

what is the datatype of "StaffNumber" in your database..

P.Salini 27-Sep-11 5:38am

you will get this error when you are trying to convert nonnumeric value to int so check the value in lbstaffno.Text

OriginalGriff 27-Sep-11 5:39am

Do not re-post your question to add further information - use the "Improve question" widget to edit your question and provide better information instead.
I have deleted the older version without the code fragment.

5 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)

Tejas Vaishnav · Answer 1 · 2011-09-26T23:36:00

C#

da = new SqlDataAdapter("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + lbstaffno.Text + "'", con);

if your StaffNumber is of int then try this query

C#

da = new SqlDataAdapter("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + Convert.toInt32(lbstaffno.Text) + "'", con);

or any thing else then simply note the line number or place a query where you got the error and also provide your database structure so we understand that which datatype of your StaffNumber have

Tech Code Freak · Answer 2 · 2011-09-26T23:52:00

The problem is in the Query!
You've written

SQL

cmd = new SqlCommand("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + lbstaffno.Text + "'", con);

con.Open();
           da = new SqlDataAdapter("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber='" + lbstaffno.Text + "'", con);

The problem is that while stating an int value in coding, we never enclose them in quotes!
All you have to do is just remove the single quotes from your query and you're done!
Change your query in the following manner:

SQL

cmd = new SqlCommand("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber=" + lbstaffno.Text, con);

con.Open();
           da = new SqlDataAdapter("select Member_Name,Father_Name,Corresponding_address,Designation,ValidFrom,Validupto from EmployeeDetails where StaffNumber=" + lbstaffno.Text, con);

OriginalGriff · Answer 3 · 2011-09-26T23:38:00

Solution 2

You aren't converting it to an int - you are converting it to a string, and storing it in a labels Text property.

If you want to convert it to an int, then either:
1) Use the relevant datatype in your database (i.e. int) and cast it when you access the field:

C#

int i = (int) dv[0]["StaffNumber"];

Or
2) Use the int.Parse or int.TryParse methods to convert the string to an int.

Posted 26-Sep-11 23:38pm

OriginalGriff

Comments

P.Salini 27-Sep-11 5:45am

By watching the code i think the problem is near query.
please check the code once.

Anuja Pawar Indore · Answer 4 · 2011-09-27T00:11:00

Solution 4

In you select query you are directly comparing your lbstaffno.Text without converting. First you need to convert it to int then compare

Posted 27-Sep-11 0:11am

Anuja Pawar Indore

devildx2050 · Answer 5 · 2011-09-27T01:30:00

Conversion failed when

converting the varchar value 'StaffNumber'

to data type int

means weather your column StaffNumber is varchar field and you are trying to

convert to int type without parsing it

User Cast (StaffNumber as int) as StaffNumber

your problem has been solved... :)

Conversion failed when converting the varchar value 'StaffNumber' to data type int

5 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0