SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandText = "select * from CounterValues";
sqlcom.ExecuteNonQuery()
我怎么判断
select * from CounterValues执行的返回记录集行数呢?
其实我就是想在这里就判断然后做处理
if(记录集为空){
}else{
}
------解决方案--------------------------------------------------------
SqlDataReader myReader = sqlcom .ExecuteReader();
if (myReader.Read())
{}
else
{
}
------解决方案--------------------------------------------------------
- C# code
SqlCommand sqlcom = new SqlCommand(); sqlcom.CommandText = "select Count(*) from CounterValues "; object obj = sqlcom.ExecuteScalar();if (obj != null && Convert.ToInt32(obj) > 0){ '有记录}else{ '无记录}