Readers learn how to how to use queries, views and stored procedures to efficiently access and manipulate data from their applications. The author provides examples, tips, real world scenarios, and instruction on accessing data from Windows applications, ASP.Net applications as well as Web Services. ADO.Net will be covered thoroughly so that the reader may get a firm grasp on this important data access technology in .Net. Hands on examples and try it out exercises will be used to help the reader put the topics they read about into practice. This book will not be used so much as a reference but as a teaching tool on building database applications using C#.

Specific Topics Covered:

Database Fundamentals

Viewing Data

Modifying Data

Database and the Internet

ADO.NET Fundamentals

Views and Stored Procedures

Custom Data Binding

Transactions and Concurrency

Working with Disconnected Data

SQL Syntax

XML Syntax

Data Binding Quick Ref

Serving as an ideal teaching tool on building database applications using C#, the book also looks at both visual techniques and data binding and programmatic data access. Real-world examples, new database techniques, and try-it-out exercises all contribute to helping you put your reading about database applications into practice.

What you will learn from this book

• How to use queries, views, and stored procedures to access and manipulate data from your applications
• How to use custom data access code to implement an n-tier design for your applications
• Ways to work with disconnected data
• How to write functions and stored procedures in C#
• How to use Microsoft® SQL Server 2005 Express and other free Express products, which are all you need for this book

Who this book is for

This book is for beginning C# 2005 developers who already have some experience with C# 2005 developing Windows® and ASP.NET applications.

Wrox Beginning guidesare crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

• 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

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.