List of Listings

Chapter 1: Introduction to Database Programming with ADO.NET

Listing 1.1: FIRSTEXAMPLE.CS

Listing 1.2: OLEDBCONNECTIONACCESS.CS

Listing 1.3: OLEDBCONNECTIONORACLE.CS

Chapter 4: Introduction to Transact-SQL Programming

Listing 4.1: USING CURSORS

Listing 4.2: DISCOUNTPRICE.SQL

Listing 4.3: PRODUCTSTOBEREORDERED.SQL

Listing 4.4: PRODUCTSTOBEREORDERED2.SQL

Listing 4.5: ADDPRODUCT.SQL

Listing 4.6: PRODUCTAUDIT.SQL

Listing 4.7: INSERTPRODUCTTRIGGER.SQL

Listing 4.8: UPDATEUNITPRICEPRODUCTTRIGGER.SQL

Listing 4.9: DELETEPRODUCTTRIGGER.SQL

Chapter 5: Overview of the ADO.NET Classes

Listing 5.1: SELECTINTODATASET.CS

Chapter 6: Introducing Windows Applications and ADO.NET

Listing 6.1: Form1.cs

Chapter 7: Connecting to a Database

Listing 7.1: MYSQLCONNECTION.CS

Listing 7.2: CONNECTIONPOOLING.CS

Listing 7.3: STATECHANGE.CS

Listing 7.4: INFOMESSAGE.CS

Chapter 8: Executing Database Commands

Listing 8.1: EXECUTESELECT.CS

Listing 8.2: SINGLEROWCOMMANDBEHAVIOR.CS

Listing 8.3: SCHEMAONLYCOMMANDBEHAVIOR.CS

Listing 8.4: EXECUTETABLEDIRECT.CS

Listing 8.5: EXECUTESCALAR.CS

Listing 8.6: EXECUTEXMLREADER.CS

Listing 8.7: EXECUTEINSERTUPDATEDELETE.CS

Listing 8.8: EXECUTEDDL.CS

Listing 8.9: EXECUTETRANSACTION.CS

Listing 8.10: USINGPARAMETERS.CS

Listing 8.11: ADDPRODUCT.SQL

Listing 8.12: EXECUTEADDPRODUCT.CS

Listing 8.13: ADDPRODUCT2.SQL

Listing 8.14: ADDPRODUCT3.SQL

Listing 8.15: EXECUTEADDPRODUCT3.CS

Chapter 9: Using DataReader Objects to Read Results

Listing 9.1: USINGCOLUMNORDINALS.CS

Listing 9.2: STRONGLYTYPEDCOLUMNVALUES.CS

Listing 9.3: STRONGLYTYPEDCOLUMNVALUESSQL.CS

Listing 9.4: EXECUTEMULTIPLESELECTS.CS

Listing 9.5: EXECUTEMULTIPLESQL.CS

Chapter 10: Using Dataset Objects to Store Data

Listing 10.1: POPULATEDATASETUSINGSELECT.CS

Listing 10.2: POPULATEDATASETUSINGRANGE.CS

Listing 10.3: CUSTORDERHIST() STORED PROCEDURE

Listing 10.4: POPULATEDATASETUSINGPROCEDURE.CS

Listing 10.5: MULTIPLEDATATABLES.CS

Listing 10.6: MULTIPLEDATATABLES2.CS

Listing 10.7: MULTIPLEDATATABLES3.CS

Listing 10.8: MERGE.CS

Listing 10.9: MYXMLFILE.XML

Listing 10.10: MYXMLFILE2.XML

Listing 10.11: MYXMLSCHEMAFILE.XML

Listing 10.12: WRITEANDREADXML.CS

Listing 10.13: MAPPINGS.CS

Listing 10.14: MYDATASET.XSD

Chapter 11: Using DataSet Objects to Modify Data

Listing 11.1: ADDRESTRICTIONS.CS

Listing 11.2: FILLSCHEMA.CS

Listing 11.3: FINDFILTERANDSORTDATAROWS.CS

Listing 11.4: ADDPRODUCT4.SQL

Listing 11.5: UPDATEPRODUCT.SQL

Listing 11.6: DELETEPRODUCT.SQL

Listing 11.7: DELETEPRODUCT2.SQL

Chapter 12: Navigating and Modifying Related Data

Listing 12.1: NESTEDXML.CS

Listing 12.2: NONNESTEDXMLFILE.XML

Listing 12.3: NESTEDXMLFILEL.CS

Chapter 13: Using DataView Objects

Listing 13.1: USINGDATAVIEW.CS

Listing 13.2: FINDINGDATAROWVIEWS.CS

Listing 13.3: ADDMODIFYANDREMOVEDATAROWVIEWS.CS

Listing 13.4: CREATECHILDDATAVIEW.CS

Listing 13.4A: USINGDATAVIEWMANAGER.CS

Chapter 14: Advanced Transaction Control

Listing 14.1: SAVEPOINT.SQL

Listing 14.2: SAVEPOINT.CS

Listing 14.3: TransactionIsolation.sql

Listing 14.4: TransactionIsolation.cs

Listing 14.5: Block.cs

Listing 14.6: Deadlock.cs

Chapter 15: Introducing Web Applications-ASP.NET

Listing 15.1: WebForm1.aspx

Listing 15.2: WebForm1.aspx.cs

Listing 15.3: THE WebForm1.aspx FILE

Listing 15.4: THE WebForm1.aspx FILE

Listing 15.5: THE WebForm1.aspx FILE

Listing 15.6: CookieTest.aspx

Listing 15.7: ViewStateTest.aspx

Listing 15.8: SessionObjectTest.aspx

Listing 15.9: ApplicationObjectTest.aspx

Chapter 16: Using SQL Server's XML Support

Listing 16.1: FORXMLRAW.SQL

Listing 16.2: FORXMLAUTO.SQL

Listing 16.3: FORXMLEXPLICIT.SQL

Listing 16.4: FORXMLAUTOXMLDATA.SQL

Listing 16.5: FORXMLAUTOELEMENTS.SQL

Listing 16.6: FORXMLAUTOBINARYBASE64.SQL

Listing 16.7: CUSTOMERS.XML

Listing 16.8: CUSTOMERSWITHATTRIBUTES.XML

Listing 16.9: CUSTOMERSSTYLESHEET.XSL

Listing 16.10: CUSTOMERSUSINGSTYLESHEET.XML

Listing 16.11: CUSTOMERSFROMCOUNTRY.SQL

Listing 16.12: CUSTOMERS.XML

Listing 16.13: CUSTOMERSSTYLESHEET.XSL

Listing 16.14: CUSTOMERSUSINGSTYLESHEET.XML

Listing 16.15: ADDCUSTOMERSXML.SQL

Listing 16.16: RUNADDCUSTOMERS.SQL

Listing 16.17: USINGXMLDOCUMENT.CS

Listing 16.18: USINGXMLDATADOCUMENT.CS

Chapter 17: Web Services

Listing 17.1: CUSTOMERS.ASMX.CS

Listing 17.2: CUSTOMERSWEBSERVICE.CS

Listing 17.3: WEB SERVICE WSDL FILE