ASP.NET Data Binding in VS.NET

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.

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.

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.

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.

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.

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.

Editing Related Tables in the DataGrid

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

Creating a Hierarchical Drilldown DataGrid

Demonstrates how to create a heirarchical drilldown DataGrid

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!

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.).

Adding Paging to DataGrids

Adding Paging to DataGrids

Formatting Data in a DataGrid

Formatting Data in a DataGrid

Edit Rows in ASP.NET DataGrid

Edit Rows in ASP.NET DataGrid

DropDown in ASP.NET DataGrid

DropDown in ASP.NET DataGrid