DataBinding allows you to create powerful applications quickly, however you should know what happens behind-the-scenes and how to harness this power. This series shows you how to take advantage of the visual designers, objects, properties and methods and make this such as poweful tool for web developers.

Videos in this series:

1. Walkthrough: Creating a Databound DataGrid

   This video demonstrates all the steps necessary to data bind a table to a data source. There is a lot of benefit to this approach, not the least of which is the speed of application development and the use of wizards and property windows to fully configure the appearance and functionality of the data grid.

2. Creating a DataConnection

   This video demonstrates how to create a connection to a data source using only the Visual Studio.NET IDE. It thoroughly covers the Data Link Properties dialog and the use of the Server Explorer to create connections. Finally, the ADO.NET code that is generated by this technique is explored.

3. Creating and Configuring a Data Adapter

   DataAdapters are the bridge between a DataCommand object and a DataSet object. This video shows how to use the Server Explorer to create an instance of a DataAdapter on a Web Form. It shows how to use the Data Adapter Configuration Wizard, and explains what each of the settings are used for. Finally, we look at all the code that was generated and briefly highlight how it works together to perform operations on a datasource.

4. Using the Query Builder

   The Query Builder allows you to easily create SQL statements for use in the Data Adapter Configuration Wizard and other places within the IDE. This video shows you some tricks on how to get the most from this tool.

5. Creating, Testing and Using a DataSet from a DataAdapter

   Once you have a DataAdapter configured, you can automatically create a DataSet based on the SQL Select statement in the DataAdapter. This video demonstrates how to create and configure a DataSet created in this fashion. It also demonstrates the use of the Data Adapter Preview dialog that allows you to test that the DataSet and DataAdapter are working correctly.

6. Binding Related Tables in the DataGrid

   If you need to show values in a DataGrid, but those values come from different (related) tables, you must take the steps outlined in this video. This shows how to use a TemplateColumn and an ItemTemplate element to customize how and what is displayed in a given column of your DataGrid.

7. Editing Related Tables in the DataGrid

   Demonstrates how to add a drop down listbox in edit mode to a related DataTable of values

8. Creating a Hierarchical Drilldown DataGrid

   Demonstrates how to create a heirarchical drilldown DataGrid

9. Creating a Master / Detail Application

   This video walks you through how to create an entire application based on the Employee table of the Pubs database to populate a DataGrid. When you select a row in the DataGrid, the details of that record will be displayed and editable from a sub-form on the same page. Many important topics are covered, such as DataGrid paging, capturing Row Selected events from a DataGrid, populating DataBound DropDownLists, updating DataSets, and much more!

10. Creating an NTier Multipage Master/Detail App

    Demonstrates how to create an NTier app, with two pages (one page a list of Employees, the other a detail page that allows Add, Update, etc.).

11. Adding Paging to DataGrids

    Adding Paging to DataGrids

12. Formatting Data in a DataGrid

    Formatting Data in a DataGrid

13. Edit Rows in ASP.NET DataGrid

    Edit Rows in ASP.NET DataGrid

14. DropDown in ASP.NET DataGrid

    DropDown in ASP.NET DataGrid