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