ADO.NET 2.0 Cookbook
25%
off

ADO.NET 2.0 Cookbook

4.28 (7 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?

Description

This guide is strikingly different from other books on Microsoft ADO.NET. Rather than loading you down with theory, the new edition of "ADO.NET 3.5 Cookbook" gives you more than 150 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform. Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# and VB.NET code."ADO.NET 3.5 Cookbook" also offers clear explanations of how and why each code solution works, warns you of potential pitfalls, and cites sources of additional information so you can learn to adapt the book's problem-solving techniques to different situations. This collection of timesaving recipes covers vital topics including: connecting to data; retrieving and managing data; transforming and analyzing data; modifying data; binding data to .NET user interfaces; optimizing .NET data access; enumerating and maintaining database objects; and, maintaining database integrity. Ideal for ADO.N
ET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools, such as LINQ, that are key to working with WinFS applications. "ADO.NET 3.5 Cookbook" offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
show more

Product details

  • Paperback | 955 pages
  • 178 x 232 x 41.91mm | 1,419.74g
  • Sebastopol, United States
  • English
  • Revised
  • 2nd Revised edition
  • w. figs.
  • 0596101406
  • 9780596101404
  • 1,681,798

Table of contents

From the contents:
Preface1. Connecting to Data
1.1 Storing Connection Strings
1.2 Building a Connection String
1.3 Connecting to SQL Server
1.4 Connecting to a Named Instance of SQL Server
1.5 Connecting to SQL Server Using an IP Address
1.6 Connecting to SQL Server Using Integrated Security from ASP.NET
1.7 Connecting to an Oracle Database
1.8 Connecting to an OLE DB Data Source
1.9 Connecting to an ODBC Data Source
1.10 Connecting to a Microsoft Access Database
1.11 Connecting to a Password-Protected Microsoft Access Database
1.12 Connecting to a Microsoft Access Database from ASP.NET
1.13 Connecting to a Microsoft Excel Workbook
1.14 Connecting to a Text File
1.15 Changing the Database for an Open Connection
1.16 Setting Connection Pooling Options
1.17 Taking Advantage of Connection Pooling
1.18 Using Transactions with Pooled Connections
1.19 Displaying a Connection Property Dialog Box
1.20 Displaying the Data Link Properties Dialog Box
1.21 Monitoring Connections
2. Working with Disconnected Data Objects
2.1 Creating a DataColumn and Adding It to a DataTable
2.2 Creating a DataTable and Adding It to a DataSet
2.3 Mapping Table and Column Names Between a Data Source and DataSet
2.4 Mapping .NET Data Provider Data Types to .NET Framework Data Types
2.5 Adding a Calculated Column to a DataTable
2.6 Creating a Unique Constraint
2.7 Creating Single- and Multi-Column Primary Keys
2.8 Creating an Autoincrementing Primary Key
2.9 Creating a Foreign Key Constraint
2.10 Creating a Data Relation
2.11 Building a DataSet Programmatically
2.12 Adding a Column to a Child DataTable That Displays Data from the Parent Table
2.13 Adding a Column to a Parent DataTable That Aggregates a Child Table's Column Values
2.14 Converting Between a DataTable and a DataRow Array
2.15 Accessing Data Values in a DataRow Array
2.16 Creating a Strongly Typed DataSet
2.17 Controlling the Names Used in a Strongly Typed DataSet
2.18 Replacing Null Values in a Strongly Typed DataSet
3. Querying and Retrieving Data
3.1 Executing a Query That Does Not Return a Result Set
3.2 Executing a Query That Returns a Single Value
3.3 Retrieving a Result Set Stream Using a DataReader
3.4 Accessing Data Values in a DataReader
3.5 Retrieving a Result Set Using a DataTable or a DataSet
3.6 Accessing Data Values in a DataTable or DataSet
3.7 Working with Data in a Strongly Typed DataSet
show more

Review Text

This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform. Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations. This collection of timesaving recipes covers vital topics including: Connecting to data Retrieving and managing data Transforming and analyzing data Modifying data Binding data to .NET user interfaces Optimizing .NET data access Enumerating and maintaining database objects Maintaining database integrity Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
show more

About Bill Hamilton

Bill Hamilton is a technology and management consultant who specializes in assessing business objectives and company processes and designing and restructuring technology strategy and enterprise architecture. Bill has been designing, developing, and implementing enterprise solutions for 15 years using both Microsoft and J2EE technologies. Bill is the author of O'Reilly titles including the highly praised Programming SQL Server 2005 and ADO.NET Cookbook, and also writes for Microsoft Developer Network.
show more

Rating details

7 ratings
4.28 out of 5 stars
5 57% (4)
4 14% (1)
3 29% (2)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X