Select and Display database records in ASP.NET

How to connect to a database and access records is a piece of functionality that most web developers (be it Classic ASP, PHP, PERL, ASP.NET) have to contend with a on a regular basis. Actually, any developer who has ever built a dynamic site (and we're talking multi-millions here) has found themselves working with data stored in a database. "But I just want to know how to do it with ASP.NET" I heard you say... Good, because I'm about to show you how in simple, common sense terms. In fact, this article is specifically written from a Classic ASP developer's perspective....that is, developers who are not familiar with ASP.NET and its alien concepts of objects, classes, controls and what-not. So let's get stuck into it shall we...