return uniqe row
SELECT DISTINCT [ArticleId], [ArticleTitle] FROM [BlogArticles]
sql data getting avg and count data
SELECT ArticleId, AVG(CONVERT(decimal(4, 2), RateNumber)) AS AvgRating, SUM(RateNumber) AS ExprSumRateNumber, COUNT(ArticleId) AS CountArticleId
FROM BlogRating
WHERE (ArticleId = @ArticleId)
GROUP BY ArticleId
displaying in item temp…
<ItemTemplate> <li> <a href='posts/<%# DataBinder.Eval(Container.DataItem, "ContentID") %>.aspx'> <%# DataBinder.Eval(Container.DataItem, "Title") %>