This advanced-level course focuses on writing Windows application forms that interface with a database management system using the VB.Net language. Covers using data sources and datasets for Rapid Application Development, three-layer Windows Forms applications, using reporting features of Visual Studio, and how to use LINQ.
Goals, Topics, and Objectives
- Working with Data Sources and Datasets
- Bound Controls and Parameterized Queries
- How to use the Dataset Designer
- How to work with Connections, Commands, and Data Readers
- Parameters and Stored Procedures
- Working with Logical Transactions
- Binding Controls to Object Data Sources
- Using the Reporting Features of Visual Studio
- Coding Query Expressions with LINQ
- Compose a Windows Form application using data sources from datasets.
- * Design and code a Windows Form application using bound controls and parameterized queries.
- Demonstrate the use of the Dataset Designer to compose a data source to be used by a Windows Form application
- * Develop business and database classes that utilizes connections, commands and data readers.
- Create a Windows Form application that references an object data source for its bound controls.
- Design, code and test a Windows Form application using the reporting features of Visual Studio.
- Develop a Windows Form application using the LINQ language to work with object data sources and datasets.
Assessment and Requirements
Quizzes, laboratory assignments and examinations, which involve lab problems.