Beginning C# 2005 Databases: From Novice to Professional

Front Cover

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
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Getting Our Tools
1
Getting to Know Our Tools
17
Introducing SQL
43
Introducing ADONET
65
Introducing Connections
95
Introducing Commands
115
Introducing Data Readers
141
Introducing Datasets and Data Adapters
171
Learning More About Queries
277
Using Stored Procedures
313
Handling Exceptions
335
Using Transactions
359
Working with ADONET Events
379
Working with Text and Binary Data
403
Using XML
431
Introducing LINQ
459

Introducing Data Binding
227
Understanding Tables and Relationships
251

Other editions - View all

Common terms and phrases

About the author (2007)

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.

Bibliographic information