SQL DATAREADER saying varchar to numeric

[kidkardel]

Hello again, I am now encountering the above problem.
i dunno what to do and tried everything.
my Column for Capital is decimal so i dunno why it is saying varchar.
my codes are

 con.ConnectionString = //insert data source;
  if (con.State != ConnectionState.Closed)
            {
                con.Close();
            }
            cmd.Connection = con;
  cmd.CommandText = "SELECT CAPITAL FROM TblProduct WHERE Description='" + descd.Text + "'and Price='" +upd.Text + "'";
            con.Open();
            dr = cmd.ExecuteReader();
             int cap_d = dr.GetOrdinal("CAPITAL");
            while (dr.Read())
            {
                cap_dvalue.Text = Convert.ToString(dr[cap_d]);
            }
                con.Close();
            dr.Close();

[ChrisHunter]

It's because you trying to put a string, descd.Text, into your decimal parameter without converting it.

Convert.ToDecimal(descd.Text);

[kidkardel]

But my description column is a string so I am calling it by a string, my capital is the one oon decimal also my description is not a number

[ChrisHunter]

Sorry I completely missread your code.

[Fenrir()]

As depicted above. try inserting a breakpoint in your code on line 7

cmd.CommandText = "SELECT CAPITAL FROM TblProduct WHERE Description='" + descd.Text + "'and

Hover over the CommandText and look for a magnifying glass. Copy and paste the code into SQL and try executing it there and see if it runs without errors.

[isozworld]

Change your code like below

 con.ConnectionString = //insert data source;
  if (con.State != ConnectionState.Closed)
            {
                con.Close();
            }
            cmd.Connection = con;
  cmd.CommandText = "SELECT CAPITAL FROM TblProduct WHERE Description='" + descd.Text + "'and Price='" +upd.Text + "'";
            con.Open();
            dr = cmd.ExecuteReader();

            while (dr.Read())
            {
                cap_dvalue.Text = dr.GetString(0);
            }
                con.Close();
            dr.Close();

[isozworld]

And also, close your dataReader before connection.