ADO.NET 3.5 Cookbook, 2nd Edition

3.7. Working with Data in a Strongly Typed DataSet

Problem

You have retrieved data into a strongly typed DataSet and you need to access the data.

Solution

The solution demonstrates how to fill a strongly typed DataSet and how to read, insert, update, delete, and work with null data using strongly typed DataSet methods.

Follow these steps:

1. The solution uses a single table AccessTypedDS in the AdoDotNet35Cookbook database. Execute the following T-SQL statement to create the table:

   	USE AdoDotNet35Cookbook
   	GO
   	CREATE TABLE AccessTypedDSTable(
   	    ID int NOT NULL PRIMARY KEY,
   	    StringField nvarchar(50) NULL,
   	    DateField datetime NULL,
   	    MoneyField money NULL )

2. The solution needs some sample data in the table. Execute the following T-SQL batch to add sample data to the table AccessTypedDSTable:

   	USE AdoDotNet35Cookbook
   	GO
   	INSERT INTO AccessTypedDSTable VALUES (1, 'String1', '11/15/2007', 22.95)
   	INSERT INTO AccessTypedDSTable VALUES (2, 'String2', '11/16/2007', 85.99)
   	INSERT INTO AccessTypedDSTable VALUES (3, 'String3', '11/17/2007', 7.63)

3. Create a C# Windows console application, AccessValuesStronglyTypedDataSetXsd. This solution creates the XSD file that will be used to create the strongly typed DataSet class. The C# code in Program.cs is shown in Example 3-8.

   Example 3-8. File: Program.cs for AccessValuesStronglyTypedDataSetXsd solution

   using System; using System.Data; using System.Data.SqlClient; namespace AccessValuesStronglyTypedDataSetXsd { class Program { static void Main(string[] args) { string xsdFileName ...