Mastering C# database programming / Jason Price.

Format:

Book

Author/Creator:

Price, Jason.

Language:

English

Subjects (All):

C# (Computer program language).

Distributed databases--Programming.

Distributed databases.

Physical Description:

1 online resource (687 p.)

Edition:

1st ed.

Place of Publication:

San Francisco : Sybex, c2003.

Language Note:

English

Summary:

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 importan

Contents:

Mastering C# Database Programming; Acknowledgments; Contents at a Glance; Contents; Introduction; Who Should Read This Book?; How to Use This Book; Downloading the Example Programs; Part I: Introduction to ADO.NET and Databases; Chapter 1: Introduction to Database Programming with ADO.NET; Obtaining the Required Software; Developing Your First ADO.NET Program; Connecting to Access and Oracle Databases; Introducing Visual Studio .NET; Using the .NET Documentation; Using the SQL Server Documentation; Summary; Chapter 2: Introduction to Databases; Introducing Databases; Using SQL Server

Exploring the Northwind DatabaseBuilding Queries Using Enterprise Manager; Creating a Table; Summary; Chapter 3: Introduction to Structured Query Language (SQL); Using SQL; Accessing a Database Using Visual Studio .NET; Summary; Chapter 4: Introduction to Transact-SQL Programming; Fundamentals of Transact-SQL; Using Cursors; Using Functions; Creating User-Defined Functions; Introducing Stored Procedures; Introducing Triggers; Summary; Chapter 5: Overview of the ADO.NET Classes; The Managed Provider and Generic Data Set Classes; Performing a SQL SELECT Statement and Storing the Rows Locally

SummaryChapter 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

Executing SELECT Statements and TableDirect CommandsExecuting Commands that Modify Information in the Database; Introducing Transactions; Supplying Parameters to Commands; Executing SQL Server Stored Procedures; Creating a Command Object Using Visual Studio .NET; Summary; Chapter 9: Using DataReader Objects to Read Results; The SqlDataReader Class; Creating a SqlDataReader Object; Reading Rows from a SqlDataReader Object; Returning Strongly Typed Column Values; Reading Null Values; Executing Multiple SQL Statements; Using a DataReader Object in Visual Studio .NET; Summary

Chapter 10: Using DataSet Objects to Store DataThe SqlDataAdapter Class; The DataSet Class; Writing and Reading XML Using a DataSet Object; Mapping Tables and Columns; Reading a Column Value Using Strongly Typed DataSet Classes; Creating a DataAdapter Object Using Visual Studio .NET; Creating a DataSet Object Using Visual Studio .NET; Summary; Chapter 11: Using DataSet Objects to Modify Data; The DataTable Class; The DataRow Class; The DataColumn Class; Adding Restrictions to DataTable and DataColumn Objects; Finding, Filtering, and Sorting Rows in a DataTable; Modifying Rows in a DataTable

Retrieving New Identity Column Values

Notes:

Includes index.

ISBN:

1-280-65243-8

9786610652433

0-7821-5179-5

0-585-48783-9

OCLC:

86173042