This is the second post (first) in another collection of posts that have links to the different objectives covered in the 70-528 exam. There is also a series on ASP.NET 3.5 exam 70-562 (here)
Integrating data in a Web application by using ADO.NET, XML, and data-bound controls
- Implement data-bound controls.
- Use tabular data source controls to return tabular data.
- ObjectDataSource
- ObjectDataSource Control Overview
- Using Parameters with the ObjectDataSource Control
- SqlDataSource
- SqlDataSource Web Server Control Overview
- How to: Connect to a SQL Server Database Using the SqlDataSource Control
- How to: Connect to an Access Database Using the SqlDataSource Control
- How to: Connect to an ODBC Database Using the SqlDataSource Control
- How to: Connect to an Oracle Database Using the SqlDataSource Control
- AccessDataSource
- Retrieving Data Using the AccessDataSource Web Server Control
- XmlDataSource
- XmlDataSource Control Overview
- Binding a Tabular Control to the XmlDataSource Control
- Use hierarchical data source controls to display hierarchical data.
- Display data by using simple data-bound controls.
- Display data by using composite data-bound controls.
- GridView
- GridView Web Server Control Overview
- Comparing the GridView and DataGrid Web Server Controls
- Sorting Data in a GridView Web Server Control
- Paging in a GridView Web Server Control
- Modifying Data in a GridView Web Server Control
- GridView Web Server Control Events
- Creating a Custom Column in a GridView Web Server Control
- How to: Set GridView Web Server Control Column Width Dynamically
- DetailsView
- DetailsView Web Server Control Overview
- Paging in a DetailsView Web Server Control
- Modifying Data Using a DetailsView Web Server Control
- Creating a Custom Row in a DetailsView Web Server Control
- DetailsView Web Server Control Events
- FormView
- FormView Web Server Control Overview
- Creating Templates for the FormView Web Server Control
- Paging in a FormView Web Server Control
- Modifying Data Using a FormView Web Server Control
- FormView Web Server Control Events
- Repeater
- Repeater Web Server Control Overview
- How to: Add a Repeater Control to a Web Forms Page
- DataList
- DataList Web Server Control Overview
- How to: Add DataList Controls to an ASP.NET Web Page
- How to: Specify Flow or Table Format in DataList Web Server Controls
- How to: Specify Horizontal or Vertical Layout in DataList Web Server Controls
- How to: Allow Users to Select Items in DataList Web Server Controls
- How to: Allow Users to Edit Items in DataList Web Server Controls
- How to: Allow Users to Delete Items in DataList Web Server Controls
- How to: Respond to Button Events in DataList, Repeater, or GridView Items
- How to: Customize DataList Items at Run Time
- How to: Customize Items Dynamically in the DataList Web Server Control
- How to: Create Templates Dynamically in DataList Web Server Controls
- Display data by using hierarchical data-bound controls.
- Menu
- Menu Web Server Control
- SiteMapPath
- SiteMapPath Web Server Control Overview
- How to: Customize the Appearance of SiteMapPath Web Server Controls
- How to: Filter the Nodes Retrieved by SiteMapDataSource Web Server Controls
- TreeView
- TreeView Web Server Control
- TreeView Web Server Control Events
- Customizing the Look and Feel of the TreeView Web Server Control
- Populating Tree Nodes in the TreeView Web Server Control
- Binding Data to the TreeView Web Server Control
- Selection, Navigation, and Check Boxes in the TreeView Web Server Control
- Using Images with the TreeView Control
- Use the FormView control to display the values of a single table record from a data source.
- Use tabular data source controls to return tabular data.
- Manage connections and transactions of databases.
- Configure a connection to a database graphically by using the Connection Wizard.
- Configure a connection by using Server Explorer.
- Configure a connection to a database by using the connection class.
- Connect to a database by using specific database connection objects.
- Enumerate through instances of Microsoft SQL Server by using the DbProviderFactories.GetFactoryClasses method.
- Open a connection by using the Open method of a connection object.
- Close a connection by using the connection object.
- Secure a connection to protect access to your data source.
- Create a connection designed for reuse in a connection pool.
- Control connection pooling by configuring ConnectionString values based on database type.
- Use connection events to detect database information.
- Handle connection exceptions when connecting to a database.
- Perform transactions by using the ADO.NET Transaction object.
- Create, delete, and edit data in a connected environment.
- Retrieve data by using a DataReader object.
- Build SQL commands visually in Server Explorer.
- How to: Create and Execute an SQL Statement that Returns Rows
- How to: Create and Execute an SQL Statement that Returns a Single Value
- How to: Create and Execute an SQL Statement that Returns No Value
- How to: Execute a Stored Procedure that Returns Rows
- How to: Execute a Stored Procedure that Returns a Single Value
- How to: Execute a Stored Procedure that Returns No Value
- Build SQL commands in code.
- Create parameters for a command object.
- Perform database operations by using a command object.
- Executing a Command
- Working with Command Parameters
- Automatically Generating Commands
- Obtaining a Single Value from a Database
- Retrieve data from a database by using a command object.
- Perform asynchronous operations by using a command object
- BeginExecuteNonQuery
- BeginExecuteReader
- BeginExecuteXmlReader
- EndExecuteNonQuery
- EndExecuteReader
- EndExecuteXmlReader
- Calling Synchronous Methods Asynchronously
- Creating ASP.NET Applications Using Wait Handles
- Perform bulk copy operations to copy data to a SQL Server computer.
- Store and retrieve binary large object (BLOB) data types in a database.
- Create, delete, and edit data in a disconnected environment.
- Create an instance of the DataSet class programmatically.
- Create a DataSet graphically.
- How to: Open a Dataset in the Dataset Designer
- How to: Edit a Dataset
- Walkthrough: Creating a Dataset with the Dataset Designer
- Create a DataSet programmatically.
- Add a DataTable to a DataSet.
- Add a relationship between tables.
- Navigate a relationship between tables.
- Merge DataSet contents.
- Copy DataSet contents.
- Create a strongly typed DataSet.
- Create DataTables.
- Manage data within a DataTable.
- Create and use DataViews.
- Sorting and Filtering Data Using a DataView
- Viewing Data Using a DataView
- Modifying Data Using a DataView
- Working with DataView Events
- Setting Default Table Views Using a DataViewManager
- Represent data in a DataSet by using XML.
- DiffGrams
- Loading a DataSet from XML
- Writing a DataSet as XML Data
- Loading DataSet Schema Information from XML
- Writing DataSet Schema Information as XML Schema (XSD)
- Synchronizing a DataSet with an XmlDataDocument
- Nested DataRelations
- Generating DataSet Relational Structure from XML Schema (XSD)
- Inferring DataSet Relational Structure from XML
- Access an ADO Recordset or Record by using the OleDbDataAdapter object.
- Generate DataAdapter commands automatically by using the CommandBuilder object.
- Generate DataAdapter commands programmatically.
- Populate a DataSet by using a DataAdapter.
- Update a database by using a DataAdapter.
- Resolve conflicts between a DataSet and a database by using the DataAdapter.
- Respond to changes made to data at the data source by using DataAdapter events.
- Perform batch operations by using DataAdapters.
- Manage XML data with the XML Document Object Model (DOM).
- Read XML data into the DOM by using the Load method.
- Modify an XML document by adding and removing nodes.
- Modify nodes in an XML document.
- Write data in XML format from the DOM.
- Work with nodes in the XML DOM by using XmlNamedNodeMap and the XmlNodeList.
- Handle DOM events.
- Modify XML declaration.
- Read and write XML data by using the XmlReader and XmlWriter.
- Read XML data by using the XmlReader.
- Read all XML element and attribute content.
- Read specific element and attribute content.
- Read XML data by using the XmlTextReader class.
- Read node trees by using the XmlNodeReader.
- Validate XML data by using the XmlValidatingReader.
- Write XML data by using the XmlWriter.
You can also find some information on preparing for your exams here and here, in the actual exam for 70-528. Also errata for the MS Press training kit
Posts
1 comment:
It's great, nice job!
Post a Comment