Data Integration 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 data-bind Windows Forms elements and create a database-connected Windows Forms applications. This course explores how to integrate data capabilities into Windows Forms. Topics in this course cover database connections, using LINQ in Windows Forms, using data-bound controls, connection pooling, exception handling, and transactions. 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.0

Lesson Objectives

Data Integration with Visual Basic 2008

  • identify the uses and benefits of data binding in given scenarios
  • identify the steps for creating a database connection visually
  • identify the steps for creating database connections programmatically
  • identify ways to manage database connections
  • identify the steps for creating a simple data-bound control
  • identify the code for implementing complex data binding
  • identify the steps for creating a data-bound Windows form using the Data Source Configuration Wizard
  • identify the properties and methods of the BindingSource component
  • establish a database connection
  • create a bound control
  • identify the steps for performing LINQ to DataSet Windows form data binding
  • identify the steps for performing LINQ to SQL Windows form data binding
  • identify the uses of LINQ to XML in Windows forms
  • recognize the steps for creating and controlling a connection pool
  • identify the steps for detecting database information with connection events
  • recognize the steps for handling database connection exceptions
  • recognize the steps for performing a transaction with the Transaction object
  • query the database using a transaction with database exception handling code
  • query data from data sources using LINQ

    • Course Number:
    sd_adwf_a02_it_enus