title: MySql.Data.MySqlClient.MySqlException (0x80004005)
body: <pre><code>               try
                  {
  
                     // Console.WriteLine("wtf");
                      con.ConnectionString = WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString;
                      cmd.Connection = con;
                      cmd.CommandType = System.Data.CommandType.Text;
                      con.Open();
                      cmd.CommandText = "select count(*) from hr WHERE emp_id=@1)";
                      cmd.Parameters.AddWithValue("@1", emp_id);
  
                     dr = cmd.ExecuteReader();
                     int count = 0;
                      while (dr.Read())
                       {
                           count = dr.GetInt32(0);
                       }
                       dr.Close();
                       cmd.Dispose();
                       cmd.Parameters.Clear();
                      if (count &gt; 0)
                      {
  
                          cmd.CommandText = "DELETE FROM hr WHERE emp_id=@1')";
                          cmd.Parameters.AddWithValue("@1", emp_id);
                          cmd.ExecuteNonQuery();
                          res.Write("deleted");
                      }
                      else
                      {
                          res.Write("zero");
                      }
                      con.Close();
  
                  }
  </code></pre>
  
  <p>I am getting sql error near  <code>dr = cmd.ExecuteReader();</code></p>
  
  <p><strong>Error Message :</strong></p>
  
  <pre><code> MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL
   syntax; check the manual that corresponds to your MySQL server version for the right
   syntax to use near ')' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at 
  MySql.Data.MySqlClient.NativeDriver.GetResult(Int32&amp; affectedRow, Int64&amp; insertedId) at 
  MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32&amp; affectedRows, Int64&amp; 
  insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at 
  MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at 
  MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at 
  prod.Controller.HR.HRDel.ProcessRequest(HttpContext context
  </code></pre>