Read more
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 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 Csharp 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 integrityIdeal 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.
List 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
About the author
Bill Hamilton is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, he has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients.
Summary
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. This book also offers explanations of how and why each code solution works, warns you of potential pitfalls, and cites sources of additional information.
