获取输出十进制值 [英] To get output decimal val

问题描述

如何通过参数化存储过程获取输出十进制值?
请有人帮助我..

How will i get output decimal value through parameterize store procedure??
please anybody help me..

推荐答案

尝试以下方法:


存储过程-输出参数&返回值 [ ^ ]

Try This One:


Stored Procedures - Output Parameters & Return Values[^]

create procedure SPName
(
  @par1 int,
  @outParameter varchar output
)
as 
begin
   --insert upadate query or whatever
   --assign value to outparameter
   set   @outParameter='1.1'

end

在后面的代码中

使用这样的代码

in code behind

use code like this

SqlParameter outParameter = new SqlParameter("@outParameter", SqlDbType.VarChar, 255); 
                outParameter.Direction = ParameterDirection.InputOutput;
                outParameter.Value = "";
                _sqlCmd.Parameters.Add(outParameter);
                _sqlCmd.ExecuteScalar();
                _transaction.Commit();
//to get value of out parameter
string outvalue = _sqlCmd.Parameters["@outParameter"].Value.toString();

希望对您有帮助
祝你好运

Hope it will help
Good Luck

这篇关于获取输出十进制值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！