Error - Control cannot leave the body of finally clause

Ramco Ramco

public int Delete(string Id)
{
int result = 0;
try
{
using (SqlConnection con = new SqlConnection(Common.Con))
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_Product", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", Id);
cmd.Parameters.AddWithValue("@Action", "D");
result = cmd.ExecuteNonQuery();
//return result;
}
}
catch (Exception ex)
{
ExceptionLogging.SendExcepToDB(ex);
return -1;
}
finally
{
return result;
}

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
1. public int Delete(string Id)
2. {
3. int result = 0;
4. try
5. {
6. using (SqlConnection con = new SqlConnection(Common.Con))
7. {
8. con.Open();
9. SqlCommand cmd = new SqlCommand("sp_Product", con);
10. cmd.CommandType = CommandType.StoredProcedure;
11. cmd.Parameters.AddWithValue("@Id", Id);
12. cmd.Parameters.AddWithValue("@Action", "D");
13. result = cmd.ExecuteNonQuery();
14. }
15. }
16. catch (Exception ex)
17. {
18. ExceptionLogging.SendExcepToDB(ex);
19. return -1;
20. }
21. finally
22. {
23. // as per your code finally block not needed, your also using using block
24. }
25. return result;
26. }
Madan Shekar5y ago
It is a reserved keyword in C#. The finally block will execute when the try/catch block leaves the execution, no matter what condition cause it. It always executes whether the try block terminates normally or terminates due to an exception. The main purpose of finally block is to release the system resources.