(1)关于存储过程返回值问题(output,ruturn)
output存储过程:
alter proc usp_update
@count int output
as
set @count=(select count(*) from stu)
return存储过程:
alter proc usp_update
as
declare @count int
set @count=(select count(*) from stu)
return @count
.net代码(output):
SqlConnection con = new SqlConnection ("server=95F188CF1A24424;uid=jinzhiyuan;pwd=jinzhiyuan;database=student");
con.Open();
SqlCommand cmd = new SqlCommand("usp_update",con);
cmd.Parameters.Add("@count", SqlDbType.Int);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters["@count"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int j=(int)cmd.Parameters["@count"].Value;
Response.Write("我是刚刚才执行的值:"+j);
con.Close();
.net代码(return)
SqlConnection con = new SqlConnection("server=95F188CF1A24424;uid=jinzhiyuan;pwd=jinzhiyuan;database=student");
con.Open();
SqlCommand cmd = new SqlCommand("usp_update",con);
cmd.Parameters.Add("@count", SqlDbType.Int);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters["@count"].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
int j=(int)cmd.Parameters["@count"].Value;
Response.Write("我是刚刚才执行的值:"+j);
con.Close();