Working C# code for MySQL5.5 Stored PRocedures IN parameters

MySQL5.5存儲過程:

#插入一條  涂聚文DELIMITER $$DROP PROCEDURE IF EXISTS `geovindu`.`proc_Insert_BookKindList` $$CREATE PROCEDURE `geovindu`.`proc_Insert_BookKindList` (IN param1Name NVarChar(1000),IN param1Parent Int)BEGIN        insert into BookKindList(BookKindName,BookKindParent) values(param1Name,param1Parent);END $$DELIMITER ;

 ///<summary>        /// 追加記錄        ///</summary>        ///<param name="BookKindListInfo"></param>        ///<returns></returns>        public int InsertBookKindList(BookKindListInfo bookKindList)        {            int ret = 0;            try            {                MySqlParameter[] par = new MySqlParameter[]{new MySqlParameter("?param1Name",MySqlDbType.VarChar,1000),new MySqlParameter("?param1Parent",MySqlDbType.Int32,4),};                par[0].Value = bookKindList.BookKindName;                par[1].Value = bookKindList.BookKindParent;                ret = MySqlHelpDu.ExecuteSql("proc_Insert_BookKindList", CommandType.StoredProcedure, par);            }            catch (MySqlException ex)            {                throw ex;            }            return ret;        }

using MySql.Data; //6.9.5.0  涂聚文注釋,裝的5.5的MYSQL版本,而要調用更高版本Connector/Net

using MySql.Data.MySqlClient;