Autoplay
Autocomplete
Previous Lesson
Complete and Continue
18 - C# & Database Connectivity (ADO.NET)
Important Introduction
About This Course (3:43)
Telegram Group for This Course
Introduction
What is XML?
مهم جدا
ليه الاستاذ بعلمنا ADO.NET بيننا مايكروسوفت بترشح Entity framework في التعامل مع الداتا بيس؟
ADO.NET Or Entity Framework (which one to use)?
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)
Datatable Example 6 (Update Rows)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock