How do I retrieve an SQL DataBase table record?

Visual Basic 2005 Express:

I have an SQL DataBase Table called Lab.

The primary key is called LabID.

How do I retrieve the record whose LabID is 4?

There is a column in the record called 'Email'.

How do I pick up the info from that field?

[286 byte] By [furjaw] at [2007-12-25]