ADO.NET Part 1

First Step is connecting to the servers, both http and sql.

This is done in the Server Explorer. For a local connection with Management Studio Express, use server name:
localhost\SQLEXPRESS

then the test db I got from the Microsoft site:
pubs

and success. Tables are listed under Data Connections in the Server Explorer.
left click shows table definition, right click shows table data.

Using the command line results in plenty of Select, Update, Insert and Delete queries.