To retrieve table count of records in sql and display in total count in web page?

See more:

ASP.NET

Dear all,

I have 1 table that table contain jobs records and cars records

In web page 2 lables, 1 lable display cars count and 2nd lable display jobs count

I write code below:

try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["masthanConnectionString"].ConnectionString);
            con.Open();
           
            string str = "select count(*) from productdetails where Title='cars'";
            
            SqlCommand cmd = new SqlCommand(str, con);
            //cmd.Parameters.AddWithValue("cmd",con);
            Label1.Text = cmd.ExecuteNonQuery().ToString();
            //cmd.ExecuteNonQuery();
            con.Close();
        }
        catch
        {
            //Label1.Text = "";
        }

but i got output -1

in database total cars count 6 but here display -1 only

please reply me what mistake
and i resolve this