MCPD Certification

Integrating Data in a Windows Forms Application (22%)

1. Implement data-bound controls
   • Use the DataGridView control to display and update the tabular data contained in a data source
   • DataGridView control overview
   • DataGridView control technology summary
   • DataGridView control architecture
   • Use a simple data-bound control to display a single data element 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
   • Navigate forward and backward through records in a DataSet in Windows Forms
   • Navigate data in Windows Forms
   • DataSets overview
   • DataSet designer
   • Creating a typed dataset
   • Define a data source by using a DataConnector component
   • 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
2. 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, Access, Oracle
   • Configure a connection to a database by using the Connection 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
   • SqlErrorCollection class
   • 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
3. 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
   • Build SQL commands in code
   • 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
   • Retrieve data from a database by using a Command object
   • ExecuteDbDataReader method
   • ExecuteReader method
   • ExecuteScalar method
   • CommandBehavior enumeration
   • Perform asynchronous operations by using a Command object
   • BeginExecuteNonQuery method
   • BeginExecuteReader method
   • BeginExecuteXmlReader method
4. 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
5. Create, add, delete, and edit data in a disconnected environment
   • Create a DataSet graphically
   • DataSets in Visual Studio
   • DataSet designer
6. 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
   • Modify nodes
   • 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
7. Read, write, and validate XML by using the XmlReader class and the XmlWriter class
   • Read XML data
   • Elements
   • Attributes
   • Read specific elements or attributes
   • Reading Attributes
   • Reading Elements
   • XmlTextReader class
   • XmlNodeReader class
   • XmlValidatingReader class
   • XmlWriter class
   • XmlTextWriter class