It is a capital mistake to theorize before one has data. Arthur Conan Doyle
It is a capital mistake to theorize before one has data.
Arthur Conan Doyle
Now go, write it before them in a table, and note it in a book, that it may be for the time to come for ever and ever. Holy Bible, Isaiah 30:8
Now go, write it before them in a table, and note it in a book, that it may be for the time to come for ever and ever.
Holy Bible, Isaiah 30:8
Get your facts first, and then you can distort them as much as you please. Mark Twain
Get your facts first, and then you can distort them as much as you please.
Mark Twain
I like two kinds of men: domestic and foreign. Mae West
I like two kinds of men: domestic and foreign.
Mae West
In this chapter you will learn:
The relational database model.
To write basic database queries in SQL.
To add data sources to projects.
To use the IDE's drag-and-drop capabilities to display database tables in applications.
To use the classes of namespaces System.Data and System.Data.SqlClient to manipulate databases.
To use ADO.NET's disconnected object model to store data from a database in local memory.
To create XML documents from data sources.
Outline
20.1 Introduction20.2 Relational Databases20.3 Relational Database Overview: Books Database20.4 SQL20.4.1 Basic SELECT Query20.4.2 WHERE Clause20.4.3 ORDER BY Clause20.4.4 Merging Data from Multiple Tables: INNER JOIN20.4.5 INSERT Statement20.4.6 UPDATE Statement20.4.7 DELETE Statement20.5 ADO.NET Object Model20.6 Programming with ADO.NET: Extracting Information from a Database20.6.1 Displaying a Database Table in a DataGridView20.6.2 How Data Binding Works20.7 Querying the Books Database20.8 Programming with ADO.NET: Address Book Case Study20.9 Using a DataSet to Read and Write XML20.10 Wrap-Up20.11 Web Resources
20.1 Introduction
20.2 Relational Databases
20.3 Relational Database Overview: Books Database
20.4 SQL
20.4.1 Basic SELECT Query20.4.2 WHERE Clause20.4.3 ORDER BY Clause20.4.4 Merging Data from Multiple Tables: INNER JOIN20.4.5 INSERT Statement20.4.6 UPDATE Statement20.4.7 DELETE Statement
20.4.1 Basic SELECT Query
20.4.2 WHERE Clause
20.4.3 ORDER BY Clause
20.4.4 Merging Data from Multiple Tables: INNER JOIN
20.4.5 INSERT Statement
20.4.6 UPDATE Statement
20.4.7 DELETE Statement
20.5 ADO.NET Object Model
20.6 Programming with ADO.NET: Extracting Information from a Database
20.6.1 Displaying a Database Table in a DataGridView20.6.2 How Data Binding Works
20.6.1 Displaying a Database Table in a DataGridView
20.6.2 How Data Binding Works
20.7 Querying the Books Database
20.8 Programming with ADO.NET: Address Book Case Study
20.9 Using a DataSet to Read and Write XML
20.10 Wrap-Up
20.11 Web Resources