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.net 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
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.net