cs.mfalac.com

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

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.Web.Script.Services
Imports AjaxControlToolkit
Imports System
Imports System.Collections.Generic
Imports System.Collections.Specialized
Imports System.Data.SqlClient

<WebService(Namespace:="http://tempuri.org/")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
<System.Web.Script.Services.ScriptService()> _
Public Class CascadingDropdown1
    Inherits System.Web.Services.WebService

    Public Function GetVendors(ByVal knownCategoryValues As String, ByVal category As String) As CascadingDropDownNameValue()
        Dim conn As New SqlConnection("server=")

        conn.Open()
        Dim comm As New SqlCommand( _
        "SELECT TOP 25 ArticleId, ArticleTitle FROM BlogArticles", conn)
        Dim dr As SqlDataReader = comm.ExecuteReader()
        Dim l As New List(Of CascadingDropDownNameValue)
        While (dr.Read())
            l.Add(New CascadingDropDownNameValue(dr("ArticleTitle").ToString(), dr("ArticleId").ToString()))
        End While
        conn.Close()
        Return l.ToArray()
    End Function

End Class