Beginning C# 2005 Databases

Karli Watson is a freelance writer, developer, and editor and also the technical director of 3form Ltd. (www.3form.net). He started out with the intention of becoming a world--famous nanotechnologist, so perhaps one day you might recognize his name as he receives a Nobel Prize. For now, however, Karli's main academic interest is the .NET Framework and all the boxes of tricks it contains. Karli is also a snowboarding enthusiast, loves cooking, spends far too much time playing Anarchy Online, and wishes he had a cat. As yet, nobody has seen fit to publish Karli's first novel, but the rejection letters make an attractive pile. If he ever puts anything up there, you can visit Karli online at www.karliwatson.com.

Acknowledgements. Introduction. 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#. Visual Tools. 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. Master/Detail Views. Chapter 6: Accessing Databases Programmatically. Database Connections. Database Commands. Data Reader Objects. Data Adapter Objects. DataSet Objects. Chapter 7: Views and Stored Procedures. Database Views. Stored Procedures. Chapter 8: Custom Data Objects. Custom Data Objects. Chapter 9: Transactions and Concurrency. Concurrency. Transactions. 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. Index.