Question

(c#)怎么得到存储过程中的输出参数?求例子!

RT````

Answer 1

.....
SqlCommand comm=new SqlCommand ();
comm.CommandType=CommandType.StoredProcedure;
comm.CommandText=pro_name;
comm.Connection=Conn;
SqlParameter para1=new SqlParameter ("@bianhao",SqlDbType.NVarChar,20);
para1.Direction=ParameterDirection.Output;

comm.ExecuteNonQuery();
conn.Close();
label1.Text=comm.Parameters["@bianhao"].Value.ToString();///此处将存储过程的返回参数取出

Answer 2

//连接SQL SERVER
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstr"].ToString());
//实例化SqlCommand
SqlCommand cmd = new SqlCommand("CheckManager", conn);
cmd.CommandType = CommandType.StoredProcedure;
//增加sql语句需要的参数
SqlParameter pUserID = new SqlParameter("@ManagerName", SqlDbType.NVarChar);
pUserID.Value = TxtUserID.Text.Trim();
Session["Name"] = TxtUserID.Text.Trim();
cmd.Parameters.Add(pUserID);
SqlParameter pUserPSW = new SqlParameter("@ManagerPSW", SqlDbType.NVarChar);
pUserPSW.Value = TxtUserPSW.Text.Trim();
//Session["UserPSW"] = TxtUserPSW.Text.Trim();
cmd.Parameters.Add(pUserPSW);

Answer 3

create proc getPP
@cout int output,
@name varchar(50)
as
select @cout = count(id) from tab_name where p_name = @name

Answer 4

print 出来的不行
可以见个临时表记录数据
在返回就行了