Question

c#.NET如何调用存储过程,还有就是如何调用,输出返回值?

ALTER PROCEDURE [dbo].[addCate]
-- Add the parameters for the stored procedure here
@error int output,
@cateID bigint,
@cate varchar(100)
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
if not exists(select * from bookcategory where cateID=@cateID or category=@cate)
BEGIN
insert into bookcategory(cateID,category) values(@cateID,@cate)
set @error=1

return @error
END
else
BEGIN
set @error=0
return @error
end

存储过程设计是这样,用的时候老是说要提供参数,我只是想看那个返回值判断是否插入成功而已!

Answer 1

conn = GetConnection();
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "存储过程名字";
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
p.Direction = ParameterDirection.Output;
cmd.Parameters.add(s);

cmd.exenonquery();
string value=s.value.toString();
}

Answer 2

判断是否插入成功,不用这么做吧！“@error int output”这个参数不要。传“@cateID bigint,
@cate varchar(100)
”这两个参数进去就好，再用int flag = cmd.exenonquery()来执行,falg>0的话就插入成功了