显示总数没有。侧栏上的某个类别中的帖子 [英] display total no. of posts in a category on sidebar
本文介绍了显示总数没有。侧栏上的某个类别中的帖子的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在侧边栏上显示类别列表,其中包含总帖子数。
例如:如果类别体育下有40个帖子,则应显示为 - >体育(40)
请帮助我们坚持这个
解决方案
检查以下代码....
DECLARE @ Cat 表(CatID INT ,CatDesc VARCHAR ( 200 ))
DECLARE @ TranDtls 表(CatID INT ,PostCount INT )
INSERT INTO @ Cat (CatID,CatDesc)
SELECT 1 ,' Sports'
UNION ALL SELECT 2 ,' 帐户'
UNION ALL SELECT 3 ,' IT'
UNION ALL SELECT 4 ,' General'
INSERT INTO @ TranDtls (CatID,PostCount)
SELECT 1 , 10
UNION ALL SELECT 1 , 1
UNION ALL SELECT 1 , 3
UNION 所有 SELECT 2 , 1
UNION ALL SELECT 2 , 5
UNION ALL SELECT 4 , 16
SELECT C.CatDesc + ' (' + CAST(ISNULL(T.PostCount, 0 )< span class =code-keyword> AS VARCHAR ( 20 ))+ ' )' AS 类别
< span class =code-keyword> FROM @ Cat C
LEFT OUTER JOIN ( SELECT CatID,SUM( PostCount)' PostCount' FROM @ TranDtls GROUP BY CatID)T ON T.CatID = C.CatID
- 注意:如果每个类别帖子都有单一条目,请使用COUNT函数。
问候,
GVPrabu
选择 count(sportID) as SportCount 来自 sportTable
为数据提供标签...... :)
label1.Text = Datatable1.Rows [ 0 ] [ SportCount]。toString();
i want to display category list on my sidebar with count of its total posts.
for ex: if there are 40 posts under category sports it should display like --> Sports(40)
pls help guys i'm stuck with this
解决方案
Hi,
Check the below Code....
DECLARE @Cat TABLE(CatID INT, CatDesc VARCHAR(200)) DECLARE @TranDtls TABLE (CatID INT, PostCount INT) INSERT INTO @Cat(CatID, CatDesc) SELECT 1, 'Sports' UNION ALL SELECT 2,'Accounts' UNION ALL SELECT 3,'IT' UNION ALL SELECT 4,'General' INSERT INTO @TranDtls (CatID, PostCount ) SELECT 1,10 UNION ALL SELECT 1,1 UNION ALL SELECT 1,3 UNION ALL SELECT 2,1 UNION ALL SELECT 2,5 UNION ALL SELECT 4,16 SELECT C.CatDesc+'('+CAST(ISNULL(T.PostCount ,0) AS VARCHAR(20))+')' AS Category FROM @Cat C LEFT OUTER JOIN (SELECT CatID, SUM(PostCount) 'PostCount' FROM @TranDtls GROUP BY CatID) T ON T.CatID=C.CatID -- Note : In case you have single entry for each category post, Use COUNT Function.
Regards,
GVPrabu
select count(sportID)as SportCount from sportTable
give datasourse to label...:)
label1.Text=Datatable1.Rows[0]["SportCount "].toString();
这篇关于显示总数没有。侧栏上的某个类别中的帖子的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文