如何从SQL存储过程中获取返回的行集值？

本文介绍了如何从SQL存储过程中获取返回的行集值？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个名为tblReceivedRequest的表。请求有状态，如待处理，收到，失败等。我想计算每个状态。 我无法获得它在我的vb应用程序上。 我为它写了一个商店程序。它给了我一行每个状态的计数。 商店程序代码如下

I have a table having name tblReceivedRequest. Request have a status like pending, recieved, failed etc. i want to get count for each status. I cant able to get it on my vb application. I written a store procedure for it. it gives me a row having a counts for each status. the store procedure code as follows

RETURN SELECT (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=0 AND RequestTypeID =1)as ScheduleMail, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=0 AND RequestTypeID =0)AS ScheduleSMS, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=1 AND RequestTypeID =1)AS SentMail, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=1 AND RequestTypeID =0)AS SentSMS, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=2 AND RequestTypeID =1)AS ExpiredMail, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=2 AND RequestTypeID =0)AS ExpiredSMS, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=3 AND RequestTypeID =1)AS FailedMail, (SELECT COUNT(*) FROM tblRequest WHERE RequestStatusID=3 AND RequestTypeID =0)AS FailedSMS

我的尝试： 我为它写了一个商店程序。它给了我一行对每个状态都有计数。 当我在SQL管理工作室执行它时，上面的sql代码会返回一行。 我想使用dataReader使用vb

What I have tried: I written a store procedure for it. it gives me a row having a counts for each status. the above sql code return a row when I execute it on SQL management studio. I want to get it using dataReader using vb

推荐答案

尝试： Using con As New SqlConnection(strConnect) con.Open() Using cmd As New SqlCommand("spMyStoredProcedure", con) cmd.CommandType = CommandType.StoredProcedure Using reader As SqlDataReader = cmd.ExecuteReader() If reader.Read() Dim scheduleMail As Integer = CInt(reader("ScheduleMail")) Dim scheduleSMS As Integer = CInt(reader("ScheduleSMS")) ... End If End Using End Using End Using