c# - c#查询结果中记录计数

Question

如何获取查询结果中的总记录数

   SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con1"].ConnectionString);
              string sql = "select  Fare , OrderAmount FROM orderitems OI INNER JOIN Orders O ON O.OrderID = OI.OrderID WHERE PaymentStatusID = 1  AND o.orderid ="+Orderid;                 
            SqlCommand comd = new SqlCommand(sql, con1);
               con1.Open();
              comd.ExecuteNonQuery();

以上是我的 sql 查询，我需要结果计数，有人可以帮助我吗提前致谢。

Answer 1

ExecuteNonQuery 用于插入/更新/删除等查询。

使用ExecuteScalar相反:

string sql = "select  count(*) FROM orderitems OI INNER JOIN Orders O ON O.OrderID = OI.OrderID WHERE PaymentStatusID = 1  AND o.orderid ="+Orderid;    
SqlCommand comd = new SqlCommand(sql, con1);
con1.Open();
int count = Convert.ToInt32(comd.ExecuteScalar());