Beginning C# Databases: From Novice to Professional

Front Cover

No matter what programs you develop, there always exists a bottom line: you must know how to access and manipulate data. This book teaches you all the essential data manipulation skills that you will need when you code in C#.

Data can be stored in many places, but large quantities of data that need to be frequently accessed are usually stored in relational databases such as SQL Server. Knowing how this data is structured, and how to access and update it, are therefore the most important programming tasks the professional programmer needs to learn.

As well as teaching you database basics, such as using SQL to communicate with databases, this book provides you with detailed and code-practical techniques to access data in C# across a wide range of specific coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 1.1 and offers you the best contemporary practice in this core programming area that you'll find yourself using in nearly all of your .NET projects.

 

What people are saying - Write a review

User Review - Flag as inappropriate

d

Contents

Installing MSDE
1
Creating a Simple Database Application
17
Introducing SQL
39
Whats ADONET?
63
Creating Connections
89
Introducing Commands
113
Introducing Data Readers
145
Introducing Datasets and Data Adapters
173
Using Views and Stored Procedures
381
Using Indexes and Constraints
417
Securing Your Database
441
Using XML and ADONET
467
Handling Exceptions
487
Using Transactions
509
Working with ADONET Events
523
Working with Text and Binary Data
541

Building Windows Forms Applications
219
Using ASPNET
249
Validating Web User Input
291
Working with Tables and Relationships
317
Learning More About Queries
343
Using ADONET 20
567
Creating the SQL Tool Application
581
XML Primer
593
Index
607
Copyright

Other editions - View all

Common terms and phrases

About the author (2004)

Scott Allen has a master's degree in computer science from Shippensburg University of Pennsylvania. He's a Microsoft Certified Solution Developer, and regularly serves as an adjunct faculty member at various colleges in Maryland and Pennsylvania.

Syed Fahad Gilani has more than 15 years of experience in computing. He sold his first program at the age of 10.

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.

James Huddleston has worked with computers since 1974, specializing in database design and development since 1980. He has a bachelor's degree in Latin and Greek from the University of Pennsylvania and a juris doctor degree from the University of Pittsburgh. A technical reviewer of dozens of computer books, including Beginning C# Objects: From Concepts to Code, he finds databases an endlessly fascinating area of work and almost as intellectually rewarding as his hobby: translating Homer's Iliad and Odyssey from the original Greek.

Jon Reid was editor for the C++ and Object Query Language components of the Object Data Management Group standard, and has co-authored several C# books.

Ranga Raghuram has a bachelor's degree in engineering from Birla Institute of Technology and Science in Pilani, India, and a master's degree from Virginia Tech.