Wiley.com
Print this page Share

Beginning C# 2005 Databases

ISBN: 978-0-470-04406-3
528 pages
October 2006
Beginning C# 2005 Databases (0470044063) cover image

Description

  • 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
See More

Table of Contents

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.

See More

Author Information

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.
See More

Downloads

Download TitleSizeDownload
Download Code
The downloadable code for this book is divided up into folders, where one folder is used for each chapter. The two appendix directories, Appendix B Code and Appendix C Code, are slightly different. Appendix B Code contains the FolktaleDB database - both as detached .mdf and .ldf files, and as a SQL Script. These files are required for much of the code in other chapters, and should be installed according to Appendix B. In addition, to save space the local database files for FolktaleDB have been removed from the project directories, and should be replaced before running the example applications. See readme files in the chapter directories for more details. Appendix C Code contains the exercise answers for all chapters. The code files are stored in a ZIP archive. If your computer is unable to open ZIP files, you may download a free trial of WinZip.
3.01 MB Click to Download
See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
20 Error in Text
PhoneBookEntry column

should be:
PhoneBookEntryId column
07/03/07
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...
12/01/06
100 Error in Text
line 16, word 15:

"flexibility that in possible with the"

should be:

"flexibility that is possible with the"
01/11/2008
See More

Related Titles

Back to Top