How do I connect to a database and loop over a recordset in C#?

Asked 2008-08-04T00:47:25.143

What's the simplest way to connect and query a database for a set of records in C#?