SQL code for delete Row?

Question

please anyone to explain me what is the problem with following code why didn't delete Table Row.

con.Open();
SqlCommand cmd = new SqlCommand("delete from RentTable where CID = '" + ID + "' and MID = '" + MID + "' )", con);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
    Message = "succsess";
}
else
{
    Message = "!";
}
con.Close();

Answer 1

75% of all these types of problems would be fixed if people loaded their queries into a string variable first then printed them out for debugging purposes :-)

You have a closing parenthesis ) at the end of your query which shouldn't be there.