MCTS Windows Forms 3.5 – 70-505 – Objectives List Part 2

This is the second post (first) in another collection of posts that have links to the different objectives covered in the 70-505 exam.

Integrating Data in a Windows Forms Application (22%)

• Implement data-bound controls
• Use the DataGridView control to display and update the tabular data contained in a data source
  • DataGridView control overview
  • Differences between GridView and DataGridView
  • DataGridView control technology summary
  • DataGridView control architecture
  • DataGridView control scenarios
  • DataGridView code samples
  • Column Types in DataGridView control
  • Displaying Data in the DataGridView control
  • Customising the Windows Forms DataGridView control
  • Performance tuning in DataGridView control
  • Binding data using DataGridView control
  • Implementing virtual mode in the DataGridView control
  • Customise the appearance of cells in the DataGridView control
  • Customise the appearance of rows in the DataGridView control
  • Hosting controls in DataGridView cells
• Use a simple data-bound control to display a single data element on a Windows Form
  • Create a simple bound control on a Windows Form 
• Implement complex data binding to integrate data from multiple sources
  • Types of binding in Windows Forms
  • Data sources supported by Windows Forms
  • BindingSource
  • BindingNavigator
  • IBindingList class
  • Creating a Master/Detail form using the DataGridView class
  • Creating a lookup table using the BindingSource component
  • Creating a user control that supports complex binding
• Navigate forward and backward through records in a DataSet in Windows Forms
  • Navigate data in Windows Forms
  • DataSet class
  • DataSets overview
  • BindingNavigator class
  • DataSet designer
  • Creating a typed dataset
• Define a data source by using a DataConnector component
  • BindingSource component (DataConnector was renamed to BindingSource)
  • BindingSource component overview
  • Bind a windows form to a factory object
  • Binding controls with BindingSource component using the designer
• Create data forms by using the Data Form Wizard
  • Data Sources window
  • Displaying data in windows forms
• Manage connections and transactions
• Configure a connection to a database by using the Connection Wizard
  • Data Source configuration wizard
• Configure a connection to a database by using Server Explorer
  • Server Explorer
  • Connecting to data with server explorer
  • Data connections with server explorer
  • Add new data connection in server explorer
  • User credentials in server explorer
  • Create a connection to SQL Server
  • Create a connection to an Access database
  • Create a connection an Oracle database
• Configure a connection to a database by using the Connection class
  • DbConnection class
• Connect to a database by using specific database Connection objects
  • OdbcConnection class
  • OleDbConnection class
  • OracleConnection class
  • SqlConnection class
• Handle exceptions when connecting to a database
  • SqlConnection.InfoMessage property
  • SqlErrorCollection class
  • SqlError
  • DbException class
  • OdbcException class
  • OleDbException class
  • OracleException class
  • SqlException class
• Perform transactions by using the Transaction object
  • DbTransaction object
  • OdbcTransaction class
  • OleDbTransaction class
  • OracleTransaction class
  • SqlTransaction object
  • Local transactions in ADO.NET
• Create, add, delete, and edit data in a connected environment
• Retrieve data by using a DataReader object
  • DbDataReader class
  • DataTableReader class
  • OdbcDataReader class
  • OleDbDataReader class
  • OracleDataReader class
  • SqlDataReader class
  • DataAdapters and DataReaders in ADO.NET
  • Retrieve data using the DataReader
• Build SQL commands in Server Explorer
  • Query and View designer tools
  • Create queries
  • Expressions in queries
  • Types of queries
  • Query with parameters
  • Create and execute an SQL Statement that returns rows
  • Create and Execute an SQL Statement that Returns a Single Value
  • Create and Execute an SQL Statement that Returns No Value
  • Execute a stored procedure that returns rows
  • Execute a Stored Procedure that Returns a Single Value
  • Execute a Stored Procedure that returns no value 
• Build SQL commands in code
  • Commands in code
  • Executing a command
  • Configuring Parameters and Parameter Data Types (ADO.NET)
  • Generating commands with Command Builders
  • Set and get parameters for Command objects 
• Create parameters for a Command object
  • DbCommand class
  • OdbcCommand class
  • OleDbCommand class
  • OracleCommand class
  • SqlCommand class
  • CreateParameter method
  • Configuring Parameters and Parameter Data Types (ADO.NET)
• Perform database operations by using a Command object
  • DbCommand methods
• Retrieve data from a database by using a Command object
  • ExecuteDbDataReader method
  • ExecuteReader method
  • ExecuteScalar method
  • CommandBehaviour enumeration
• Perform asynchronous operations by using a Command object
  • BeginExecuteNonQuery method
  • BeginExecuteReader method
  • BeginExecuteXmlReader method
• Query data from data sources by using LINQ
  • LINQ to SQL
  • LINQ to Objects
  • LINQ to XML
  • LINQ to ADO.NET
  • LINQ to DataSet
  • LINQ to Entities
• Create, add, delete, and edit data in a disconnected environment
• Create a DataSet graphically
  • DataSets in Visual Studio
  • DataSet designer
  • Open a dataset in the dataset designer
  • Create a typed dataset
• Create a DataSet programmatically
  • Fill a dataset with data
  • Fill a dataset with a DataAdapter
  • Walkthrough: Filling a dataset with data
• Add a DataTable to a DataSet
  • DataTable class
  • Creating a DataTable
  • Create DataTables using Server Explorer
• Add a relationship between tables within a DataSet
  • DataRelation class
  • Introduction to DataRelation objects
  • Create DataRelations with the DataSet designer
  • Creating relationship between DataTables
  • Adding DataRelations
  • Nesting DataRelations
• Navigate a relationship between tables
  • Navigating DataRelations
• Merge DataSet contents
  • DataSet.Merge method
• Copy DataSet contents
  • DataSet.Copy method
• Create a typed DataSet
  • Create a typed dataset
• Create DataTables
  • Creating a DataTable
• Manage data within a DataTable
  • DataTables overview and walkthroughs
• Create and use DataViews
  • DataViews overview
  • Creating a DataView
  • Sorting and filtering data
  • DataView class
• Represent data in a DataSet by using XML
  • Using XML in a DataSet
  • Loading a dataset from XML
  • Writing DataSet contents as XML
  • Loading DataSet schema information from XML
  • Writing DataSet schema information as XSD
  • DataSet and XmlDataDocument synchronization
  • Inferring DataSet relational structure from XML
• Use the OleDbDataAdapter object to access an ADO Recordset or Record
  • OleDbDataAdapter class
• Generate DataAdapter commands automatically by using the CommandBuilder object
  • Generating commands with CommandBuilders
• Generate DataAdapter commands programmatically
  • DataAdapter parameters
• Populate a DataSet by using a DataAdapter
  • Populating a DataSet from a DataAdapter
• Update a database by using a DataAdapter
  • Updating Data Sources with DataAdapters
• Resolve conflicts between a DataSet and a database by using a DataAdapter
  • DataAdapter events
• Respond to changes made to data at the data source by using DataAdapter events
  • DataAdapter events
• Perform batch operations by using DataAdapters
  • Performing batch operations using DataAdapters
• Manage XML by using the XML Document Object Model (DOM)
  • XML Document Object Model
  • Types of XML Nodes
• Read XML data into the DOM
  • Reading an XML Document into the DOM
  • Load Data from a reader
• Modify an XML document by adding and removing nodes
  • Modifying Nodes, Content, and Values in an XML Document
  • Inserting nodes in an XML Document
  • XmlNode.Value property
  • XmlNode..AppendChild method
  • XmlNode.RemoveChild method
  • XmlCharacterData.DeleteData method
• Modify nodes
  • XmlNode.InnerXml property
  • XmlCharacterData.AppendData method
  • XmlCharacterData.InsertData method
  • XmlCharacterData.ReplaceData method
• Write data in an XML format by using the DOM
  • Saving and writing a document
• Handle DOM events
  • Event Handling in an XML Document Using the XmlNodeChangedEventArgs
  • NodeInserting events
  • NodeInserted events
  • NodeRemoving event
  • NodeRemoved event
  • NodeChanging event
  • NodeChanged event
  • XmlNodeChangedEventHandler delegate
• Read, write, and validate XML by using the XmlReader class and the XmlWriter class
• Read XML data
  • XmlReader class
  • Reading XML with the XmlReader
  • Common XmlReader tasks
• Elements
  • Reading Elements
• Attributes
  • Reading Attributes
• Read specific elements or attributes
  • Reading Attributes
  • Reading Elements
• Use XmlTextReader
  • XmlTextReader class
• Use XmlNodeReader
  • XmlNodeReader class
• Use XmlValidatingReader
  • XmlValidatingReader class
• Use XmlWriter
  • XmlWriter class
  • Writing XML with the XmlWriter class
• Use XmlTextWriter
  • XmlTextWriter class
  • Write XML using the XmlTextWriter

You can also find some information on preparing for your exams here, in the actual exam for 70-505. Also errata for the MS Press training kit