c#获取存储过程return返回值和output输出参数值

《c#获取存储过程return返回值和output输出参数值》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、C#获取存储过程的Return返回值和Output输出参数值1.获取Return返回值程序代码//存储过程//CreatePROCEDUREMYSQL//    @aint,//    @bint//AS//    return@a+@b//GOSqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());conn.Open();SqlCommandMyCommand=newS

2、qlCommand("MYSQL",conn);MyCommand.CommandType=CommandType.StoredProcedure;MyCommand.Parameters.Add(newSqlParameter("@a",SqlDbType.Int));MyCommand.Parameters["@a"].Value=10;MyCommand.Parameters.Add(newSqlParameter("@b",SqlDbType.Int));MyCommand.Parameters["@b"].Va

3、lue=20;MyCommand.Parameters.Add(newSqlParameter("@return",SqlDbType.Int));MyCommand.Parameters["@return"].Direction=ParameterDirection.ReturnValue;MyCommand.ExecuteNonQuery();Response.Write(MyCommand.Parameters["@return"].Value.ToString());2.获取Output输出参数值程序代码//存储

4、过程//CreatePROCEDUREMYSQL//    @aint,//    @bint,//    @cintoutput//AS//    Set@c=@a+@b//GOSqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());conn.Open();SqlCommandMyCommand=newSqlCommand("MYSQL",conn);MyCommand

5、.CommandType=CommandType.StoredProcedure;MyCommand.Parameters.Add(newSqlParameter("@a",SqlDbType.Int));MyCommand.Parameters["@a"].Value=20;MyCommand.Parameters.Add(newSqlParameter("@b",SqlDbType.Int));MyCommand.Parameters["@b"].Value=20;MyCommand.Parameters.Add(n

6、ewSqlParameter("@c",SqlDbType.Int));MyCommand.Parameters["@c"].Direction=ParameterDirection.Output;MyCommand.ExecuteNonQuery();Response.Write(MyCommand.Parameters["@c"].Value.ToString()); ---------------------------------------------------------------------------

7、------------------------------------ 以下代码转自网络： C#接收存储过程返回值:    publicstaticintUser_Add(Userus)    {        intiRet;        SqlConnectionconn=newSqlConnection(Conn_Str);        SqlCommandcmd=newSqlCommand("User_Add",conn);        cmd.CommandType=CommandType.Stored

8、Procedure;        cmd.Parameters.AddWithValue("@UName",us.UName);        cmd.Parameters.AddWithValue("@UPass",us.UPass);        cmd.Parameters.AddWithValue("@P