ADO.NET 3.5 Cookbook, Second Edition > Adding and Modifying Data > Modifying Data in a Text File - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

ADO.NET 3.5 Cookbook, Second Edition

ADO.NET 3.5 Cookbook, Second Edition

Search

Contents

ADO.NET 3.5 Cookbook™, Second Edition

Ch. 1. Connecting to Data

Ch. 2. Working with Disconnected Data Objects

Ch. 3. Querying and Retrieving Data

Ch. 4. Searching and Analyzing Data

Ch. 5. Adding and Modifying Data

Recipe 5.0. Introduction

Recipe 5.1. Using Autoincrementing Columns Without Causing Conflicts

Recipe 5.2. Getting an Identity Column Value from SQL Server

Recipe 5.3. Getting an AutoNumber Value from Microsoft Access

Recipe 5.4. Getting a Sequence Value from Oracle

Recipe 5.5. Modifying Data in a Microsoft Excel Workbook

Recipe 5.6. Modifying Data in a Text File

Recipe 5.7. Retrieving Update Errors

Recipe 5.8. Adding Parent/Child Rows with Autoincrementing Keys

Recipe 5.9. Adding Records with a GUID Primary Key

Recipe 5.10. Inserting Multiple Rows into a Database Table Using T-SQL Row Constructors

Recipe 5.11. Updating a Data Source with Data from a Different Data Source

Recipe 5.12. Updating a Primary Key Value

Recipe 5.13. Getting Stored Procedure Parameter Information at Runtime

Recipe 5.14. Updating a DataSet with a Many-to-Many Relationship

Recipe 5.15. Updating Data Asynchronously Using Message Queuing

Recipe 5.16. Controlling Edits, Deletions, or Additions to Data with a DataView

Recipe 5.17. Overcoming Keyword Conflicts When Using a CommandBuilder

Recipe 5.18. Capturing Changes to Data in a SQL Server Database

Ch. 6. Copying and Transferring Data

Ch. 7. Maintaining Database Integrity

Ch. 8. Programmatically Working with Data in .NET Windows and Web Forms User Interfaces

Ch. 9. Working with XML Data

Ch. 10. Optimizing .NET Data Access

Ch. 11. Enumerating and Maintaining Database Objects

Ch. 12. SQL Server CLR Integration

Appx. A. What's New in ADO.NET Since Version 1.0

URL

Help

Recipe 5.6. Modifying Data in a Text File

5.7.1. Problem

You need to modify the contents of a text file.

5.7.2. Solution

Use an OLE DB DataAdapter together with parameterized SQL insert and update statements.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial