□--------------------...... -------------------------------------------- 假设有存储过程如下: --------------------------------------------- CREATE proc sp_uptmp @tmpName varchar(50),@srcPos varchar(255) as Begin TRAN insert into t_template values(@tmpName,@srcPos) COMMIT return isnull(@@identity,0) GO ------------------------------------------------------------ 在 ado.net 里面获取返回值的方法为(c#): ------------------------------------------------------------ SqlConnection dbconn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand("sp_uptmp",dbconn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter tmpName = cmd.Parameters.Add("@tmpName",SqlDbType.VarChar); SqlParameter srcPos = _cmd.Parameters.Add("@srcPos",SqlDbType.VarChar); SqlParameter rtnval = cmd.Parameters.Add("rval",SqlDbType.Int); tmpName.Direction = ParameterDirection.Input; srcPos.Direction = ParameterDirection.Input; rtnval.Direction = ParameterDirection.ReturnValue; tmpName.Value = ""; srcPos.Value = ""; dbconn.Open(); cmd.ExecuteNonQuery(); dbconn.Close(); tmpid = (int)rtnval.Value; //此处即为返回值 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 17:26 , Processed in 0.155280 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.