[Last updated 6/2023] Fast C# .NET Core Live Project in Windows Forms and SQL (Udemy – Engsub)
About Course
Views
:
What you’ll learn:
Live Full Graphical Project by C# .NET Core + SQL Database from scratch
Easily Learn from Scratch to Create Pro Windows Apps by .NET core – SQL Database in C#
Using C#.NET Core to Create SQL Database Apps
SAP Crystal Reports to design reports in C#
SQL Server, It’s installation & Using in C#
Using AES to encrypt and decrypt password
Design of amazing graphical Main form
Backup and Restore form for SQL Database
Design About us form by using the Versioning info of App
Design users management form
Graphical Login form
Using images: Crop, resize, load & save images
Adding permission for each user
Design SQL database and use it in C# by ADO. Net
Design “SQL Connection Setting” form
Time video:
37.5 hours (162
Lessons
+ Documents)
Teacher:
Mega Learning
Total weight:
19 GB
Original link:
https://www.udemy.com/course/fast-live-project-in-c-net-core-by-windows-forms-sql-db/
Course Content
01 – Introduction
02 – Designing Main Form
-
11:52
-
002 Adding main panels.mp4
09:54 -
003 Minimize and close buttons.mp4
14:32 -
004 Top menu buttons.mp4
16:41 -
005 Add calendar to sidebar.mp4
17:02 -
006 Add analog clock to sidebar.mp4
08:25 -
007 Customize appearance of analog clock.mp4
11:21 -
008 Add login user image to sidebar.mp4
04:58 -
009 Data entry menu by treeview.mp4
27:54
03 – SQL – Quick Review of SQL Server
-
002 Download and install SQL 2014 on Windows 10 and Windows 7.mp4
29:58 -
003 Start using SQL server and SSMS.mp4
18:26 -
004 Working with SQL database.mp4
21:56 -
005 Using SQL Server configuration manager.mp4
06:23 -
006 Using SQL Server Table.mp4
35:47 -
007 SQL Numeric Data types.mp4
42:42 -
008 SQL English Text Data types.mp4
22:47 -
009 SQL Unicode Text Data types.mp4
21:07 -
010 GUID datatype in SQL.mp4
11:17 -
011 How to Attach, Detach and offline the SQL database.mp4
16:08 -
012 Identity and Auto Increment Column in SQL Server.mp4
43:48 -
013 SQL Date Time Data types.mp4
16:22 -
014 Project = Create Phone Book database in SQL.mp4
26:34 -
015 Select Query In SQL.mp4
39:20 -
016 Where clause.mp4
21:15
04 – Using SQL in C# by ADO.NET
-
001 What is ‘incoming letters’ form.mp4
02:48 -
002 Structure of ADO .NET to use database in C#.mp4
06:14 -
003 Create database for incoming letters.mp4
28:15 -
004 Connect SQL Db to C# by TableAdapter, Dataset,.mp4
18:51 -
005 Deeper look at TableAdapter, Dataset and Datatable.mp4
14:10 -
006 How to Back up and restore C# project.mp4
06:19
05 – Design Incoming Letters List Form
-
001 Add incoming letters list form and set common properties.mp4
07:58 -
002 Loading data in to DataGridView.mp4
14:49 -
003 Customizing DataGridView.mp4
16:12 -
004 Adding record navigator to form.mp4
16:57 -
005 Add top buttons to form.mp4
09:49 -
006 Adding Search panel to form.mp4
05:32 -
007 Searching SQL data by ID in C#.mp4
14:42 -
008 Searching SQL data by ‘Subject’ in C#.mp4
13:08 -
009 Searching SQL data by ‘Reg Date’ in C#.mp4
17:24
06 – Design Incoming Letters Form
-
001 Add incoming letters form and set common properties.mp4
09:11 -
002 Add top buttons to form Add, Edit, Delete, Save Cancel.mp4
15:08 -
003 Add sys date & time to footer and set values by C#.mp4
13:27 -
004 Add user name & id to footer and set values by C#.mp4
08:19 -
005 Adding data entry items to form.mp4
11:37 -
006 Bind the data entry items to bindingsource.mp4
12:38 -
007 C# code for New, Edit and save buttons.mp4
13:29 -
008 C# code for Delete and Cancel buttons.mp4
09:34 -
009 Customize date format by App culture.mp4
14:00 -
010 Assign default values for date, time controls and.mp4
18:57 -
011 Set mask to date and time maskedtexboxes.mp4
07:57 -
012 Validate the date before saving in SQL db.mp4
15:41 -
013 Connect data entry form to it’s parent form.mp4
25:24 -
014 Connect ‘Incoming letters list’ to main form.mp4
08:57 -
015 Save the null values in the date columns.mp4
07:35
07 – Design Outgoing Letters Form
-
001 Quick tour of ‘Outgoing letters’ form.mp4
03:19 -
002 Creating SQL database for ‘Outgoing letters’.mp4
24:47 -
003 Connecting ‘Outgoing letters’ SQL table to C#.mp4
08:24 -
004 Design ‘Outgoing letters list’ form.mp4
29:49 -
005 Design ‘Outgoing letters’ data entry form.mp4
28:36 -
006 Connect ‘Outgoing letters list’ to main form.mp4
05:14 -
007 Save the null values in the date columns of Outgoing Letters.mp4
05:02
08 – Design Users Management
-
001 Quick tour of Users Management.mp4
02:45 -
002 Creating SQL database for ‘Users’.mp4
13:26 -
003 Connecting ‘Users’ SQL table to C#.mp4
05:36 -
004 Design ‘App Users List’ form.mp4
14:01 -
005 Design ‘App Users’ data entry form.mp4
27:14 -
006 Add User photo to data entry form.mp4
18:45 -
007 Design Login Form.mp4
39:53 -
008 Add protection to Users Data Entry form.mp4
16:57 -
009 Connecting App User form to main form.mp4
16:40
09 – User Permissions
-
001 Quick tour of User Permissions.mp4
03:50 -
002 Create database for User Permissions.mp4
17:45 -
003 Add permission columns from SQL to C# Datatable.mp4
03:16 -
004 Adding permission sections to Users Form.mp4
23:39 -
005 Bind permission Checkboxes to Bindingsource.mp4
12:22 -
006 Load user permission data in the Main Form.mp4
17:34 -
007 C# code to load user permission by column name.mp4
09:37 -
008 Load permission for the Main Form.mp4
19:22 -
009 Load permission for all other forms.mp4
21:48 -
010 Reload permissions by closing the User List form.mp4
11:18
10 – Design Backup and Restore Forms
-
001 Quick tour of Backup & Restore.mp4
02:42 -
002 Design the Backup and Restore forms.mp4
21:16 -
003 C# code for Browse Button on the Backup Form.mp4
11:59 -
004 Backup data in SSMS ( SQL Server Management Studio).mp4
06:58 -
005 Backup SQL database in C#.mp4
22:31 -
006 Show message and progress panel while backing up.mp4
19:23 -
007 Restore data in SSMS ( SQL Server Management Studio).mp4
07:35 -
008 Restore SQL Database by C#.mp4
14:42 -
009 Add protection before restore SQL Db.mp4
17:10
11 – Background Changer of Main Form
-
001 Quick tour of background changer.mp4
03:24 -
002 Add background selector panel to main form.mp4
14:38 -
003 C# code to create Thumb images from background images.mp4
24:40 -
004 Add method to load background thumb images.mp4
12:24 -
005 Change main form background by selecting the thumb image.mp4
09:28 -
006 Structure of cropping background image for main form.mp4
03:56 -
007 Resize background image to the screen size by C#.mp4
11:27 -
008 C# method to crop the background image.mp4
08:08 -
009 Crop main form image by C# for Sidebar, Top, Bottom & Main panel.mp4
24:21 -
010 Load all parts of main form background image by C#.mp4
12:09 -
011 Select the thumb control for last selected background image.mp4
16:16 -
012 Add semi transparent overlay color to main form controls.mp4
11:18 -
013 C# code to select custom background image.mp4
23:58
12 – Quick review Crystal Reports in C#
-
017 Using the Box object in report.mp4
14:26 -
031 Show full screen reports to user.mp4
09:42 -
030 Loading Crystal Reports from file.mp4
18:30 -
029 Customizing the crystal reports viewer control.mp4
09:26 -
028 Sorting records by specific column in report.mp4
07:11 -
027 Adding total numbers to report.mp4
15:49 -
026 Adding record number column to report.mp4
06:56 -
025 Adding file report path & name to report.mp4
03:41 -
024 Adding page number & total page count to report.mp4
07:20 -
023 Adding Print date and time to report.mp4
05:20 -
022 Formatting date columns.mp4
15:59 -
021 Formatting numeric & currency columns.mp4
18:18 -
020 Customizing details items & column titles in report.mp4
12:56 -
019 Page setup of report Paper size, margin ,.mp4
11:46 -
018 Using the Picture in report.mp4
09:19 -
003 Download and install Crystal Reports in C#.mp4
12:05 -
016 Using the Line object in report.mp4
15:01 -
015 Using the Text object to design report.mp4
16:34 -
014 Load data in Crystal Reports by C# code.mp4
04:15 -
013 Load data in Crystal Reports by designer.mp4
05:42 -
012 Design the first report and add items to it.mp4
09:01 -
011 Main parts of report in Crystal Report.mp4
06:46 -
010 Create a simple report in C# project.mp4
08:38 -
009 Add DataGidView to form and bind it to data using the BindingSource.mp4
07:12 -
008 Make a backup copy of project & how to restore it.mp4
03:06 -
007 Deeper look at TableAdapter, Datatable & connection string.mp4
06:52 -
006 Connect the database to C# project by ADO.Net.mp4
11:19 -
005 Create the C# project to use Crystal Reports.mp4
06:23 -
004 Create the sample SQL Server database.mp4
12:45
13 – Reports by SAP Crystal Reports
-
001 Quick tour for using the crystal reports in .NET core apps.mp4
04:26 -
002 Add new .Net framework project to use Crystal Reports.mp4
11:53 -
003 Add Dataset, TableAdapter , … in Crystal Reports project.mp4
06:59 -
004 Add and load a simple report of Crystal Reports.mp4
09:32 -
005 C# code to run reports Exe file by sending parameter to it.mp4
18:21 -
006 Using dataset to send data between .Net core app and reports app.mp4
16:45 -
007 Design and load a report for incoming letters list.mp4
26:21 -
008 Running directly the Crystal Reports application.mp4
10:22 -
009 Design report to load all details of each record for incoming letters.mp4
20:18 -
010 Design 2 reports for Outgoing letters.mp4
25:33 -
011 Add reports to menus in the main form.mp4
06:08
14 – Finalize the Project
-
001 Add background image to login form.mp4
11:23 -
002 Add shortkeys to main form and other forms.mp4
28:49 -
003 Assign icon to .NET core app and crystal reports app.mp4
08:19 -
004 Change Executable file name of project.mp4
05:10 -
005 Assign versioning information to projects.mp4
13:35 -
006 Create about us form and load version info by C#.mp4
21:57 -
007 Run Windows calculator by C# code.mp4
06:00 -
008 Clean up the TaskList before publishing app.mp4
02:28
15 – Custom Connection String Form
-
001 Add SQL Connection Setting form to project.mp4
17:17 -
002 C# code to generate and save custom SQL connection string.mp4
17:38 -
003 C# code to load the custom connection string.mp4
23:09 -
004 Testify the custom connection string inside project.mp4
14:00 -
005 What is AES Encryption method.mp4
11:10 -
006 Encrypt & Decrypt connection string by AES in C#.mp4
14:45 -
007 Assign custom connection string to all TableAdapters in project.mp4
29:59
Student Ratings & Reviews
No Review Yet