Last post Mar 21, 2017 03:03 AM by Cathy Zou
Mar 19, 2017 07:53 PM|sid02|LINK
ALTER PROCEDURE [dbo].[pDashboard]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @TotalUSers INT
DECLARE @PendingQuery INT
DECLARE @RepliedQuery INT
SELECT @TotalUSers = COUNT(*)
SELECT @PendingQuery = COUNT(*)
WHERE QueryReply is null
SELECT @RepliedQuery = COUNT(*)
WHERE QueryReply is not null
SELECT @TotalUSers as TOTALUSERS,
@PendingQuery as PENDINGQUERY,
@RepliedQuery as RepliedQuery
I have created a store procedure in which there are 2 tables "register" &"USerQuery" in db. i want to display user details in grid view as well as total count in dashboard or label but don't know how to display in asp.net so please send me code
Mar 21, 2017 03:03 AM|Cathy Zou|LINK
From your description, I am not clear about what is you want to do.
Would you please explain for me on the following question?
there are 2 tables "register" &"USerQuery" in db
1. what is structure of your 2 tables "register" &"USerQuery" in db.
i want to display user details in grid view as well as total count in dashboard or label
2."user details" means what ? "total count" for which column?
dashboard or label
3.dashboard is what in your concept ?
4. You also could display what result is what you want.