Hi

I wont to extract data from DataSet. I don't wont to bind data to data grid I just wont to calculate average rating from row.
I have code

Private Sub UpdateLabels()
        Dim ds As New Knjizara.DBase
        Dim CmdText As String = "SELECT SUM(rating), COUNT(*) FROM Ratings WHERE BokNummer = " & Session("Vote")
        ds.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\Books\books1.mdb"
End Sub

Now I wont to get rating from DataSet.

Thanks

I have solved this part of the problem but now i wonder how to get values from columns. Here is my code:
   Private Sub UpdateLabels()
        Dim ds As New Knjizara.DBase
        Dim CmdText As String = "SELECT SUM(rating), COUNT(*) FROM Ratings WHERE BokNummer =" & Session("Vote")
        ds.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\Books\books1.mdb"
        ds.ExecuteNonQuery(CmdText)
        Dim value = ds.FillDataSet(CmdText).Tables(0).Columns(0).ToStr ing
        Dim count = ds.FillDataSet(CmdText).Tables(0).Columns(1).ToStr ing
Dim avg = value/count
        Me.AverageLabel.Text = avg
    End Sub

But now I get message that input string is not in correct format.

Thanks

Please, someone hwo can show mw how to get values from columns. I badly need that
Thanks

Have solution for problem
Thanks anyway