本文介绍了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();
}
我在 dr = cmd.ExecuteReader();
错误信息:
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
推荐答案
MySqlClient 需要 ? 参数 char 而不是 @
MySqlClient expects ? parameter char instead of @
此外，我不确定 1 是否是有效的参数名称.尝试使用 ?p_1
Also I am not sure if 1 is a valid parameter name. Try using ?p_1
最后，正如 RhysW 所说，在你的 DELETE 语句中有一个额外的 ') 和你的 SELECT 语句中有一个 )
Last, as RhysW stated, there is an extra ') in your DELETE statement and ) in your SELECT statement
这篇关于MySql.Data.MySqlClient.MySqlException (0x80004005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！