IIRF Online > Development > Database Design & Development > Database Programming > C# Database Driven WinForm Apps (step by step projects)
C# Database Driven WinForm Apps (step by step projects) by Udemy
Project-based Learning: how to use C# Windows Forms and Microsoft Access Database to create small database driven apps
Course Highlights
- Students will understand the basics of database programming using C# and MS Access database.
- Students will become familiar with database programming concepts.
- Students will be able to create small database-driven desktop apps.
- Students will understand basics of database concepts.
- Students will be able to create and modify Windows Forms and bind form objects with database objects.
- Students will be ready to tackle more complex projects.
Skills you will learn!
Curriculum
1 Topic
Introduction
15 Topics
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
20 Topics
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
5 Topics
Intro
Creating the Form
Connecting to Database
C# Database Objects
Running the Program
8 Topics
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
70 Topics
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
Titles - Input Validation
Titles - Application State For Edit and Add New Record
Titles - Saving Edited Record
Titles - Deleting Records
Titles - Cancelling CRUD operation
Titles - Bug Fix - Not Allowing Letters for Year Published Field
Titles - Adding Authors and Publishers to the Form
Titles - Authors Database Objects
Titles - Loading Authors Database Objects
Titles - Getting Authors for Specific ISBN - Part 1
Titles - Getting Authors for Specific ISBN - Part 2
Titles - Removing Authors From ComboBox
Titles - Application State for Authors
Titles - Saving Authors And ISBN
Titles - Updating Authors Search Functionality
EXERCISE - TITLES - ADD PUBLISHERS TO THE FORM - INSTRUCTIONS
EXERCISE - Titles - Adding Publishers Database Objects
Titles - Adding Connection to Authors Form
EXERCISE - TITLES - ADDING CONNECTION TO PUBLISHERS FORM - INSTRUCTIONS
EXERCISE - Titles - Adding Connection to Publishers Form
Titles - Testing Adding New Records
Titles - Debugging
Passing Data Between Two Forms - Improving Search
Passing Data Between Two Forms - Improving Search for Titles
Passing Data Between Two Forms - Improving Search For Authors and Publishers
4 Topics
Adding Print Event
Setting Up Page Header
Printing Title and Authors
Printing The Rest of the Fields and Testing
28 Topics
Project Introduction
Reviewing the Database
Reviewing the Forms
Connection String
Passenger Class
Seat Class
Checking If Plane is Full
Checking if Seat is Taken
Outline of Methods and Events We Need
Creating Objects
Displaying Seating Chart
Populating DropDown Rows From the Database
Validate Input Part 1
Validate Input Part 2
Testing Validation
Inserting Passenger
Testing Adding a Passenger
Show All Passengers SQL Command
Search For a Passenger SQL Command
Pass And Load Data Between Forms
DataGridView Click Event
Edit and Delete Passenger - Outline of Things To Do
Data Binding
Validating Waiting List and Seat Information
Editing Record
Updating Passenger and Seat Records
Testing Edit Functionality
Delete Passenger and Final Test
2 Topics
Conclusion - Summary of what we learned where we are and where to go from here
Bonus Lecture
C# Database Driven WinForm Apps (step by step projects)
Related Database Programming Courses
Thank You!
Your review has been submitted successfully.