Working C# code for MySql5.5 Stored Procedures IN parameters_.NET_编程开发_程序员俱乐部

MySQL5.5存储过程:

class="brush:sql;gutter:true;">#插入一条  涂聚文
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;