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") %> </a> (<%# DataBinder.Eval(Container.DataItem, "AvgRating", "{0:0.00}")%> | <%# DataBinder.Eval(Container.DataItem, "TotalCount")%>)</li> </ItemTemplate>
counting rows
Dim dv As DataView
Dim value As Integer
dv = CType(SqlDataSourceRatingCount.Select(DataSourceSelectArguments.Empty), DataView)
value = dv.Count
LabelTest.Text = value