Display count of Stock in DropDownList using C# in ASP.Net

micah says:

if (!this.IsPostBack)

        {

            string Constr1 = ConfigurationManager.ConnectionStrings["db"].ConnectionString;

            using (SqlConnection CONNE = new SqlConnection(Constr1))

            {

                using (SqlCommand C0MMDE = new SqlCommand("SELECT Count Quantity FROM SixInchesSolHollowMachMoldNkwereStore "))

                {

                    C0MMDE.Parameters.AddWithValue("@Quantity", this.ddlstock.SelectedValue.Trim());

 

                    C0MMDE.Parameters.AddWithValue("@UserName", Session["userName"]);

                    C0MMDE.CommandType = CommandType.Text;

                    C0MMDE.Connection = CONNE;

                    CONNE.Open();

                    ddlstock.DataSource = C0MMDE.ExecuteReader();

                    // ddlProductCode.DataValueField = "ProductID";

                    ddlstock.DataTextField = "Quantity";

                    // ddlProductCode.DataValueField = "UserName";

 

                    ddlstock.DataBind();

                    CONNE.Close();

                }

            }

            // ddlstock.Items.Insert(0, new ListItem("-- Stock--", "0"));

        }

 replace above code with below.

if (!this.IsPostBack)
{
    string Constr1 = ConfigurationManager.ConnectionStrings["db"].ConnectionString;
    using (SqlConnection CONNE = new SqlConnection(Constr1))
    {
        using (SqlCommand C0MMDE = new SqlCommand("SELECT Count(Quantity) Quantity FROM SixInchesSolHollowMachMoldNkwereStore "))
        {
            C0MMDE.CommandType = CommandType.Text;
            C0MMDE.Connection = CONNE;
            CONNE.Open();
            ddlstock.DataSource = C0MMDE.ExecuteScalar();
            // ddlProductCode.DataValueField = "ProductID";
            ddlstock.DataTextField = "Quantity";
            // ddlProductCode.DataValueField = "UserName";

            ddlstock.DataBind();
            CONNE.Close();
        }
    }
    // ddlstock.Items.Insert(0, new ListItem("-- Stock--", "0"));
}