想在存储过程中返回是否出错,回滚,就查了一些资料,以下方不整理一下
Alter proc Sp_AutoTenderTrialAll
@isAuto int ,
@id int,
@AdminId int ,
@AdminName varchar(250),
@output int output
as
Begin
set @output=1
end
/*************C#************/
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{string strsql = string.Format("Sp_AutoTenderTrialAll");
SqlCommand cmd = new SqlCommand(strsql, conn); //链接