如果我的条件失败rdr.HasRows == true
,我如何回应我的控制器失败
public Employee DeleteEmpById(int key)
{
try
{
SqlCommand cmd = new SqlCommand("Sp_GetEmployeeById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmpId", key);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows == true)
{
}
else
// Here what I mention when rdr.HasRows false
}
控制器
public ActionResult DeleteById(int id)
{
var x = ObjRepo.DeleteEmpById(id);
return View(x);
}
阅读时使用
Bool HasData =False ;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// If there is A row sqlDataReader Will read
HasData =true ;
break; // you only have to check one time , performance improve
}
return HasData
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句