---
title: "C#获取存储过程返回值和输出参数值"
author: "winzenghua"
date: "2010-06-05T18:20:00Z"
tags: []
slug: "c"
draft: false
lastmod: "2010-06-05T18:20:00Z"
id: 949014
url: "https://java4gis.iteye.com/blog/949014"
---

**1.获取Return返回值**

**![程序代码](http://www.mzwu.com/images/code.gif)** 程序代码

//存储过程  
//Create PROCEDURE MYSQL  
// @a int,  
// @b int  
//AS  
// return @a + @b  
//GO  
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings\["LocalSqlServer"].ToString());  
conn.Open();  
SqlCommand MyCommand = new SqlCommand("MYSQL", conn);  
MyCommand.CommandType = CommandType.StoredProcedure;  
MyCommand.Parameters.Add(new SqlParameter("@a", SqlDbType.Int));  
MyCommand.Parameters\["@a"].Value = 10;  
MyCommand.Parameters.Add(new SqlParameter("@b", SqlDbType.Int));  
MyCommand.Parameters\["@b"].Value = 20;  
MyCommand.Parameters.Add(new SqlParameter("@return", SqlDbType.Int));  
MyCommand.Parameters\["@return"].Direction = ParameterDirection.ReturnValue;  
MyCommand.ExecuteNonQuery();  
Response.Write(MyCommand.Parameters\["@return"].Value.ToString());

**2.获取Output输出参数值**

![程序代码](http://www.mzwu.com/images/code.gif) 程序代码

//存储过程  
//Create PROCEDURE MYSQL  
// @a int,  
// @b int,  
// @c int output  
//AS  
// Set @c = @a + @b  
//GO  
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings\["LocalSqlServer"].ToString());  
conn.Open();  
SqlCommand MyCommand = new SqlCommand("MYSQL", conn);  
MyCommand.CommandType = CommandType.StoredProcedure;  
MyCommand.Parameters.Add(new SqlParameter("@a", SqlDbType.Int));  
MyCommand.Parameters\["@a"].Value = 20;  
MyCommand.Parameters.Add(new SqlParameter("@b", SqlDbType.Int));  
MyCommand.Parameters\["@b"].Value = 20;  
MyCommand.Parameters.Add(new SqlParameter("@c", SqlDbType.Int));  
MyCommand.Parameters\["@c"].Direction = ParameterDirection.Output;  
MyCommand.ExecuteNonQuery();  
Response.Write(MyCommand.Parameters\["@c"].Value.ToString());

\---------------------------------------------------------------------------------------------------------------

以下代码转自网络：

**C#接收存储过程返回值:**

public static int User\_Add(User us)  
{  
int iRet;  
SqlConnection conn = new SqlConnection(Conn\_Str);  
SqlCommand cmd = new SqlCommand("User\_Add", conn);  
cmd.CommandType = CommandType.StoredProcedure;  
cmd.Parameters.AddWithValue("@UName", us.UName);  
cmd.Parameters.AddWithValue("@UPass", us.UPass);  
cmd.Parameters.AddWithValue("@PassQuestion", us.PassQuestion);  
cmd.Parameters.AddWithValue("@PassKey", us.PassKey);  
cmd.Parameters.AddWithValue("@Email", us.Email);  
cmd.Parameters.AddWithValue("@RName", us.RName);  
cmd.Parameters.AddWithValue("@Area", us.Area);  
cmd.Parameters.AddWithValue("@Address", us.Address);  
cmd.Parameters.AddWithValue("@ZipCodes", us.ZipCodes);  
cmd.Parameters.AddWithValue("@Phone", us.Phone);  
cmd.Parameters.AddWithValue("@QQ", us.QQ);  
**cmd.Parameters.Add("@RETURN\_VALUE", "").Direction = ParameterDirection.ReturnValue;**  
try  
{  
conn.Open();  
cmd.ExecuteNonQuery();  
**iRet = (int)cmd.Parameters\["@RETURN\_VALUE"].Value;**  
}  
catch (SqlException ex)  
{  
throw ex;  
}  
finally  
{  
conn.Close();  
}  
return iRet;  
}

**C#接收存储过程输出参数:**

public static decimal Cart\_UserAmount(int UID)  
{  
decimal iRet;  
SqlConnection conn = new SqlConnection(Conn\_Str);  
SqlCommand cmd = new SqlCommand("Cart\_UserAmount", conn);  
cmd.CommandType = CommandType.StoredProcedure;  
cmd.Parameters.AddWithValue("@UID", UID);  
**cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Direction=ParameterDirection.Output;**  
try  
{  
conn.Open();  
cmd.ExecuteNonQuery();  
**iRet = (decimal)cmd.Parameters\["@Amount"].Value;**  
}  
catch (SqlException ex)  
{  
throw ex;  
}  
finally  
{  
conn.Close();  
}  
return iRet;  
}