索引问题 在线等

Question

       /// <summary>
        /// 查询prod_news表中有多少条记录
        /// </summary>
        /// <returns>返回记录总数</returns>
        public int Get_prod_news_Count()
        {
            try
            {
                string sqlStr = "select count(*) from prod_news";
                OleDbCommand cmd = new OleDbCommand(sqlStr, con);
                int count = 0;
                List<prod_news> list = new List<prod_news>();
                con.Open();
                OleDbDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    prod_news prodnews = new prod_news();
                    prodnews.title = reader["title"].ToString();
                    list.Add(prodnews);
                }
                count = list.Count();
                return count;
            }
            catch (Exception ee)
            {                throw ee;
            }
            finally
            {
                con.Close();
            }
连接的是ACCESS数据库  这是怎么回事 帮忙看看哪儿写错了  我是新手菜鸟~~~

Answer 1

  con.Open();
  count=(int)cmd.ExecuteScalar();其他不相关的都不要。

Answer 2

string sqlStr = "select count(*) from prod_news";
改成
string sqlStr = "select * from prod_news";
试试
因为你用的cmd.ExecuteReader()或者
你如果要用string sqlStr = "select count(*) from prod_news"
可以直接
count = Convert.ToInt32(cmd.Executescalar());