C# Database Driven WinForm Apps (step by step projects)

سرفصل های دوره

Project-based Learning: how to use C# Windows Forms and Microsoft Access Database to create small database driven apps

1. Introduction

1.1 BooksDB.zip

1.2 BooksWithAutoNumbers.zip

1.3 NorthWindDB.zip

1. Introduction

2. Data Entry Project

1.1 01-DataEntryProject.zip

1.2 01-Intro.pdf

1.3 WINDOWS FORMS OBJECTS.pdf

1. Project Intro

2. Building The Form Part 1

3. Building the Form Part 2

4. Clearing and Exiting the Form

5. Adding the Timer

6. Timer Tick Event

7. Start Button Event

8. Pause Button Event

9. Data Entry Section

10. Setting Up KeyPress Event

11. KeyPress Event Part 1

12. KeyPress Event Part 2

13. Mouse Events

14. EXERCISE - Add Mouse Event for Multiple Buttons

15. Initializing Component Method

3. Databases, C# Database Objects - Theory and Practical Examples

1.1 02-BooksDB.zip

1.2 02-BooksDBWithWizard.zip

1.3 03-NorthWindExercise.zip

1.4 04-DatabaseTheory.pdf

1.5 05-DatabaseObjects.pdf

1.6 BooksDatabase.zip

1. Database Theory Part 1

2. Database Theory Part 2

3. Overview Of C# Database Objects

4. Connection String Overview

5. Connection String Example

6. Command And Data Adapter Overview

7. DataTable Overview

8. Command Object Example

9. Data Adapter Example

10. DataTable Example

11. Data Binding Overview

12. Data Binding Exercise

13. CurrencyManager Overview

14. CurrencyManager Example

15. Using Wizard to connect to DB and bind form objects

16. EXERCISE - USING C# DATABASE OBJECTS (NorthWind Database) - INSTRUCTIONS

17. EXERCISE - NorthWind - Creating the Form

18. EXERCISE - NorthWind - Adding Database Objects

19. EXERCISE - NorthWind - Data Binding

20. EXERCISE - NorthWind - Currency Manager

4. SQL Tester Project

1.1 04-SQLTester.zip

1.2 BASIC SQL COMMANDS FOR MS ACCESS DATABASE.pdf

1. Intro

2. Creating the Form

3. Connecting to Database

4. C# Database Objects

5. Running the Program

5. Book Database Search Project

1.1 SearchByAuthor.zip

1. Intro

2. Creating the form

3. Creating Buttons Programmatically Part 1

4. Creating Buttons Programmatically Part 2

5. Connection String and SQL Query Command

6. Finishing SQL Query Command

7. Database Objects

8. Running the Program

6. Books Management System - CRUD Project

1.1 05-BooksManagementSystem-AuthorForm.zip

1.2 05-BooksManagementSystem-AuthorPublisher.zip

1.3 05-BooksManagementSystem-Final.zip

1. Intro

2. Authors - Creating the Form

3. Authors - Adding Database Objects

4. Authors - Navigating Between Records

5. Authors - Setting up Save and Delete Events

6. Authors - Application States Intro

7. Authors - Coding Application States

8. Authors - Working with Application States

9. Authors - Validating Input

10. Authors - More Input Validation

11. Authors - KeyPress Event

12. Authors - Error Handling

13. EXERCISE - PUBLISHERS - INSTRUCTIONS

14. EXERCISE - Publishers - Creating the Form

15. EXERCISE - Publishers - Adding Database Objects

16. EXERCISE - Publishers - Data Binding and CurrencyManager

17. EXERCISE - Publishers - Application States

18. EXERCISE - Publishers - Input Validation

19. EXERCISE - Publishers - Navigating Through Records

20. Authors - Saving Records

21. Authors - Bug Fix - Saving Record

22. Authors - Deleting Records

23. Authors - Adding New Records

24. Authors - Adding New Records - Changing Application State

25. Authors - Adding New Records - Record Position

26. Authors - Final Adjustments

27. EXERCISE - PUBLISHERS - CRUD OPERATIONS - INSTRUCTIONS

28. EXERCISE - Publishers - Adding Record Navigation

29. EXERCISE - Publishers - Saving Records

30. EXERCISE - Publishers - Saving Records (testing)

31. EXERCISE - Publishers - Adding and Deleting Records

32. EXERCISE - Publishers - Changing Application States

33. Publishers - Adding Search Functionality to the Form

34. Publishers - Coding Search Functionality

35. EXERCISE - AUTHORS - ADDING SEARCH FUNCTIONALITY - INSTRUCTIONS

36. EXERCISE - Authors - Adding Seach To The Form

37. EXERCISE - Authors - Coding Search Functionality

38. Authors - Bug Fix - Edit and Cancel Events

39. Authors - Bug Fix - Add New Record

40. Publishers - Bug Fix - Cancel Adding New Record

41. Titles - Introduction

42. Titles - Creating the Form

43. Titles - Adding C# Database Objects

44. Titles - Navigating Between Records

45. Titles - Application State

46. Titles - Input Validation

47. Titles - Application State For Edit and Add New Record

48. Titles - Saving Edited Record

49. Titles - Deleting Records

50. Titles - Cancelling CRUD operation

51. Titles - Bug Fix - Not Allowing Letters for Year Published Field

52. Titles - Adding Authors and Publishers to the Form

53. Titles - Authors Database Objects

54. Titles - Loading Authors Database Objects

55. Titles - Getting Authors for Specific ISBN - Part 1

56. Titles - Getting Authors for Specific ISBN - Part 2

57. Titles - Removing Authors From ComboBox

58. Titles - Application State for Authors

59. Titles - Saving Authors And ISBN

60. Titles - Updating Authors Search Functionality

61. EXERCISE - TITLES - ADD PUBLISHERS TO THE FORM - INSTRUCTIONS

62. EXERCISE - Titles - Adding Publishers Database Objects

63. Titles - Adding Connection to Authors Form

64. EXERCISE - TITLES - ADDING CONNECTION TO PUBLISHERS FORM - INSTRUCTIONS

65. EXERCISE - Titles - Adding Connection to Publishers Form

66. Titles - Testing Adding New Records

67. Titles - Debugging

68. Passing Data Between Two Forms - Improving Search

69. Passing Data Between Two Forms - Improving Search for Titles

70. Passing Data Between Two Forms - Improving Search For Authors and Publishers

7. Printing Records From Database (using Books Db)

1.1 FinalBooksManagementSystem.zip

1. Adding Print Event

2. Setting Up Page Header

3. Printing Title and Authors

4. Printing The Rest of the Fields and Testing

8. Airline Reservation System

1.1 airline-access-database.zip

1.2 Airline.zip

1.3 AirlineForms.pdf

1. Project Introduction

2. Reviewing the Database

3. Reviewing the Forms

4. Connection String

5. Passenger Class

6. Seat Class

7. Checking If Plane is Full

8. Checking if Seat is Taken

9. Outline of Methods and Events We Need

10. Creating Objects

11. Displaying Seating Chart

12. Populating DropDown Rows From the Database

13. Validate Input Part 1

14. Validate Input Part 2

15. Testing Validation

16. Inserting Passenger

17. Testing Adding a Passenger

18. Show All Passengers SQL Command

19. Search For a Passenger SQL Command

20. Pass And Load Data Between Forms

21. DataGridView Click Event

22. Edit and Delete Passenger - Outline of Things To Do

23. Data Binding

24. Validating Waiting List and Seat Information

25. Editing Record

26. Updating Passenger and Seat Records

27. Testing Edit Functionality

28. Delete Passenger and Final Test

9. CONCLUSION

1. Conclusion - Summary of what we learned, where we are, and where to go from here

2. Bonus Lecture.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy