Mastering C# Database Programming

Enter a New World of Database Programming C# and ADO.NET facilitate the development of a new generation of database applications, including remote applications that run on the Web. Mastering C# Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes: Accessing a database using C# and ADO.NET Using SQL to access a database Using Visual Studio .NET to build applications Creating and modifying database tables Understanding ADO.NET classes Designing, building, and deploying Web applications that access a database Designing, building, and deploying effective Web services Using SQL Server's built-in XML capabilities Working with a database in a disconnected manner Using advanced transaction controls Using Transact-SQL to create stored procedures and functions in a SQL Server database

enter A New World Of Database Programming

c# And Ado.net

facilitate The Development Of A New Generation Of Database Applications,

including remote Applications That Run On The

web. mastering C# Database Programming Is The Resource You Need To Thrive

in This New World. Assuming No Prior Experience With Database Programming, This

book Teaches You Every Aspect Of The Craft, From Gui Design To Server Development

to Middle-tier Implementation. If You’re Familiar With Earlier Versions Of

ado, You’ll Master The Many New Features Of Ado.net All The More Quickly.

you'll Also Learn The Importance Of Xml Within The New .net Paradigm. Coverage

includes:

• accessing A Database Using C# And

  ado.net

• using Sql To Access A Database

• using Visual Studio .net To Build

  applications

• creating And Modifying Database Tables

• understanding Ado.net

  classes

• designing, Building, And Deploying Web Applications That Access A

  database

• designing, Building, And Deploying Effective Web Services

• using

  sql Server’s Built-in Xml Capabilities

• working With A Database In A

  disconnected Manner

• using Advanced Transaction Controls

• using

  transact-sql To Create Stored Procedures And Functions In A Sql Server

  database

Chapter 6: Introducing Windows Applications and ADO.NET; Developing a Simple Windows Application; Using Windows Controls; Using a DataGrid Control to Access a Database; Using the Data Form Wizard to Create a Windows Form; Summary; Part II: Fundamental Database Programming with ADO.NET; Chapter 7: Connecting to a Database; Understanding the SqlConnection Class; Using a SqlConnection Object to Connect to a SQL Server Database; Creating a Connection Object Using Visual Studio .NET; Summary; Chapter 8: Executing Database Commands; The SqlCommand Class; Creating a SqlCommand Object This guide will help you understand database programming as it provides focused coverage of ADO and how it relates to C#, as well as other complex topics including transactions, Windows forms, Web Forms, XML, and Web Services. A DATABASE IS AN organized collection of information that is divided into tables.