- Providing beginners with the basics of databases, database design, and SQL programming, this book shows novice programmers how to use C# and ADO.NET to manipulate data in databases
- Includes hands-on examples, helpful tips, and real-world scenarios on accessing data from Windows applications, ASP.NET applications, and Web Services
- The SQL provider for accessing SQL Server databases, ADO.NET, and the new .NET 2.0 features
- Covers the fundamentals of accessing and manipulating data while giving a solid understanding of relational database design
- Topics covered include modifying data, custom data binding, working with disconnected data, and much more
Chapter 1: Database Fundamentals.
What Is a Database?
Additional Features of RDBMSes.
What RDBMSes Are Available?
How Do You Use a Database?
Chapter 2: Databases and C#.
Database Access in C#.
Chapter 3: Viewing Data.
Creating Data Sources.
Binding to Data Sources.
Chapter 4: Modifying Data.
Data Modification Prerequisites.
How to Avoid Data Being Overwritten.
Modifying Data from Data-Bound Controls.
Chapter 5: Databases and the Internet.
Web versus Windows Applications.
Data Binding in ASP.NET.
ASP.NET Data Connections.
ASP.NET Data Source Controls.
ASP.NET Data Display Control Summary.
An Introduction to Templates.
Viewing and Editing Data in List Views.
Viewing and Editing Data in Detail Views.
Chapter 6: Accessing Databases Programmatically.
Data Reader Objects.
Data Adapter Objects.
Chapter 7: Views and Stored Procedures.
Chapter 8: Custom Data Objects.
Custom Data Objects.
Chapter 9: Transactions and Concurrency.
Chapter 10: Working with Disconnected Data.
Exposing Web Service Data.
Consuming Web Service Data.
Caching Web Service Data.
Chapter 11: SQL Server CLR Integration.
Overview of CLR Integration.
Common Features of CLR Integrated Code.
Managed Functions and Stored Procedures.
Appendix A: Installation.
Appendix B: Database Installation.
Appendix C: Answers to Exercises.
|20||Error in Text|
|24||Error in Code|
On page 24 the example code for a right outer join is actually for a left outer join.
Code should read:
SELECT * FROM Product RIGHT OUTER JOIN...
|100||Error in Text|
line 16, word 15:
"flexibility that in possible with the"
"flexibility that is possible with the"