Introduction
  • Introduction
Data Entry Project
  • Project Intro
  • Building The Form Part 1
  • Building the Form Part 2
  • Clearing and Exiting the Form
  • Adding the Timer
  • Timer Tick Event
  • Start Button Event
  • Pause Button Event
  • Data Entry Section
  • Setting Up KeyPress Event
  • KeyPress Event Part 1
  • KeyPress Event Part 2
  • Mouse Events
  • EXERCISE - Add Mouse Event for Multiple Buttons
  • Initializing Component Method
Databases, C# Database Objects - Theory and Practical Examples
  • Database Theory Part 1
  • Database Theory Part 2
  • Overview Of C# Database Objects
  • Connection String Overview
  • Connection String Example
  • Command And Data Adapter Overview
  • DataTable Overview
  • Command Object Example
  • Data Adapter Example
  • DataTable Example
  • Data Binding Overview
  • Data Binding Exercise
  • CurrencyManager Overview
  • CurrencyManager Example
  • Using Wizard to connect to DB and bind form objects
  • EXERCISE - USING C# DATABASE OBJECTS (NorthWind Database) - INSTRUCTIONS
  • EXERCISE - NorthWind - Creating the Form
  • EXERCISE - NorthWind - Adding Database Objects
  • EXERCISE - NorthWind - Data Binding
  • EXERCISE - NorthWind - Currency Manager
SQL Tester Project
  • Intro
  • Creating the Form
  • Connecting to Database
  • C# Database Objects
  • Running the Program
Book Database Search Project
  • Intro
  • Creating the form
  • Creating Buttons Programmatically Part 1
  • Creating Buttons Programmatically Part 2
  • Connection String and SQL Query Command
  • Finishing SQL Query Command
  • Database Objects
  • Running the Program
Books Management System - CRUD Project
  • Intro
  • Authors - Creating the Form
  • Authors - Adding Database Objects
  • Authors - Navigating Between Records
  • Authors - Setting up Save and Delete Events
  • Authors - Application States Intro
  • Authors - Coding Application States
  • Authors - Working with Application States
  • Authors - Validating Input
  • Authors - More Input Validation
  • Authors - KeyPress Event
  • Authors - Error Handling
  • EXERCISE - PUBLISHERS - INSTRUCTIONS
  • EXERCISE - Publishers - Creating the Form
  • EXERCISE - Publishers - Adding Database Objects
  • EXERCISE - Publishers - Data Binding and CurrencyManager
  • EXERCISE - Publishers - Application States
  • EXERCISE - Publishers - Input Validation
  • EXERCISE - Publishers - Navigating Through Records
  • Authors - Saving Records
  • Authors - Bug Fix - Saving Record
  • Authors - Deleting Records
  • Authors - Adding New Records
  • Authors - Adding New Records - Changing Application State
  • Authors - Adding New Records - Record Position
  • Authors - Final Adjustments
  • EXERCISE - PUBLISHERS - CRUD OPERATIONS - INSTRUCTIONS
  • EXERCISE - Publishers - Adding Record Navigation
  • EXERCISE - Publishers - Saving Records
  • EXERCISE - Publishers - Saving Records (testing)
  • EXERCISE - Publishers - Adding and Deleting Records
  • EXERCISE - Publishers - Changing Application States
  • Publishers - Adding Search Functionality to the Form
  • Publishers - Coding Search Functionality
  • EXERCISE - AUTHORS - ADDING SEARCH FUNCTIONALITY - INSTRUCTIONS
  • EXERCISE - Authors - Adding Seach To The Form
  • EXERCISE - Authors - Coding Search Functionality
  • Authors - Bug Fix - Edit and Cancel Events
  • Authors - Bug Fix - Add New Record
  • Publishers - Bug Fix - Cancel Adding New Record
  • Titles - Introduction
  • Titles - Creating the Form
  • Titles - Adding C# Database Objects
  • Titles - Navigating Between Records
  • Titles - Application State