Getting variable from url

Basically I have a product system where on one page it pulls each product from the database, and assigns individual url's for the next .aspx page.

But I can't figure out how to pull that variable from the url so that it can display the correct product info on the viewing product aspx page.

[code=asp]<script runat="server">
sub Page_Load
dim msaccessconnect,query,databasecommunication,readdatabase
        msaccessconnect = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("Database.mdb"))
        msaccessconnect.Open()
        dim id As
        query = "SELECT * FROM Products WHERE Product_ID="
databasecommunication=New OleDbCommand(query,msaccessconnect)
readdatabase=databasecommunicati ...