我有一个名为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
更多推荐
如何从SQL存储过程中获取返回的行集值?
发布评论