Developing Applications Using C# 2008/2010: Vol 1, Part 3 of 6

Course description

Visual Studio 2008/2010 adds a large set of new functionality for the Visual Studio developer. From new language features, including LINQ (Language Integrated Query), to new client-side data support, Visual Studio 2008/2010 and the .NET Framework 3.5/4.0 make it easier than ever to create robust, enterprise-level applications. You will learn how to build solid applications using structured exception handling, how to use the Visual Studio debugging features, how to use MenuStrip and ToolStrip controls, and how to add unprecedented flexibility to your user interfaces using the container controls. As you continue through this course you will learn about important development topics that are not normally covered in a beginning Windows application programming course such as an introduction to .NET interoperability, using .NET Serialization, Windows Management Instrumentation (WMI), and drawing your own user interfaces using the System.Drawing namespace. You will dig deeper into the most complex of Visual Studio built-in controls, the DataGridView control, Windows Communication Foundation (WCF), using ClickOnce, Windows Workflow Foundation (WF), and many more topics that will extend your knowledge, your capabilities, and your value as a developer. This course now supports both Visual C# 2008 and 2010.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Meet the experts

Ken Getz

Ken Getz is a featured instructor for several of our Visual Studio courses. He is a Visual Basic and Visual C# expert and has been recognized multiple times as a Microsoft MVP. Ken is a seasoned instructor, successful consultant, and the author or co-author of several best-selling books. He is a frequent speaker at technical conferences like Tech-Ed, VSLive, and DevConnections and he has written for several of the industry's most-respected publications including Visual Studio Magazine, CoDe Magazine, and MSDN Magazine.

Robert Green

Robert Green is a Visual Studio expert and a featured instructor for several of our Visual Basic and Visual C# courses. He is currently a Technical Evangelist in the Developer Platform and Evangelism (DPE) group at Microsoft. He has also worked for Microsoft on the Developer Tools marketing team and as Community Lead on the Visual Basic team. Robert has several years of consulting experience focused on developer training and is a frequent speaker at technology conferences including TechEd, VSLive, VSConnections, and Advisor Live.

Video Runtime

219 Minutes

Time to complete

279 Minutes

Course Outline

Module 7

LINQ to SQL (18:38)

• Introduction (00:43)
• Overview: LINQ to SQL (01:22)
• Create Data Model (00:25)
• Demo: Add LINQ to SQL Class (02:23)
• Demo: View Data Model (01:27)
• Demo: Query SQL Database (01:50)
• Demo: Call Stored Proc (01:34)
• Anonymous Types w/SQL (00:52)
• Demo: Anonymous Types (00:47)
• Modify SQL Data (01:47)
• Demo: Modify SQL Data (04:10)
• Summary (01:12)

LINQ to DataSets / XML (25:25)

• Introduction (01:09)
• Overview: LINQ to DataSets (00:59)
• LINQ to Typed DataSets (00:28)
• Demo: Typed DataSets (02:55)
• LINQ to Untyped DataSets (02:24)
• Demo: Untyped DataSets (02:49)
• LINQ tor XML (01:58)
• Demo: LINQ to XML (06:50)
• Transform XML (00:49)
• Demo: Transform XML (03:08)
• For More Information (00:52)
• Summary (00:59)

Data Binding (25:39)

• Introduction (00:40)
• Create a Data Source (00:58)
• Configuration Wizard (00:30)
• Data Sources Window (00:37)
• Create Data Bound Form (00:49)
• Demo: Data Bound Form (07:18)
• Test Data Bound Form (02:29)
• Data Binding Controls (00:33)
• DataSet (00:51)
• TableAdapter (01:57)
• TableAdapterManager (00:39)
• BindingSource Component (00:31)
• BindingNavigator Control (01:00)
• Demo: View DataSet (01:51)
• Demo: TableAdapter (01:47)
• Demo: BindingSource (01:10)
• Demo: BindingNavigator (00:40)
• Summary (01:12)

Module 8

Relationships / Lookup Tables (48:48)

• Introduction (00:40)
• Data from Related Tables (00:50)
• Demo: One to Many Relations (06:18)
• Enforce Ref. Integrity (02:28)
• Demo: Enforce Ref. Integrity (08:01)
• Display from Lookup Tables (02:09)
• Demo: Lookup Tables (03:54)
• Add Search to a Form (01:09)
• TableAdapter Queries (01:12)
• Demo: Add Search to a Form (00:48)
• TA Query Config Wiz (07:02)
• Search Criteria Builder (03:38)
• Filter by Values (01:31)
• Demo: Filter by Values (08:21)
• Summary (00:40)

Data Validation (27:52)

• Introduction (00:40)
• Data Validation (00:36)
• User Made Changes (00:49)
• Validate at Form Level (01:33)
• Validate Entered Data (02:32)
• Demo: Trap User Changes (02:14)
• Demo: Validate Saved Data (02:52)
• Validate at Data Level (02:33)
• Demo: Data Level Validation (00:40)
• View DataSet Code (01:25)
• ColumnChanging() Event (05:30)
• ProductsRowChanging() Event (02:45)
• Work with Local Data (02:56)
• Summary (00:41)

Module 9

Binding Navigator/Source (29:26)

• Introduction (00:36)
• Binding Navigator Control (00:28)
• BindingNavigator ToolStripItems (01:22)
• Built-In/Custom Functionality (01:00)
• Add a BindingNavigator (00:31)
• Demo: Binding Navigator (04:52)
• BindingSource Component (00:40)
• Data Navigation (00:48)
• Data Manipulation (00:24)
• Sorting / Filtering (01:11)
• Work w/Underlying Data (00:37)
• Demo: BindingSource (05:25)
• Demo: Sort / Filter (03:20)
• Demo: Copying Data (07:26)
• Summary (00:38)

DataGridView (27:53)

• Introduction (00:37)
• DataGridView Control (01:01)
• Customize Displayed Data (00:45)
• Demo: Build a DataGridView (07:30)
• Format Cells at Runtime (00:48)
• Demo: Format at Runtime (04:17)
• Display Calculated Values (00:51)
• Demo: Calculated Values (00:48)
• Demo: Add Columns (02:15)
• Display Images (01:03)
• Demo: Display Images (03:18)
• Add Controls to DataGridView (00:50)
• Demo: Adding Controls (03:22)
• Summary (00:21)

Report Viewer (15:58)

• Introduction (00:39)
• Create / View Reports (00:43)
• Demo: Create New Report (07:32)
• ReportViewer Control (01:52)
• Demo: Use Report Wizard (04:02)
• Summary (01:07)