book

Beginning Microsoft® Visual C#® 2008

Name: Beginning Microsoft® Visual C#® 2008
ISBN: 9780470191354

by Karli Watson, Christian Nagel, Jacob Hammer Pedersen, Jon D. Reid, Morgan Skinner, Eric White

May 2008

Beginner

1342 pages

31h 52m

English

Wrox

Read now

Unlock full access

Copyright
About the Authors
Credits
Introduction
Who This Book Is ForHow This Book Is StructuredThe C# Language (Chapters 1-14)Windows Programming (Chapters 15-18)Web Programming (Chapters 19-23)Data Access (Chapters 24-29)Additional Techniques (Chapters 30-36)What You Need to Use This BookConventionsSource CodeErratap2p.wrox.com
I. The C# Language
1. Introducing C#
1.1. What Is the .NET Framework?1.1.1. What's in the .NET Framework?1.1.2. Writing Applications Using the .NET Framework1.1.2.1. MSIL and JIT1.1.2.2. Assemblies1.1.2.3. Managed Code1.1.2.4. Garbage Collection1.1.2.5. Fitting It Together1.1.2.6. Linking1.2. What Is C#?1.2.1. Applications You Can Write with C#1.2.2. C# in This Book1.3. Visual Studio 20081.3.1. Visual Studio 2008 Express Products1.3.2. Solutions1.4. Summary
2. Writing a C# Program
2.1. The Development Environments2.1.1. Visual Studio 20082.1.2. Visual C# 2008 Express Edition2.2. Console Applications2.2.1. The Solution Explorer2.2.2. The Properties Window2.2.3. The Error List Window2.3. Windows Forms Applications2.4. Summary
3. Variables and Expressions
3.1. Basic C# Syntax3.2. Basic C# Console Application Structure3.3. Variables3.3.1. Simple Types3.3.2. Variable Naming3.3.2.1. Naming Conventions3.3.3. Literal Values3.3.3.1. String Literals3.3.4. Variable Declaration and Assignment3.4. Expressions3.4.1. Mathematical Operators3.4.2. Assignment Operators3.4.3. Operator Precedence3.4.4. Namespaces3.5. Summary3.6. Exercises
4. Flow Control
4.1. Boolean Logic4.1.1. Bitwise Operators4.1.2. Boolean Assignment Operators4.1.3. Operator Precedence Updated4.2. The goto Statement4.3. Branching4.3.1. The Ternary Operator4.3.2. The if Statement4.3.2.1. Checking More Conditions Using if Statements4.3.3. The switch Statement4.4. Looping4.4.1. do Loops4.4.2. while Loops4.4.3. for Loops4.4.4. Interrupting Loops4.4.5. Infinite Loops4.5. Summary4.6. Exercises
5. More About Variables
5.1. Type Conversion5.1.1. Implicit Conversions5.1.2. Explicit Conversions5.1.3. Explicit Conversions Using the Convert Commands5.2. Complex Variable Types5.2.1. Enumerations5.2.1.1. Defining Enumerations5.2.2. Structs5.2.2.1. Defining Structs5.2.3. Arrays5.2.3.1. Declaring Arrays5.2.3.2. foreach Loops5.2.3.3. Multidimensional Arrays5.2.3.4. Arrays of Arrays5.3. String Manipulation5.4. Summary5.5. Exercises

6. Functions
6.1. Defining and Using Functions6.1.1. Return Values6.1.2. Parameters6.1.2.1. Parameter Matching6.1.2.2. Parameter Arrays6.1.2.3. Reference and Value Parameters6.1.2.4. Out Parameters6.2. Variable Scope6.2.1. Variable Scope in Other Structures6.2.2. Parameters and Return Values Versus Global Data6.3. The Main() Function6.4. Struct Functions6.5. Overloading Functions6.6. Delegates6.7. Summary6.8. Exercises
7. Debugging and Error Handling
7.1. Debugging in VS and VCE7.1.1. Debugging in Nonbreak (Normal) Mode7.1.1.1. Outputting Debugging Information7.1.1.2. Tracepoints7.1.1.3. Diagnostics Output Versus Tracepoints7.1.2. Debugging in Break Mode7.1.2.1. Entering Break Mode7.1.2.1.1. Breakpoints7.1.2.1.2. Other Ways to Enter Break Mode7.1.2.2. Monitoring Variable Content7.1.2.3. Stepping through Code7.1.2.4. Immediate and Command Windows7.1.2.5. The Call Stack Window7.2. Error Handling7.2.1. try ... catch ... finally7.2.2. Listing and Configuring Exceptions7.2.3. Notes on Exception Handling7.3. Summary7.4. Exercises
8. Introduction to Object-Oriented Programming
8.1. What Is Object-Oriented Programming?8.1.1. What Is an Object?8.1.1.1. Properties and Fields8.1.1.2. Methods8.1.2. Everything's an Object8.1.3. The Life Cycle of an Object8.1.3.1. Constructors8.1.3.2. Destructors8.1.4. Static and Instance Class Members8.1.4.1. Static Constructors8.1.4.2. Static Classes8.2. OOP Techniques8.2.1. Interfaces8.2.1.1. Disposable Objects8.2.2. Inheritance8.2.3. Polymorphism8.2.3.1. Interface Polymorphism8.2.4. Relationships Between Objects8.2.4.1. Containment8.2.4.2. Collections8.2.5. Operator Overloading8.2.6. Events8.2.7. Reference Versus Value Types8.2.7.1. Structs8.3. OOP in Windows Applications8.4. Summary8.5. Exercises
9. Defining Classes
9.1. Class Definitions in C#9.1.1. Interface Definitions9.2. System.Object9.3. Constructors and Destructors9.3.1. Constructor Execution Sequence9.4. OOP Tools in VS and VCE9.4.1. The Class View Window9.4.2. The Object Browser9.4.3. Adding Classes9.4.4. Class Diagrams9.5. Class Library Projects9.6. Interfaces Versus Abstract Classes9.7. Struct Types9.7.1. Shallow Copying versus Deep Copying9.8. Summary9.9. Exercises
10. Defining Class Members
10.1. Member Definitions10.1.1. Defining Fields10.1.2. Defining Methods10.1.3. Defining Properties10.1.4. Adding Members from a Class Diagram10.1.4.1. Adding Methods10.1.4.2. Adding Properties10.1.4.3. Adding Fields10.1.5. Refactoring Members10.1.6. Automatic Properties10.2. Additional Class Member Topics10.2.1. Hiding Base Class Methods10.2.2. Calling Overridden or Hidden Base Class Methods10.2.2.1. The this Keyword10.2.3. Nested Type Definitions10.3. Interface Implementation10.3.1. Implementing Interfaces in Classes10.3.1.1. Explicit Interface Member Implementation10.3.1.2. Adding Property Accessors with Nonpublic Accessibility10.4. Partial Class Definitions10.5. Partial Method Definitions10.6. Example Application10.6.1. Planning the Application10.6.1.1. The Card Class10.6.1.2. The Deck Class10.6.2. Writing the Class Library10.6.2.1. Adding the Suit and Rank Enumerations10.6.2.2. Adding the Card Class10.6.2.3. Adding the Deck Class10.6.3. A Client Application for the Class Library10.7. Summary10.8. Exercises
11. Collections, Comparisons, and Conversions
11.1. Collections11.1.1. Using Collections11.1.2. Defining Collections11.1.3. Indexers11.1.4. Adding a Cards Collection to CardLib11.1.5. Keyed Collections and IDictionary11.1.6. Iterators11.1.6.1. Iterators and Collections11.1.7. Deep Copying11.1.8. Adding Deep Copying to CardLib11.2. Comparisons11.2.1. Type Comparison11.2.1.1. Boxing and Unboxing11.2.1.2. The is Operator11.2.2. Value Comparison11.2.2.1. Operator Overloading11.2.2.2. Adding Operator Overloads to CardLib11.2.2.3. The IComparable and IComparer Interfaces11.2.2.4. Sorting Collections Using the IComparable and IComparer Interfaces11.3. Conversions11.3.1. Overloading Conversion Operators11.3.2. The as Operator11.4. Summary11.5. Exercises
12. Generics
12.1. What Is a Generic?12.2. Using Generics12.2.1. Nullable Types12.2.1.1. Operators and Nullable Types12.2.1.2. The ?? Operator12.2.2. The System.Collections.Generics Namespace12.2.2.1. List<T>12.2.2.2. Sorting and Searching Generic Lists12.2.2.3. Dictionary<K, V>12.2.2.4. Modifying CardLib to Use a Generic Collection Class12.3. Defining Generics12.3.1. Defining Generic Classes12.3.1.1. The default Keyword12.3.1.2. Constraining Types12.3.1.3. Inheriting from Generic Classes12.3.1.4. Generic Operators12.3.1.5. Generic Structs12.3.2. Defining Generic Interfaces12.3.3. Defining Generic Methods12.3.4. Defining Generic Delegates12.4. Summary12.5. Exercises
13. Additional OOP Techniques
13.1. The :: Operator and the Global Namespace Qualifier13.2. Custom Exceptions13.2.1. Exception Base Classes13.2.2. Adding Custom Exceptions to CardLib13.3. Events13.3.1. What Is an Event?13.3.2. Handling Events13.3.3. Defining Events13.3.3.1. Multipurpose Event Handlers13.3.3.2. Return Values and Event Handlers13.3.3.3. Anonymous Methods13.4. Expanding and Using CardLib13.4.1. A Card Game Client for CardLib13.5. Summary13.6. Exercises
14. C# 3.0 Language Enhancements
14.1. Initializers14.1.1. Object Initializers14.1.2. Collection Initializers14.2. Type Inference14.3. Anonymous Types14.4. Extension Methods14.5. Lambda Expressions14.5.1. Anonymous Methods Recap14.5.2. Lambda Expressions for Anonymous Methods14.5.3. Lambda Expression Parameters14.5.4. Lambda Expression Statement Bodies14.5.5. Lambda Expressions as Delegates and Expression Trees14.5.6. Lambda Expressions and Collections14.6. Summary14.7. Exercises
II. Windows Programming
15. Basic Windows Programming
15.1. Controls15.1.1. Properties15.1.2. Anchoring, Docking, and Snapping Controls15.1.2.1. Anchor and Dock Properties15.1.3. Events15.2. The Button Control15.2.1. Button Properties15.2.2. Button Events15.2.2.1. Adding the Event Handlers15.3. The Label and LinkLabel Controls15.4. The TextBox Control15.4.1. TextBox Properties15.4.2. TextBox Events15.4.2.1. Adding the Event Handlers15.5. The RadioButton and CheckBox Controls15.5.1. RadioButton Properties15.5.2. RadioButton Events15.5.3. CheckBox Properties15.5.4. CheckBox Events15.5.5. The GroupBox Control15.6. The RichTextBox Control15.6.1. RichTextBox Properties15.6.2. RichTextBox Events15.7. The ListBox and CheckedListBox Controls15.7.1. ListBox Properties15.7.2. ListBox Methods15.7.3. ListBox Events15.7.3.1. Adding the Event Handlers15.8. The ListView Control15.8.1. ListView Properties15.8.2. ListView Methods15.8.3. ListView Events15.8.4. ListViewItem15.8.5. ColumnHeader15.8.6. The ImageList Control15.8.6.1. Adding the Event Handlers15.9. The TabControl Control15.9.1. TabControl Properties15.9.2. Working with the TabControl15.9.2.1. Adding the Event Handler15.10. Summary15.11. Exercises
16. Advanced Windows Forms Features
16.1. Menus and Toolbars16.1.1. Two Is One16.1.2. Using the MenuStrip Control16.1.3. Creating Menus Manually16.1.4. Additional Properties of the ToolStripMenuItem16.1.5. Adding Functionality to Menus16.2. Toolbars16.2.1. ToolStrip Properties16.2.2. ToolStrip Items16.2.2.1. Adding Event Handlers16.2.3. StatusStrip16.2.4. StatusStripStatusLabel Properties16.3. SDI and MDI Applications16.3.1. Building MDI Applications16.4. Creating Controls16.4.1. A LabelTextbox Control16.4.1.1. Adding Properties16.4.1.2. Adding the Event Handlers16.4.2. Debugging User Controls16.4.3. Extending the LabelTextbox Control16.4.3.1. Adding More Properties16.4.3.2. Adding More Event Handlers16.4.3.3. Adding a Custom Event Handler16.5. Summary16.6. Exercises
17. Using Common Dialogs
17.1. Common Dialogs17.2. How to Use Dialogs17.3. File Dialogs17.3.1. OpenFileDialog17.3.1.1. Dialog Title17.3.1.2. Specifying Directories17.3.1.3. Setting the File Filter17.3.1.4. Validation17.3.1.5. Help17.3.1.6. Results17.3.1.7. OpenFileDialog Properties17.3.2. SaveFileDialog17.3.2.1. Dialog Title17.3.2.2. File Extensions17.3.2.3. Validation17.3.2.4. Overwriting Existing Files17.3.2.5. SaveFileDialog Properties17.4. Printing17.4.1. Printing Architecture17.4.1.1. Printing Sequence17.4.1.2. PrintPage Event17.4.2. Printing Multiple Pages17.4.3. PageSetupDialog17.4.3.1. Paper17.4.3.2. Margins17.4.3.3. Orientation17.4.3.4. Printer17.4.4. PrintDialog17.4.4.1. Options for the PrintDialog17.4.4.2. Printing Selected Text17.4.4.3. Printing Page Ranges17.4.4.4. PrintDialog Properties17.5. Print Preview17.5.1. PrintPreviewDialog17.5.2. PrintPreviewControl17.6. FontDialog and ColorDialog17.6.1. FontDialog17.6.1.1. How to Use the FontDialog17.6.1.2. Properties of the FontDialog17.6.1.3. Enabling the Apply Button17.6.2. ColorDialog17.6.2.1. How to Use the ColorDialog17.6.2.2. Properties of the ColorDialog17.6.3. FolderBrowserDialog17.6.3.1. How to Use the Folder Browser Dialog17.6.3.2. Properties of the Folder Browser Dialog17.7. Summary17.8. Exercises
18. Deploying Windows Applications
18.1. Deployment Overview18.2. ClickOnce Deployment18.2.1. Updates18.3. Visual Studio Setup and Deployment Project Types18.4. Microsoft Windows Installer Architecture18.4.1. Windows Installer Terms18.4.2. Advantages of the Windows Installer18.5. Creating an Installation Package for the SimpleEditor18.5.1. Planning the Installation18.5.2. Creating the Project18.5.3. Project Properties18.5.3.1. Packaging18.5.3.2. Prerequisites18.5.3.3. Setup Editors18.5.4. File System Editor18.5.4.1. Adding Items to Special Folders18.5.4.2. File Properties18.5.5. File Types Editor18.5.5.1. Create Actions18.5.6. Launch Condition Editor18.5.7. User Interface Editor18.5.7.1. Additional Dialogs18.6. Building the Project18.7. Installation18.7.1. Welcome18.7.2. Read Me18.7.3. License Agreement18.7.4. Optional Files18.7.5. Select Installation Folder18.7.5.1. Disk Cost18.7.6. Confirm Installation18.7.7. Progress18.7.8. Installation Complete18.7.9. Running the Application18.7.10. Uninstall18.8. Summary18.9. Exercises
III. Web Programming
19. Basic Web Programming
19.1. Overview19.2. ASP.NET Runtime19.3. Creating a Simple Page19.4. Server Controls19.5. Event Handlers19.6. Input Validation19.7. State Management19.7.1. Client-Side State Management19.7.1.1. ViewState19.7.1.2. Cookies19.7.2. Server-Side State Management19.7.2.1. Session19.7.2.2. Application19.7.2.3. Cache19.8. Authentication and Authorization19.8.1. Authentication Configuration19.8.2. Using Security Controls19.9. Reading and Writing to an SQL Server Database19.10. Summary19.11. Exercises
20. Advanced Web Programming
20.1. Master Pages20.2. Site Navigation20.3. User Controls20.4. Profiles20.4.1. Profile Groups20.4.2. Profiles with Components20.4.3. Profiles with Custom Data Types20.4.4. Profiles with Anonymous Users20.5. Web Parts20.5.1. Web Parts Manager20.5.2. Web Parts Zone20.5.3. Editor Zone20.5.4. Catalog Zone20.5.5. Connections20.6. JavaScript20.6.1. Script Element20.6.2. Declaration of Variables20.6.3. Defining Functions20.6.4. Statements20.6.5. Objects20.7. Summary20.8. Exercises
21. Web Services
21.1. Before Web Services21.1.1. Remote Procedure Call (RPC)21.1.1.1. CORBA21.1.1.2. DCOM21.1.1.3. RMI21.1.2. SOAP21.2. Where to Use Web Services21.2.1. A Hotel Travel Agency Application Scenario21.2.2. A Book Distributor Application Scenario21.2.3. Client Application Types21.2.4. Application Architecture21.3. Web Services Architecture21.3.1. What Methods Can I Call?21.3.2. Calling a Method21.3.3. SOAP and Firewalls21.3.4. WS-I Basic Profile21.4. Web Services and the .NET Framework21.4.1. Creating a Web Service21.4.1.1. WebService Attribute21.4.1.2. WebMethod Attribute21.4.1.3. WebServiceBinding Attribute21.4.2. Client21.4.2.1. SoapHttpClientProtocol21.4.2.2. Alternative Client Protocols21.5. Creating a Simple ASP.NET Web Service21.5.1. Adding a Web Method21.6. Testing the Web Service21.7. Implementing a Windows Client21.8. Calling the Service Asynchronously21.9. Implementing an ASP.NET Client21.10. Passing Data21.11. Summary21.12. Exercises
22. Ajax Programming
22.1. Ajax Overview22.2. Update Panel22.3. Timer Control22.4. Update Progress22.5. Web Services22.6. Extender Controls22.7. Summary22.8. Exercises
23. Deploying Web Applications
23.1. Internet Information Services23.2. IIS Configuration23.3. Copying a Web Site23.4. Publishing a Web Site23.5. Windows Installer23.5.1. Creating a Setup Program23.5.2. Installing the Web Application23.6. Summary23.7. Exercises
IV. Data Access
24. File System Data
24.1. Streams24.2. The Classes for Input and Output24.2.1. The File and Directory Classes24.2.2. The FileInfo Class24.2.3. The DirectoryInfo Class24.2.4. Path Names and Relative Paths24.2.5. The FileStream Object24.2.5.1. File Position24.2.5.2. Reading Data24.2.5.3. Writing Data24.2.6. The StreamWriter Object24.2.7. The StreamReader Object24.2.7.1. Reading Data24.2.7.2. Delimited Files24.2.8. Reading and Writing Compressed Files24.3. Serialized Objects24.4. Monitoring the File Structure24.5. Summary24.6. Exercises
25. XML
25.1. XML Documents25.1.1. XML Elements25.1.2. Attributes25.1.3. The XML Declaration25.1.4. Structure of an XML Document25.1.5. XML Namespaces25.1.6. Well-Formed and Valid XML25.1.7. Validating XML Documents25.1.7.1. Schemas25.1.7.1.1. XSD Schemas25.2. Using XML in Your Application25.2.1. XML Document Object Model25.2.1.1. XmlDocument Class25.2.1.2. XmlElement Class25.2.1.3. Changing the Values of Nodes25.2.1.3.1. Inserting New Nodes25.2.1.3.2. Deleting Nodes25.2.2. Selecting Nodes25.2.2.1. XPath25.3. Summary25.4. Exercises
26. Introduction to LINQ
26.1. LINQ Varieties26.2. First LINQ Query26.2.1. Declaring a Variable for Results Using the var Keyword26.2.2. Specify Data Source: from Clause26.2.3. Specify Condition: where Clause26.2.4. Select Items: select Clause26.2.5. Finishing Up: Using the foreach Loop26.2.6. Deferred Query Execution26.3. Using the LINQ Method Syntax and Lambda Expressions26.3.1. LINQ Extension Methods26.3.2. Query Syntax versus Method Syntax26.3.3. Lambda Expressions26.4. Ordering Query Results26.5. orderby Clause26.6. Ordering Using Method Syntax26.7. Querying a Large Data Set26.8. Aggregate Operators26.9. Querying Complex Objects26.10. Projection: Creating New Objects in Queries26.11. Projection: Method Syntax26.12. Select Distinct Query26.13. Any and All26.14. Ordering By Multiple Levels26.15. Multi-Level Ordering Method Syntax: ThenBy26.16. Group Queries26.17. Take and Skip26.18. First and FirstOrDefault26.19. Set Operators26.20. Joins26.21. Resources and Further Reading26.22. Summary26.23. Exercises
27. LINQ to SQL
27.1. Object-Relational Mapping ( ORM )27.2. Installing SQL Server and the Northwind Sample Data27.2.1. Install SQL Server Express 200527.2.2. Installing the Northwind Sample Database27.3. First LINQ to SQL Query27.4. Navigating LINQ to SQL Relationships27.5. Drilling Down Further with LINQ to SQL27.6. Grouping, Ordering, and Other Advanced Queries in LINQ to SQL27.7. Displaying Generated SQL27.8. Data Binding with LINQ to SQL27.9. Updating Bound Data with LINQ to SQL27.10. Summary27.11. Exercises
28. ADO.NET and LINQ over DataSet
28.1. What Is ADO.NET?28.1.1. Why Is It Called ADO.NET?28.1.2. Design Goals of ADO.NET28.1.2.1. Simple Access to Relational Data28.1.2.2. Extensibility28.1.2.3. Support for Multitier Applications28.1.2.4. Unification of XML and Relational Data Access28.2. Overview of ADO.NET Classes and Objects28.2.1. Provider Objects28.2.1.1. Connection Object28.2.1.2. Command Object28.2.1.3. CommandBuilder Object28.2.1.4. DataReader Object28.2.1.5. DataAdapter Object28.2.2. Consumer Objects28.2.2.1. DataSet Object28.2.2.2. DataTable Object28.2.2.2.1. DataRelation Object28.2.3. Using the System.Data Namespace28.2.3.1. SQL Server .NET Data Provider28.2.3.2. Oracle .NET Data Provider28.2.3.3. OLE DB .NET Data Provider28.2.3.4. ODBC .NET Data Provider28.2.3.5. Other Native .NET Data Providers28.3. Reading Data with the DataReader28.4. Reading Data with the DataSet28.4.1. Filling the DataSet with Data28.4.2. Accessing Tables, Rows, and Columns in the DataSet28.5. Updating the Database28.5.1. Adding Rows to the Database28.5.1.1. Finding Rows28.5.2. Deleting Rows28.6. Accessing Multiple Tables in a DataSet28.6.1. Relationships in ADO.NET28.6.1.1. Creating a DataRelation Object28.6.2. Navigating with Relationships28.6.2.1. Fetching the Child Rows28.7. XML and ADO.NET28.7.1. XML Support in ADO.NET DataSets28.8. SQL Support in ADO.NET28.8.1. SQL Commands in Data Adapters28.8.1.1. Using WHERE with SELECT28.8.1.2. Viewing SQL SELECT, UPDATE, INSERT, and DELETE Commands28.8.2. Direct Execution of SQL Commands28.8.2.1. Retrieving Single Values28.8.2.2. Retrieving No Data28.8.3. Calling a SQL Stored Procedure28.9. Using LINQ over DataSet with ADO.NET28.9.1. When to Use LINQ over DataSet28.10. Summary28.11. Exercises
29. LINQ to XML
29.1. LINQ to XML Functional Constructors29.1.1.29.1.1.1. Constructing XML Element Text with Strings29.2. Saving and Loading an XML Document29.2.1. Loading XML from a String29.2.2. Contents of a Saved XML Document29.3. Working with XML Fragments29.4. Generating XML from LINQ to SQL29.4.1. Displaying the Northwind Customer Orders XML Document29.5. How to Query an XML Document29.5.1. Using Query Members29.5.1.1. Elements()29.5.1.2. Descendants()29.5.1.3. Attributes()29.6. Summary29.7. Exercises
V. Additional Techniques
30. Attributes
30.1. What Is an Attribute?30.2. Reflection30.3. Built-in Attributes30.3.1. System.Diagnostics.ConditionalAttribute30.3.2. System.ObsoleteAttribute30.3.3. System.SerializableAttribute30.3.4. System.Reflection.AssemblyDelaySignAttribute30.3.4.1. Delay-Signing the Assembly30.3.4.2. Registering in the GAC30.3.4.3. Completing the Strong Name30.4. Custom Attributes30.4.1. BugFixAttribute30.4.1.1. Creating the Custom Attribute Class30.4.1.2. Creating Constructors and Properties30.4.1.3. Attributing the Class for Usage30.4.1.4. System.AttributeUsageAttribute30.4.1.5. Attribute Scope30.4.1.6. AttributeUsage.AllowMultiple30.4.1.7. AttributeUsage.Inherited30.5. Summary
31. XML Documentation
31.1. Adding XML Documentation31.1.1. XML Documentation Comments31.1.1.1. Text Formatting Elements31.1.1.1.1. <para>31.1.1.1.2. <c> and <code>31.1.1.1.3. <see>, <seealso>, <paramref>, and <typeparamref>31.1.1.1.4. <list> and Associated Elements31.1.1.2. Major Structural Elements31.1.1.2.1. <summary>, <example>, and <remarks>31.1.1.2.2. <param> and <typeparam>31.1.1.2.3. <returns> and <value>31.1.1.2.4. <permission>31.1.1.2.5. <exception>31.1.1.2.6. <seealso>31.1.1.2.7. <include>31.1.2. Adding XML Documentation Using a Class Diagram31.1.3. Generating XML Documentation Files31.1.4. Example Application with XML Documentation31.2. Making Use of XML Documentation31.2.1. Programmatically Processing XML Documentation31.2.2. Styling XML Documentation with XSLT31.2.3. Documentation Tools31.3. Summary31.4. Exercises
32. Networking
32.1. Networking Overview32.1.1. Name Resolution32.1.2. Uniform Resource Identifier32.1.3. TCP and UDP32.1.4. Application Protocols32.2. Networking Programming Options32.3. WebClient32.4. WebRequest and WebResponse32.5. TcpListener and TcpClient32.6. Summary32.7. Exercises
33. Introduction to GDI +
33.1. Overview of Graphical Drawing33.1.1. The Graphics Class33.1.2. Disposing of Objects33.1.3. Coordinate System33.1.3.1. Point33.1.3.2. Size33.1.3.3. Rectangle33.1.3.4. GraphicsPaths33.1.3.5. Regions33.1.4. Colors33.2. Drawing Lines Using the Pen Class33.3. Drawing Shapes Using the Brush Class33.4. Drawing Text Using the Font Class33.5. Drawing Using Images33.5.1. Drawing with a Texture Brush33.5.2. Double-Buffering33.6. Advanced Capabilities of GDI +33.6.1. Clipping33.6.2. System.Drawing.Drawing2D33.6.3. System.Drawing.Imaging33.7. Summary33.8. Exercises
34. Windows Presentation Foundation
34.1. What Is WPF?34.1.1. WPF for Designers34.1.2. WPF for C# Developers34.2. Anatomy of a Basic WPF Application34.3. WPF Fundamentals34.3.1. XAML Syntax34.3.1.1. Object Element Syntax34.3.1.2. Attribute Syntax34.3.1.3. Property Element Syntax34.3.1.4. Content Syntax34.3.1.5. Mixing Property Element Syntax and Content Syntax34.3.1.6. Markup Extensions34.3.2. Desktop and Web Applications34.3.3. The Application Object34.3.4. Control Basics34.3.4.1. Dependency Properties34.3.4.2. Attached Properties34.3.4.3. Routed Events34.3.4.4. Attached Events34.3.5. Control Layout34.3.5.1. Stack Order34.3.5.2. Alignment, Margins, Padding, and Dimensions34.3.5.3. Border34.3.5.4. Canvas34.3.5.5. DockPanel34.3.5.6. Grid34.3.5.7. StackPanel34.3.5.8. WrapPanel34.3.6. Control Styling34.3.6.1. Styles34.3.6.2. Templates34.3.7. Triggers34.3.8. Animation34.3.8.1. Timelines Without Key Frames34.3.8.2. Timelines with Key Frames34.3.9. Static and Dynamic Resources34.3.9.1. Static Resources34.3.9.2. Dynamic Resources34.3.9.3. Referencing Style Resources34.4. Programming with WPF34.4.1. WPF User Controls34.4.2. Implementing Dependency Properties34.5. Summary34.6. Exercises
35. Windows Communication Foundation
35.1. What Is WCF?35.2. WCF Concepts35.2.1. WCF Communication Protocols35.2.2. Addresses, Endpoints, and Bindings35.2.3. Contracts35.2.4. Message Patterns35.2.5. Behaviors35.2.6. Hosting35.3. WCF Programming35.3.1. Defining WCF Service Contracts35.3.1.1. Data Contracts35.3.1.2. Service Contracts35.3.1.3. Operation Contracts35.3.1.4. Message Contracts35.3.1.5. Fault Contracts35.3.2. Self-Hosted WCF Services35.4. Summary35.5. Exercises
36. Windows Workflow Foundation
36.1. Activities36.1.1. DelayActivity36.1.2. SuspendActivity36.1.3. WhileActivity36.1.4. SequenceActivity36.1.4.1. Handling Faults36.1.4.2. Providing Cleanup Code36.1.5. Custom Activities36.1.5.1. Activity Validation36.1.5.2. Adding an Activity Validator36.1.5.3. Enhancing Design Time36.2. The Workflow Runtime36.3. Data Binding36.4. Summary

Content preview from Beginning Microsoft® Visual C#® 2008

Chapter 28. ADO.NET and LINQ over DataSet

The previous chapter introduced LINQ (Language-Integrated Query) and showed how it works with objects. This chapter introduces ADO.NET, which is the traditional way of accessing databases with previous versions of C# and .NET, and then it introduces LINQ over DataSet, which is the version of LINQ that cooperates with ADO.NET.

All examples in this chapter use the SQL Server Northwind example database (except where specifically noted). See the previous chapter for instructions on installing the SQL Server Northwind example database.

In particular, this chapter looks at the following:

An overview of ADO.NET and the structure of its main classes.
Reading data with a DataReader and with a DataSet.
Updating the database, adding records, and deleting records.
Working with relationships in ADO.NET.
Reading and writing XML documents in ADO.NET.
Executing SQL commands directly from ADO.NET.
Executing stored procedures from ADO.NET.
Querying ADO.NET objects with LINQ over DataSet.

After an overview of ADO.NET, you will learn the concepts behind it. Then you can create some simple projects and start using the ADO.NET classes.

What Is ADO.NET?

ADO.NET is the name for the set of classes you use with C# and the .NET Framework to access data in a relational, table-oriented format. This includes relational databases such as Microsoft SQL Server and Microsoft Access, as well as other databases and even nonrelational data sources. ADO.NET is integrated into the .NET Framework ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470191354Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Beginning Microsoft® Visual C#® 2008

by Karli Watson, Christian Nagel, Jacob Hammer Pedersen, Jon D. Reid, Morgan Skinner, Eric White

Chapter 28. ADO.NET and LINQ over DataSet

What Is ADO.NET?

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.