更新时间:2022-08-24 11:02:18
异常处理汇总-数据库系列 http://www.cnblogs.com/dunitian/p/4522990.html
后期会在博客首发更新:http://dnt.dkill.net/Article/Detail/313
错误如图,怎么执行都没有自己想要的效果(return掉了,还有个啥???!!!)
处理后:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
if exists( select * from sysobjects where name = 'usp_AllPmsTest' )
drop proc usp_AllPmsTest
go create proc usp_AllPmsTest
@cityName nvarchar(30), @id int output
as begin insert into ShopModelBak values (@cityName,1,1)
set @id=@@identity
select CPName,CName,SName,MType,MName,Mprice from ShopMenu
inner join ShopModel on ShopMenu.MShopId=ShopModel.SId
inner join View_CityData on ShopMenu.MCityId=CId
where CName=@cityName
return ( select count (1) from ShopMenu)
end go declare @total int ,@id int
exec @total=usp_AllPmsTest '滨湖区' ,@id output
select @id Id,@total total
|
ADO.Net
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
var pms = new SqlParameter[]
{
new SqlParameter( "@cityName" , "滨湖区" ),
new SqlParameter( "@id" , SqlDbType.Int),
new SqlParameter( "@total" , SqlDbType.Int)
};
pms[1].Direction = ParameterDirection.Output;
pms[2].Direction = ParameterDirection.ReturnValue;
var list = SQLHelper.ExecuteReader<ShopMenu>( "usp_AllPmsTest" , CommandType.StoredProcedure, pms);
foreach ( var item in list)
{
Console.WriteLine(item.MName + " " + item.MPrice);
}
Console.WriteLine( "刚才插入的ID是:{0},总共{1}条数据" , pms[1].Value, pms[2].Value);
|
相关文章:http://www.cnblogs.com/dunitian/p/5362528.html
本文转自毒逆天博客园博客,原文链接:http://www.cnblogs.com/dunitian/p/5363895.html,如需转载请自行联系原作者