asp.net æ§è¡æè¿åå¼çåå¨è¿ç¨ï¼
1ãç¨ParameterDirection.ReturnValue; è¿åå¼
ALTER PROCEDURE [dbo].[CountNumber]
AS
declare @num int
select @num=count(*) from news
return @num
GO
2ãç¨ParameterDirection.Output; åæ°è¿åå¼
ALTER PROCEDURE [dbo].[CountNumber]
@num int output
AS
select @num=count(*) from news
return @num
GO
3ãè°ç¨å¤ä»£ç ï¼
#region 计ç®åºæ°æ®è¡¨çè®°å½æ°
/// <summary>
/// 计ç®åºæ°æ®è¡¨çè®°å½æ°
/// </summary>
/// <returns>è®°å½æ°</returns>
public string CountNumber()
{
cmd = new SqlCommand("CountNumber", GetConn());
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter i= new SqlParameter("@num", SqlDbType.Int);
//i.Direction = ParameterDirection.Output;
i.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(i);
cmd.ExecuteNonQuery();
//int strReturn = i.Value.ToString(); //è¿åå¼--æ¹æ³1
string num = cmd.Parameters["@num"].Value.ToString();
//è¿åå¼--æ¹æ³2
conn.Close();
return num;
}
#endregion
1ãç¨ParameterDirection.ReturnValue; è¿åå¼
ALTER PROCEDURE [dbo].[CountNumber]
AS
declare @num int
select @num=count(*) from news
return @num
GO
2ãç¨ParameterDirection.Output; åæ°è¿åå¼
ALTER PROCEDURE [dbo].[CountNumber]
@num int output
AS
select @num=count(*) from news
return @num
GO
3ãè°ç¨å¤ä»£ç ï¼
#region 计ç®åºæ°æ®è¡¨çè®°å½æ°
/// <summary>
/// 计ç®åºæ°æ®è¡¨çè®°å½æ°
/// </summary>
/// <returns>è®°å½æ°</returns>
public string CountNumber()
{
cmd = new SqlCommand("CountNumber", GetConn());
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter i= new SqlParameter("@num", SqlDbType.Int);
//i.Direction = ParameterDirection.Output;
i.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(i);
cmd.ExecuteNonQuery();
//int strReturn = i.Value.ToString(); //è¿åå¼--æ¹æ³1
string num = cmd.Parameters["@num"].Value.ToString();
//è¿åå¼--æ¹æ³2
conn.Close();
return num;
}
#endregion
温馨提示：内容为网友见解，仅供参考
第1个回答 推荐于2016-08-29
create proc Proc_Test
@x int,@y int output
As
Begin
set @y=@x+2
End
--sql语句
declare @z int
exec Proc_Test 3,@z output
select @z
--在.net调用该存储过程时
static void Main(string[] args)
{
//using System.Data.SqlClient;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source=192.168.6.17;initial catalog=ERPOA;user id=sa;pwd=0077";
SqlCommand cmd = new SqlCommand("Proc_Test", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@x", SqlDbType.Int).Value = 6;
cmd.Parameters.Add("@y", SqlDbType.Int).Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
int outResult = Convert.ToInt32(cmd.Parameters[1].Value);
Console.WriteLine(outResult);
Console.ReadLine();
}
参数这样设置：本回答被提问者和网友采纳
@x int,@y int output
As
Begin
set @y=@x+2
End
--sql语句
declare @z int
exec Proc_Test 3,@z output
select @z
--在.net调用该存储过程时
static void Main(string[] args)
{
//using System.Data.SqlClient;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source=192.168.6.17;initial catalog=ERPOA;user id=sa;pwd=0077";
SqlCommand cmd = new SqlCommand("Proc_Test", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@x", SqlDbType.Int).Value = 6;
cmd.Parameters.Add("@y", SqlDbType.Int).Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
int outResult = Convert.ToInt32(cmd.Parameters[1].Value);
Console.WriteLine(outResult);
Console.ReadLine();
}
参数这样设置：本回答被提问者和网友采纳
第2个回答 2014-02-14
传值的时候指明返回
相似回答
