Working C# code for MySql5.5 Stored Procedures IN parameters

MySQL5.5存储过程:

?

1 2 3 4 5 6 7 8

#插入一条  涂聚文 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 ;

　　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

///<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;        }

　　

?

1	using MySql.Data; //6.9.5.0  涂聚文注释,装的5.5的MYSQL版本,而要调用更高版本Connector/Netusing MySql.Data.MySqlClient;