Error while display data from from SQL

Question

Why I am getting this error?

Input string was not in a correct format.

I am trying to get data from selected column according to the ID.

Codes are:

protected void Page_Load(object sender, EventArgs e)
{

    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);
    SqlCommand cmd = new SqlCommand("SELECT Date,Day,Time,Total FROM RSVP WHERE Id = @dummy", conn);

    conn.Open();

        cmd.Parameters.Add("@dummy", SqlDbType.Int).Value = Label2.Text;

    var dr = cmd.ExecuteReader();
    if (dr.HasRows == false)
    {
        throw new Exception();
    }
    if (dr.Read())
    {
        Label8.Text = dr[0].ToString();
        Label9.Text = dr[1].ToString();
        Label10.Text = dr[2].ToString();
        Label11.Text = dr[3].ToString();
    }

Error at line

  var dr = cmd.ExecuteReader();

My id is INT data type and it is the PK. Thanks.

Have you tried Value = int.Parse(Label2.Text)?

Renatas M.
– Renatas M.

2012-09-14 09:20:14 +00:00
Commented Sep 14, 2012 at 9:20 — Renatas M.
– Renatas M., Commented Sep 14, 2012 at 9:20

nunespascal · Accepted Answer · 2012-09-14 09:17:45Z

2

Escape keywords in your query:

"SELECT [Date],[Day],[Time],Total FROM RSVP WHERE Id = @dummy"

Convert your data to and int.

cmd.Parameters.Add("@dummy", SqlDbType.Int).Value = Convert.ToInt32(Label2.Text);

answered Sep 14, 2012 at 9:17

nunespascal

17.7k2 gold badges45 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Akash KC · Accepted Answer · 2012-09-14 09:29:55Z

1

Simply Add the value in paramter with AddWithValue in following way:

  cmd.Parameters.AddWithValue("@dummy",  Label2.Text);

There is implicit conversion while working with AddWithValue.

answered Sep 14, 2012 at 9:29

Akash KC

16.4k6 gold badges41 silver badges59 bronze badges

7 Comments

Clarify Seeker Over a year ago

I am getting this error : Conversion failed when converting the nvarchar value 'Label' to data type int.

Akash KC Over a year ago

That mean, Label2.Text has value "Label" which can't be converted to int....Debug your code n see the Label2.Text value....

Clarify Seeker Over a year ago

In my previous page, there is a drop menu (username), when user click the username, the dropdown B will show ID of the username. Then hit save, hold the session of ID session, move the next page. Label2 will show the session of the ID. From session (ID), code above are used to show the data that belongs to ID.

Akash KC Over a year ago

Have you checked what's in Label2.Text while debugging?

Clarify Seeker Over a year ago

Error at this line : cmd.Parameters.Add("@dummy", SqlDbType.Int).Value = Convert.ToInt32(Label2.Text);

|

Arran · Accepted Answer · 2012-09-14 09:17:02Z

1

Label2.Text will not be an integer.

Convert it to an integer.

cmd.Parameters.Add("@dummy", SqlDbType.Int).Value = int.Parse(Label2.Text);

answered Sep 14, 2012 at 9:17

Arran

25.1k6 gold badges71 silver badges78 bronze badges

2 Comments

Arran Over a year ago

What does Label2.Text have in it?

Clarify Seeker Over a year ago

It has hold a session from previous page which is ID.

RL89 · Accepted Answer · 2012-09-14 09:17:26Z

0

Please update your Sql Statement as:

SqlCommand cmd = new SqlCommand("SELECT [Date],[Day],[Time],Total FROM RSVP WHERE Id = @dummy", conn);

Hope this Helps.

answered Sep 14, 2012 at 9:17

RL89

1,9165 gold badges23 silver badges40 bronze badges

2 Comments

Paul Aldred-Bann Over a year ago

I think you're missing parts of your answer here?

RL89 Over a year ago

@Terric May I know what was missing?

John Woo · Accepted Answer · 2012-09-14 09:26:30Z

0

Are you sure that Label2.Text has a valid integer? Use TryParse to check if label2.Text has a valid value.

int number;
bool result = Int32.TryParse(Label2.Text, out number);

It's much easier to use if the string might not actually contain an integer - it doesn't throw an exception so it's easier to recover from.

answered Sep 14, 2012 at 9:26

John Woo

265k70 gold badges509 silver badges500 bronze badges

Collectives™ on Stack Overflow

Error while display data from from SQL

5 Answers 5

Comments

7 Comments

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

7 Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related