C# Database

Time Description
0:25 XML (Extensible Markup Language)
0:45 Sample document (Fig 24-7)
1:03 Document is marked with “tags”
1:06 Attributes can be contained in start tags
1:58 ADO .NET (ActiveX Data Objects) – used to communicate with databases and manipulate their data.
2:15 Namespace System.Data is the root namespace. Contains System.Data.OleDb and System.Data.SqlClient which contain classes used to connect and modify data sources.
2:35 System.Data.OleDb – contains classes that are designed to work with any datasource.
2:52 System.Data.SqlClient – contains classes that are optimized to work with SQL Server databases.
4:27 DataSet – consist of DataTables and relationships among those DataTables. DataSets mimic the structure of a relational database. It is an in-memory database. DataSets are made up of the classes DataColumn and DataRow.
5:40 DataSets are disconnected, which means that a persistent connection to the datasource is not needed
6:03 Class OleDbConnection – represent connections to a datasource.
6:25 Class OleDbDataAdapter – uses the OleDbConnection class to connect to a datasource and can populate a DataSet..
6:48 Class OleDbCommand – represents an arbitrary SQL command to be executed.
6:55 How to add OleDB via NuGet
7:51 Chapter 21 DB Class Example
22:15 Chapter 21 DataGrid Example Program
40:45:00 Chapter 21 DataGridView adding objects Program
50:00:00 Chpt 21 DB and Add Object Combobox Program