From Database to Table

[Iceman5]

I´m trying to read from a database and put the info (name and percent) into a table, where I want the one with highest percent to be at the top.

But I´m not sure on how to read from the database
Can anyone show an example?
I got a database named skitgubbe.mdb

Thanks for answers

[Memnoch1207]

What language are you doing this in?

[Iceman5]

I want a webapplication. So I was thinking on combine asp with VB.
Thanks

[Memnoch1207]

Dim Conn As OleDbConnection
Dim Cmd As OleDbCommand
Dim reader As OleDbDataReader
 
Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\somePath\mydb.mdb;User Id=;Password=;")
Cmd = New OleDbCommand("SELECT fieldName FROM tableName", Conn)
 
Try
        Conn.Open()
        reader = Cmd.ExecuteReader()
 
        While (reader.Read())
              Response.Write(Convert.ToString(reader("fieldName")) & "<br>")
        End While
 
        reader.Close()
        Conn.Close()
Catch ex As Exception
        Response.Write("Error Occurred: " & ex.Message)
End Try