ASP.Net 调用输出参数的存储过程

数据库字段：Id,NickName 

 

 

数据库存取过程：

 //创建

create proc getNickName
@nick varchar(5) output,
@id int
as
 select @nick=NickName from users where id=@id
go

 

 

//测试
declare @nick varchar(5)
exec getNickname @nick output,10000
print @nick

 

 

 

 

 

 

 //根据ID查询NickName字段内容，采用输出参数的存储过程方法

 

　 protected void btnSearch_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("server=.;database=myqq;uid=sa;pwd=123"); conn.Open(); SqlCommand cmd = new SqlCommand("getNickName",conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter[] para = { new SqlParameter("@nick",SqlDbType.VarChar,5,ParameterDirection.Output,false,0,0,string.Empty,DataRowVersion.Default,null),new SqlParameter("@id",SqlDbType.Int) }; para[0].Value = ParameterDirection.Output; para[1].Value = this.txtkey.Text; cmd.Parameters.AddRange(para); cmd.ExecuteNonQuery(); conn.Close(); this.lblResult.Text = Convert.ToString(cmd.Parameters[0].Value); }