无法从MySql执行c#存储过程

Question

In MySql:

DELIMITER //

DROP PROCEDURE IF EXISTS `testdb`.`Check_UserId_Sproc` //
CREATE PROCEDURE `testdb`.`Check_UserId_Sproc` (IN User_Id NVARCHAR(100))
BEGIN
 select count(*) from demo_user where userid = User_Id;
END //

DELIMITER ;

In C#:

public DataTable ExecuteParameterizedSelectCommand(string CommandName, CommandType cmdType,MySqlParameter[] param)
        {
            DataTable table = new DataTable();
            string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

            using(MySqlConnection con = new MySqlConnection(CS))
            {
                using (MySqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = CommandName;
                    cmd.Parameters.AddRange(param);

                    try
                    {
                        if (con.State != ConnectionState.Open)
                        {
                            con.Open();
                        }

                        using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
                        {
                            da.Fill(table);
                        }
                    }
                    catch
                    {
                        throw;
                    }

                    return table;
                }
            }
        }


    public DataTable checkExistingUserId()
            {
                MySqlDBHelper oHelper = new MySqlDBHelper();
                MySqlParameter[] parameters = new MySqlParameter[]
                {
                    new MySqlParameter("User_Id", 'DemoId')
                };
                return oHelper.ExecuteParameterizedSelectCommand("Check_UserId_Sproc", CommandType.StoredProcedure, parameters);
            }

当我尝试执行checkExistingUserId()，时，我会得到以下异常：

Incorrect number of arguments for PROCEDURE testdb.Check_UserId_Sproc; expected 1, got 0

也许我做了一个愚蠢的错误，但我无法弄清楚。我是mysql的新手，我试着解决这个问题。

当我调试时，数组包含了如下图所示的参数，但是SP没有收集它。

​

​

提前感谢

Answer 1

在您的代码中：

cmd.CommandType = CommandType.Text;

应该是

cmd.CommandType = cmdType;