Course Content
01 – Introduction
0/1
001 Introduction to this course.mp4
05:36
02 – Designing Main Form
0/9
001 Start Secretariat Application in C# .NET 6.mp4
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
0/15
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
0/6
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
0/9
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
0/15
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
0/7
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
0/9
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
0/10
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
0/9
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
0/13
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#
0/29
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
0/11
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
0/8
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
0/7
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
[Last updated 6/2023] Fast C# .NET Core Live Project in Windows Forms and SQL (Udemy – Engsub)
Previous
Next
0% Complete