110,533
社区成员
发帖
与我相关
我的任务
分享
ALTER proc [dbo].[p_insert]
@name varchar(20),
@sex varchar(20),
@tel varchar(11),
@address varchar(100),
@result int-- output
as
begin
insert into test([name],sex,tel,[address])
values(@name,@sex,@tel,@address);
set @result = @@ERROR
return @result
end
调用:
SqlParameter [] parms=new SqlParameter[]
{
new SqlParameter("@name", txtName.Text),
new SqlParameter("@sex",txtSex.Text),
new SqlParameter("@tel",txtTel.Text),
new SqlParameter("@address",txtAddress.Text) ,
new SqlParameter("@result", ParameterDirection.ReturnValue)
}
;
foreach (var p in parms)
{
cmd.Parameters.Add(p);
}
cmd.ExecuteNonQuery();
int result = Convert.ToInt32(ParameterDirection.ReturnValue);
@result int output
as
begin
insert into test([name],sex,tel,[address])
values(@name,@sex,@tel,@address);
set @result = @@ERROR
--return @result
end
调用:
SqlParameter [] parms=new SqlParameter[]
{
new SqlParameter("@name", txtName.Text),
new SqlParameter("@sex",txtSex.Text),
new SqlParameter("@tel",txtTel.Text),
new SqlParameter("@address",txtAddress.Text) ,
new SqlParameter("@result", ParameterDirection.Output)
}
;
foreach (var p in parms)
{
cmd.Parameters.Add(p);
}
cmd.ExecuteNonQuery();
int result = Convert.ToInt32(cmd.Parameters["@result"].Value);