Working C# code for MySQL5.5 Stored PRocedures IN parametersMySQL5.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;