count(*)计算 ExecuteScalar

        /// <summary>
        /// count(*)计算  ExecuteScalar
        /// </summary>
        /// <returns></returns>
        public static int sqlScalar()
        {
            int a = 0;

            string conString = "data source=.;database=Codematic;user=sa;password=123";
            SqlConnection myConnection = new SqlConnection(conString);
            string sql = "select count(*) from p_product";
            SqlCommand cmd = new SqlCommand(sql, myConnection);

            myConnection.Open();
            a = (int)cmd.ExecuteScalar();
            myConnection.Close();
            return a;
        }