I'm trying to get a grasp of how to perform basic database functions within VB.Net. Can someone please provide a simple example of how to:
Open a SQL database
Perform a simple "SELECT *" query
Loop through the result set one record at a time
Perform a conditional on a datafield (e.g.: IF "datafield" = 1 THEN)
Close the database
Generic code examples would work fine.
Also, which project references would I need to include in my VB.Net app.