Database Environments and XML Handling with Visual Basic 2008


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Visual Studio 2008 and the .NET Framework 3.5 allow developers to configure database connections and handle XML data in Windows Forms applications. This course first looks at how to work with different database environments and how to create Windows Forms applications that can handle asynchronous and binary large object (BLOB) operations. It then examines the XML Document Object Model (DOM) and the XML classes used to handle XML data in .NET Windows Forms. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft .NET Framework 3.5, Windows Forms Application Development 70-505. Passing this exam will earn the learner the MCTS: .NET Framework 3.5, Windows Forms Applications certification.

Target Audience
Individuals who intend to use the .NET Framework 3.5 with Visual Studio 2008 and Visual Basic 2008 to develop Windows Forms applications; individuals preparing for the Exam 70-505 TS: Microsoft .NET Framework 3.5, Windows Forms Application Development.

Prerequisites
Thorough knowledge of software development concepts and the process of building business applications; experience building Windows-based applications with the Microsoft .NET Framework 3.5; working experience of Visual Studio 2008 and Visual Basic 2008.

Expected Duration (hours)
2.5

Lesson Objectives

Database Environments and XML Handling with Visual Basic 2008

  • build and run a basic SQL query for a connected environment using Server Explorer
  • complete the code to retrieve data in a connected environment
  • use the appropriate code to perform asynchronous operations
  • use the appropriate code to perform bulk copy operations
  • use the appropriate code to retrieve binary large objects (BLOBs)
  • create a DataSet programmatically and graphically
  • use the appropriate code to configure DataSet data
  • use the key methods of the DataAdapter object
  • recognize correct use of the OleDbDataAdapter object to access a RecordSet or Record
  • recognize the code used to create an event handler for a DataAdapter event
  • configure a DataAdapter to perform batch operations
  • program a Windows Forms application to access a data source in a connected environment, in a given scenario
  • program a Windows Forms application to access a data source in a disconnected environment, in a given scenario
  • recognize the code used to perform common operations on XML content
  • recognize the code used to write XML data from the Document Object Model (DOM)
  • recognize the code used to handle XML events
  • recognize the code used to add an XML declaration
  • recognize the code used to read XML using some of the XmlReader classes
  • recognize the code used to write XML using the XmlTextWriter class
  • create and modify an XML node element, given a scenario
  • read XML using the XmlTextReader class, given a scenario
  • write XML using the XmlTextWriter class

    • Course Number:
    sd_adwf_a06_it_enus