public IActionResult DeluxRoomCount()
{
string deluxRoom = "select COUNT(type) from Rooms where Type='Delxu' And Avilability='True'";
int count = 0;
using (SqlConnection thisConnection = new SqlConnection("Data Source=HootelReservationDb1"))
{
using (SqlCommand cmdCount = new SqlCommand(deluxRoom, thisConnection))
{
thisConnection.Open();
count = (int)cmdCount.ExecuteScalar();
}
return count;
}
}
我希望會有一些想法來計算 sql 資料，我想了解這段代碼有什么問題
uj5u.com熱心網友回復：
您需要轉換為實作 IActionResult 的驅動器類。嘗試這個。
public IActionResult DeluxRoomCount()
{
string deluxRoom = "select COUNT(type) from Rooms where Type='Delxu' And Avilability='True'";
int count = 0;
using (SqlConnection thisConnection = new SqlConnection("Data Source=HootelReservationDb1"))
{
using (SqlCommand cmdCount = new SqlCommand(deluxRoom, thisConnection))
{
thisConnection.Open();
count = (int)cmdCount.ExecuteScalar();
}
}
return Ok(count)
}
uj5u.com熱心網友回復：
您的方法的回傳型別是 IActionResult，但您回傳的是一個 int，為了使您的方法作業，您需要回傳一個 IActionResult。以下是有關如何執行此操作的一些參考： https ://learn.microsoft.com/en-us/aspnet/core/web-api/action-return-types?view=aspnetcore-6.0
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/524206.html
標籤：C＃。网sql服务器