Beginning C# 2005 Databases: From Novice to Professional

by Jacob Hammer Pedersen, Syed Fahad Gilani, Jon Reid, James Huddleston, Ranga Raghuram

Overview

Beginning C# 2005 Databases: From Novice to Professional teaches you everything you need to know about relational databases, the SQL database language, and ADO.NET 2.0. You'll also get a sound start in developing console, Windows Forms, ASP.NET, and even XML database applications.

This book also teaches you database basics and how to use SQL to communicate with databases. You'll get detailed and code-practical techniques to access data in C# across a wide range of specific coding situations. Fully revised and upgraded for .NET 2.0, this book offers you the best contemporary practice in this core programming area, and you'll find yourself using it in nearly all of your .NET projects. This book systematically:

• Provides step-by-step instructions on installing and configuring Visual C# and SQL Server Express editions
• Presents all essential SQL query and update concepts and syntax, so you dont need prior familiarity with relational databases or SQL
• Describes how to use ADO.NET transactions, exceptions, and events
• Covers ADO.NET features for handling XML, text, and binary data
• Explains all concepts through straightforward code examples

Product Details

ISBN-13:	9781590597774
Publisher:	Apress
Publication date:	12/18/2006
Edition description:	1st ed.
Pages:	500
Product dimensions:	7.52(w) x 9.25(h) x 0.05(d)

About the Author

Jacob Hammer Pedersen started programming in the early 1990s, moving gradually from Pascal to C++ to Visual Basic. In the summer of 2000, he discovered C# and has explored it happily ever since.

Table of Contents

Installing Visual C# and SQL Server Express Editions.- Creating a Simple Database Application.- Introducing SQL.- Introducing ADO.NET.- Creating Connections.- Using Commands.- Using Data Readers.- Using Datasets, Data Tables, and Data Adapters.- Building Windows Forms Applications.- Building ASP.NET Applications.- Working with Tables and Relationships.- Learning More about Queries.- Using Views and Stored Procedures.- Using XML and ADO.NET.- Handling Exceptions.- Using Transactions.- Working with ADO.NET Events.- Working with Text and Binary Data.- Appendix A: XML Primer.

Editorial Reviews

From the reviews:

"This book is a good introduction to the world of databases through ADO.NET, C#, and structured query language (SQL). … Practitioners working in a Microsoft/ADO.NET shop, colleges, and labs that take a practical approach will find this book very valuable." (G. M. White, ACM Computing Reviews, Vol. 49 (8), August, 2008)

From the Publisher