如何使用VB.NET从SQL Server中的存储过程读取输出参数 [英] How to read output parameter from stored procedure in SQL server using VB.NET
问题描述
请告诉我..
如何使用VB.net从sql server中的存储过程读取输出参数
这里是代码对于商店程序
我正在尝试..
USE [SMSEmailScheduler]
GO
/ ******对象：StoredProcedure [dbo]。[GetApplicationsDetails]脚本日期：04/20/2016 14:33:29 ****** /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
更改程序[ dbo]。[GetApplicationsDetails]
- 在这里添加存储过程的参数
@TotalApplications整数输出，
@ActiveApplications整数输出，
@BlockedApllications整数输出，
@TemporaryBlocked整数输出
AS
BEGIN
- DECLARE @TotalApplications整数
- DECLARE @ActiveApplications整数
- DECLARE @BlockedApllications整数
- DECLARE @T emporaryBlocked整数
SELECT @ TotalApplications = COUNT（*）
FROM tblApplication
SELECT @ ActiveApplications = COUNT（*）
FROM tblApplication
WHERE ServiceStatusID = 0
SELECT @ BlockedApllications = COUNT（*）
FROM tblApplication
WHERE ServiceStatusID = 1
SELECT @ TemporaryBlocked = COUNT（ *）
FROM tblApplication
WHERE ServiceStatusID = 2
- 返回@TotalApplications
结束
我的尝试：
我有一个ApplicationSettings表。
每个应用程序都有一个状态（Active，Bolocked，Temporary Blocked等）
我想对每个状态的应用程序。
Please tell me..
How to read output parameter from stored procedure in sql server using VB.net
here is code for store procedure
that i am trying..
USE [SMSEmailScheduler]
GO
/****** Object: StoredProcedure [dbo].[GetApplicationsDetails] Script Date: 04/20/2016 14:33:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetApplicationsDetails]
-- Add the parameters for the stored procedure here
@TotalApplications Integer OUTPUT,
@ActiveApplications Integer OUTPUT,
@BlockedApllications Integer OUTPUT,
@TemporaryBlocked Integer OUTPUT
AS
BEGIN
-- DECLARE @TotalApplications Integer
-- DECLARE @ActiveApplications Integer
-- DECLARE @BlockedApllications Integer
-- DECLARE @TemporaryBlocked Integer
SELECT @TotalApplications= COUNT(*)
FROM tblApplication
SELECT @ActiveApplications= COUNT(*)
FROM tblApplication
WHERE ServiceStatusID=0
SELECT @BlockedApllications= COUNT(*)
FROM tblApplication
WHERE ServiceStatusID=1
SELECT @TemporaryBlocked= COUNT(*)
FROM tblApplication
WHERE ServiceStatusID=2
--Return @TotalApplications
END
What I have tried:
I Have a ApplicationSettings table.
Each Application has a status(Active, Bolocked, Temporary Blocked etc)
I want to Counter for each status of Applications.
推荐答案
请参阅以下示例：
如何从Store程序中检索输出参数并在vb.net中获取值？ [ ^ ]
< a href =https://support.microsoft.com/EN-US/kb/308051> https://support.microsoft.com/EN-US/kb/308051 [ ^ ]
使用oledb从存储过程中检索输出参数命令vb.net - Stack Overflow [ ^ ]
See these examples:
How to retrieve output parameter from Store procedure and get value in vb.net?[^]
https://support.microsoft.com/EN-US/kb/308051[^]
Retrieving output parameter from stored procedure with oledb command vb.net - Stack Overflow[^]
这篇关于如何使用VB.NET从SQL Server中的存储过程读取输出参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
