Create a SQL Datasource in Expression Web

Expression Web has many tools for working with static HTML pages, but it also has tools for creating more dynamic pages. Dynamic pages often retrieve data or content from a source of data. This video demonstrates how to create a SQL Datasource to be used in dynamic pages.
(19 minutes, 11 seconds)
Sample code files 
Video and audio links
Create Site Navigation Based on Site Structure
by Todd Miranda

Most web sites have more than one page, so some type of navigation user interface is needed. A navigation user interface can be some static links to the other pages, or can involve the use of menus or treeviews. No matter how the navigation user interface is implemented, a site's logical structure (also called a site map) must first be defined. Prior to ASP.NET 2.0, developers typically created their own site navigation solutions, which can be time-consuming and expensive to maintain. ASP.NET 2.0 makes defining a site's structure and implementing the navigation user interface much easier. This video demonstrates the use of some ASP.NET 2.0 navigation controls in Expression Web.
(21 minutes, 34 seconds)