C# .Net Database Programming Certification towards MCTS and MCPD C# .Net Windows Programming (Certification towards MCTS) £990 Full MCTS Windows Certification £1500 C# Exam 70-526 Certification Exam and Course Highlight • Creating a UI for a Windows Forms Application by Using Standard Controls • Manage control layout on a Windows Form • Manage control layout on a Windows Form • Add and configure a Windows Forms control • Create and configure menus • Create event handlers for Windows Forms and controls • Integrating Data in a Windows Forms Application • Manage connections and transactions • Create, add, delete, and edit data in a connected environment • Manage XML with the XML Document Object Model (DOM) • XmlReader class and the XmlWriter class • Construct print documents • Developing Windows Forms Controls • Create and configure multiple-document interface (MDI) forms • Configuring and Deploying Applications • Create a Windows Forms setup application • Add functionality to a Windows Forms setup application		End 2 End Process Enrolment Phone or In Person Course Fee £990 Books and Course Material Included         Hands-on instructor led Training for 8 classes, Unlimited Pratice Hours         Free C# Mock Exam         Actual C# MCTS Exam done @ BCOC Fee not included         C# Programmer Certification towards MCTS

C# .Net Database Programming

MCTS Windows Applications Exam: 70-526

TS: Microsoft .NET Framework 2.0 - Windows-Based Client Development

Creating a UI for a Windows Forms Application by Using Standard Controls
Add and configure a Windows Form.
• Add a Windows Form to a project at design time.
• Configure a Windows Form to control accessibility, appearance, behavior, configuration, data, design, focus, layout, style, and other functionality.

Manage control layout on a Windows Form.
• Group and arrange controls by using the Panel control, GroupBox control, TabControl control, FlowLayoutPanel control, and TableLayoutPanel control.
• Use the SplitContainer control to create dynamic container areas.

Add and configure a Windows Forms control.
• Use the integrated development environment (IDE) to add a control to a Windows Form or other container control of a project at design time.
• Add controls to a Windows Form at run time.
• Configure controls on a Windows Form at design time to optimize the UI.
• Modify control properties.
• Configure controls on a Windows Form at run time to ensure that the UI complies with best practices.
• Create and configure command controls on a Windows Form.
• Create and configure text edit controls on a Windows Form.
• Create and configure text display controls on a Windows Form.
• Use the LinkLabel control to add Web-style links to Windows Forms applications.
• Provide a list of options on a Windows Form by using a ListBox control, a ComboBox control, or a CheckedListBox control.
• Configure the layout and functionality of a Windows Form to display a list of items.
• Implement value-setting controls on a Windows Form.
• Configure a WebBrowser control.
• Add and configure date-setting controls on a Windows Form.
• Display images by using Windows Forms controls.
• Configure the NotifyIcon component.
• Create access keys for Windows Forms controls.

Create and configure menus.
• Create and configure a MenuStrip component on a Windows Form.
• Change the displayed menu structure programmatically.
• Create and configure the ContextMenuStrip component on a Windows Form.

Create event handlers for Windows Forms and controls.
• Use the Windows Forms Designer to create event handlers.
• Manage mouse and keyboard events within Windows Forms applications.
• Program a Windows Forms application to recognize modifier keys.
• Use the Windows Forms Designer to create default event handlers.
• Create event handlers at run time to respond to system or user events dynamically.
• Connect multiple events to a single event handler.
• Use the Code Editor to override methods defined in the base class.

Integrating Data in a Windows Forms Application
Implement data-bound controls.
• Use the DataGridView control to display and update the tabular data contained in a data source.
• 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.
• Navigate forward and backward through records in a DataSet in Windows Forms.
• Define a data source by using a DataConnector component.
• Create data forms by using the Data Source Configuration Wizard.

Manage connections and transactions.
• Configure a connection to a database by using the Connection Wizard.
• Configure a connection to a database 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.
• Open an ADO.NET connection to a database.
• Close an ADO.NET connection to a database by using the Close method of the Connection object.
• Protect access to data source connection details.
• Create a connection designed for reuse in a connection pool.
• Control a connection pool by configuring ConnectionString values based on database type.
• Use the Connection events to detect database information.
• Handle exceptions when connecting to a database.
• Perform transactions by using the Transaction object.

Create, add, delete, and edit data in a connected environment.
• Retrieve data by using a DataReader object.
• Build SQL commands in Server Explorer.
• Build SQL commands in code.
• Create parameters for a Command object.
• Perform database operations by using a Command object.
• Retrieve data from a database by using a Command object.
• Perform asynchronous operations by using a Command object.
• Perform bulk copy operations.
• Store and retrieve binary large object (BLOB) data types in a database.

Create, add, delete, and edit data in a disconnected environment.
• Create a DataSet graphically.
• Create a DataSet programmatically.
• Add a DataTable to a DataSet.
• Add a relationship between tables within a DataSet.
• Navigate a relationship between tables.
• Merge DataSet contents.
• Copy DataSet contents.
• Create a typed DataSet.
• Create DataTables.
• Manage data within a DataTable.
• Create and use DataViews.
• Represent data in a DataSet by using XML.
• Use the OleDbDataAdapter object to access an ADO Recordset or Record.
• 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 a DataAdapter.
• Respond to changes made to data at the data source by using DataAdapter events.
• Perform batch operations by using DataAdapters.

Manage XML with the XML Document Object Model (DOM).
• Read XML data into the DOM.
• Modify an XML document by adding and removing nodes.
• Modify nodes within an XML document.
• Write data in XML format from the DOM.
• Work with nodes in the XML DOM.
• Handle DOM events.
• Modify the XML declaration.

Read, write, and validate XML by using the XmlReader class and the XmlWriter class.
• Read XML data by using the XmlReader class.
• 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 class.
• Validate XML data by using the XmlValidatingReader class.
• Write XML data by using the XmlWriter class.

Implementing Printing and Reporting Functionality in a Windows Forms Application
Manage the print process by using print dialogs.
• Configure Windows Forms print options at run time.
• Change the printers attached to a user's computer in Windows Forms.
• Configure the PrintPreviewDialog control.
• Display a Print Preview window in Windows applications.
• Set page details for printing by using the PageSetupDialog component.

Construct print documents.
• Configure the PrintDocument component.
• Print a text document in a Windows Form.
• Print graphics in a Windows Form.
• Print a document by using the PrintDialog component.
• Alert users to the completion of a print job.
• Enable security for printing in Windows Forms.

Enhancing Usability
Perform drag-and-drop operations.
• Perform drag-and-drop operations within a Windows Forms application.
• Perform drag-and-drop operations between applications.
• Perform a drag-and-drop operation by using a TreeView control.

Implement globalization and localization for a Windows Forms application.
• Implement globalization and localization within a Windows Forms application.

Implement accessibility features.
• Implement accessibility features within a Windows Forms application.

Create and configure multiple-document interface (MDI) forms.
• Create MDI parent forms.
• Create MDI child forms.
• Identify the active MDI child form.
• Send data to the active MDI child form.
• Arrange MDI child forms.
• Create a window-list menu for an MDI application.

Create, configure, and customize user assistance controls and components.
• Configure the PropertyGrid component.
• Configure the ProgressBar control to indicate progress graphically.
• Display status information by using the StatusStrip control.
• Configure the ToolTip component.
• Configure the ErrorProvider component.
• Configure the HelpProvider component.
• Play system sounds and audio files by using the SoundPlayer.
• Configure the Timer component to raise an event at regular intervals.
• Enable scrolling by using the HScrollBar and VScrollBar controls.

Implement an asynchronous method.
• Implement advanced asynchronous techniques.
• Create an asynchronous method.
• Create a new process thread.

Developing Windows Forms Controls
Create a composite Windows Forms control.
• Create a composite Windows Forms control.
• Create properties, methods, and events for Windows Forms controls.
• Expose properties of constituent controls.
• Create and use custom dialog boxes in Windows Forms applications.
• Customize a control to paint and render.
• Configure a control to be invisible at run time.
• Configure a control to have a transparent background.
• Provide a Toolbox bitmap for a control.

Create a custom Windows Forms control by inheriting from the control class.
• Create a custom control by inheriting from the control class.

Create an extended control by inheriting from an existing Windows Forms control.
• Create an extended control by inheriting from an existing Windows Forms control.

Configuring and Deploying Applications
Configure the installation of a Windows Forms application by using ClickOnce technology.
• Install a Windows Forms application on a client computer by using ClickOnce deployment.
• Install a Windows Forms application from a server by using ClickOnce deployment.
• Configure the required permissions of an application by using ClickOnce deployment.

Create a Windows Forms setup application.
• Create a Windows Forms application setup project.
• Set deployment project properties.
• Configure a setup project to add icons during setup.
• Configure conditional installation based on operating system versions.
• Configure a setup project to deploy the .NET Framework.

Add functionality to a Windows Forms setup application.
• Add a custom action to a setup project.
• Add error-handling code to a setup project for custom actions.