Can anyone show me an example of how to connect to SQL server and retrieve a recordset for my asp.net page?

Cheers.