MySql.Data.MySqlClient.MySqlException (0x80004005)

               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 > 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();

                }

      

I am getting sql error about dr = cmd.ExecuteReader();

Error message:

 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& affectedRow, Int64& insertedId) at 
MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 
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

      

0


source to share


1 answer


MySqlClient expects ?

char parameter instead@

Also I'm not sure what 1

is a valid parameter name. Try to use?p_1



Finally, as RhysW stated, in your DELETE statement, )

there is an extra ')

in your SELECT statement

+3


source







All Articles