OdbcConnection conn = new OdbcConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
conn.Open();
OdbcCommand comm = conn.CreateCommand();
string sql = "call sp_myPro(@a)";
comm.CommandText = sql;
comm.CommandType = CommandType.StoredProcedure;
OdbcParameter para = new OdbcParameter("@a", OdbcType.Int, 11);
para.Direction = ParameterDirection.Output;
comm.Parameters.Add(para);
comm.ExecuteNonQuery();
conn.Close(); string result = para.Value.ToString(); 存储过程
CREATE PROCEDURE `sp_myPro`(OUT param1 INTEGER(11))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
select count(id) into param1 from test;
END;我调用时不会报错,但输出参数的值一直是空的,不知这是什么原因,我因该怎么做,
mySql的的存储过程和msSql有什么区别啊,大家帮一下帮。
conn.Open();
OdbcCommand comm = conn.CreateCommand();
string sql = "call sp_myPro(@a)";
comm.CommandText = sql;
comm.CommandType = CommandType.StoredProcedure;
OdbcParameter para = new OdbcParameter("@a", OdbcType.Int, 11);
para.Direction = ParameterDirection.Output;
comm.Parameters.Add(para);
comm.ExecuteNonQuery();
conn.Close(); string result = para.Value.ToString(); 存储过程
CREATE PROCEDURE `sp_myPro`(OUT param1 INTEGER(11))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
select count(id) into param1 from test;
END;我调用时不会报错,但输出参数的值一直是空的,不知这是什么原因,我因该怎么做,
mySql的的存储过程和msSql有什么区别啊,大家帮一下帮。
(
@userid varchar(30),
@username varchar(100) output
)
asselect @username=username where usercode=@usercode