Hello
I know SQL more than ASP.NET.
In SQL, you can use DISTINCT and COUNT to get number of items of a distinct category.

I can do this in SQL but I want to do in the DataView. Is this possible??
I wanted to count the distinct category in DataSet by DataView rather than to use 5 Stored Procedures for each category of the DataSet.

I thought about passing parameters to Stored Procedure but I thought if this is possible in DataView than it is easier.

All suggestions are welcome.
Thanks.

Yes. Another way to do Count would be to create a label and a Function and do this:

lblCount.Text = countDays()

Private Function countDays()
        Dim strConn As String = ConfigurationSettings.AppSettings("dbLogs")
        Dim objConn As New OleDbConnection(strConn)

        Dim strSQL As String = "SELECT Count(thedate) FROM tableName"

        Dim objCommand As New OleDbCommand(strSQL, objConn)

        Dim sResult As String
        objConn.Open()
        sResult = CType(objCommand.ExecuteScalar(), String)
        objConn.Close()

        Return sResult
End Function

Hey,

Not using the DataView directly, that I know of. You have to use a SQL query.

Brian