简单实现查询记录数

[artcodeman]

string sql = "select * from News order by ID desc" ;
SqlCommand cmd = new SqlCommand(sql ,Conn);
SqlDataReader Dr = cmd.ExecuteReader();

在这个基础上怎样修改可得到查询的记录数

[jiangshun]

？？
这个问题.........

[Riverwcj]

string sql = "select count(*) from News order by ID desc" ;
SqlCommand cmd = new SqlCommand(sql ,Conn);
SqlDataReader Dr = cmd.ExecuteReader();

[灰鸟会灰]

foreach(var a in Dr)
{
i++;
}

[lzf1988119]

在 while SqlDataReader 时，声明i
叠加i 就ok 了
更一般性的做法是
返回List
得到List的记录数

[artcodeman]

string sql = "select count(*) from News order by ID desc" ; 
SqlCommand cmd = new SqlCommand(sql ,Conn); 
SqlDataReader Dr = cmd.ExecuteReader(); 

这样如何获取记录数 是不是sql语句应该改成
string sql = "select count(*) as total from News order by ID desc" ;

然后Dr["total"]就是记录数

[war_zhong]

int i=0;
while (dr.read())
{
i++;
}

[zhujinbo]

string strSql = "select Count(*) from News order by ID desc";
SqlCommand myCmd = new SqlCommand(strSql, myConn);
int recordCount = int.Parse(myCmd.ExecuteScalar().ToString());这句就是获取查询数据的条数