Autoplay
Autocomplete
Previous Lesson
Complete and Continue
18 - C# & Database Connectivity.
Important Introduction
About This Course (3:43)
Telegram Group for This Course
Introduction
What is XML?
ADO.NET
What is ADO.NET? (7:11)
ADO.NET Framework Data Providers (12:21)
ADO.NET Architecture (Components) (12:39)
Connect to SQL Server Database - Retrieve Data
ADO.NET Code: Get ALL Contacts. (23:42)
Parameterized Query (9:18)
Parameterized Query With "Like" (5:52)
Retrieve a Single Value (ExecuteScalar) (9:19)
Find Single Contact (4:25)
Connect to SQL Server Database - Insert/Add Data
Insert-Add Data (9:24)
Retrieve Auto Number after Inserting/Adding Data (8:41)
Connect to SQL Server Database - Update Data
Update Data (7:06)
Connect to SQL Server Database - Delete Data
Delete Data (4:59)
Handle In Statement
Handle In Statement (3:44)
CRUD Operations
What are CRUD Operations?
3-Tier Architecutre
What is 3-Tier Architecture? and Why?
Contacts Project on 3 Tier Architecture - Console App
Contacts Solution (Console app) - Find Contact (20:37)
Add New Contact (15:59)
Update Contact (6:24)
Delete Contact (4:51)
List Contacts (8:36)
Is Contact Exist (7:18)
Homeworks
Homework 1: Prepare Business/DataAccess for Countries.
Homework 1: Solution
Homework 2: Add fields to the Country
Homwork 2: Solution
Contacts Windows Form Project
Contacts - WinForms (33:01)
Datatables
What is Datatable? (7:23)
DataTable Example 1 (Create Offline Data Table and ListData) (8:07)
DataTable Example 2 (Count, Sum, Avg, Min, Max) (3:38)
DataTable Example 3 (Filter Data) (9:27)
Datatable Example 4 (Sorting) (2:51)
Datatable Example 5 (Delete Rows) (3:47)
Datatable Example 6 (Update Rows) (2:56)
Datatable Example 7 (Clear)
DataTable Example 8 (Primary Key) (6:49)
DataTable Example 9 (Autoincrement and Others) (8:23)
DataView
What is Dataview? (11:05)
Create Dataview from Datatable (4:28)
Filtering Data in Dataview (2:46)
Sorting Data in Dataview (2:08)
Dataset
What is Dataset? (8:25)
Create Dataset (5:32)
Access Datatables Inside Dataset By Name (5:15)
DataAdapter
What is DataAdapter? (4:01)
DataAdapter Example (6:57)
How to be a Mouse Developer in less than 5 minutes :-)
How to be a Mouse Developer? (4:04)
Conclusion
End Of Course (4:19)
Retrieve a Single Value (ExecuteScalar)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock