List of Figures

Chapter 1: Introduction to Database Programming with ADO.NET

Figure 1.1: The Start page
Figure 1.2: The New Project dialog box with the appropriate settings for a C# console application
Figure 1.3: The VS .NET environment
Figure 1.4: The running program
Figure 1.5: The documentation home page
Figure 1.6: Searching the index for the word console
Figure 1.7: Searching all of the documentation for the word WriteLine
Figure 1.8: The documentation contents viewed in VS .NET
Figure 1.9: SQL Server documentation home page
Figure 1.10: SELECT examples documentation

Chapter 2: Introduction to Databases

Figure 2.1: The Service Manager
Figure 2.2: The Enterprise Manager
Figure 2.3: The Customers, Orders, Order Details, and Products tables
Figure 2.4: The tables of the Northwind database
Figure 2.5: The Customers table properties
Figure 2.6: The alphabetical list of products view properties
Figure 2.7: The CustOrdHist stored procedure properties
Figure 2.8: The dbo user properties
Figure 2.9: The public role properties
Figure 2.10: The public role permissions
Figure 2.11: Relationships between the Customers, Orders, Order Details, and Products tables
Figure 2.12: Relationship between the Customers and Orders table
Figure 2.13: Indexes for the Customers table
Figure 2.14: Rows from the Customers table
Figure 2.15: Rows from the Orders table
Figure 2.16: Restricted rows from the Order Details table
Figure 2.17: Restricted rows from the Products table
Figure 2.18: The query builder
Figure 2.19: Building and running a query
Figure 2.20: Adding a new table
Figure 2.21: Entering the name of the table
Figure 2.22: Setting the permissions
Figure 2.23: Creating the relationship
Figure 2.24: Creating an index
Figure 2.25: Creating a constraint

Chapter 3: Introduction to Structured Query Language (SQL)

Figure 3.1: Connecting to a SQL Server database
Figure 3.2: Viewing database items using the Object Browser and executing a SELECT statement using the Query window
Figure 3.3: Using a SELECT statement to retrieve rows from the Customers table
Figure 3.4: Using a WHERE clause to restrict rows from the Customers table to those where Country is equal to 'UK'
Figure 3.5: Products where ProductName is like 'Cha_'
Figure 3.6: Products where ProductName is like 'Cha%'
Figure 3.7: Products where ProductName is like '[ABC]%'
Figure 3.8: Products where ProductName is like '[^ABC]%'
Figure 3.9: Products where ProductName is like '[A-E]%'
Figure 3.10: Using the IS NULL operator to retrieve customers where Fax contains a null value
Figure 3.11: Using the AND operator to retrieve products where UnitsInStock is less than 10 and ReorderLevel is less than or equal to 20
Figure 3.12: Using the OR operator to retrieve products where either UnitsInStock is less than 10 or ReorderLevel is less than or equal to 20
Figure 3.13: Using the ORDER BY clause to order products by ascending ProductName
Figure 3.14: Using the DESC and ASC keywords to order products by descending UnitsInStock and ascending ReorderLevel
Figure 3.15: Using the TOP keyword to retrieve the top 10 products by ProductID
Figure 3.16: Using the DISTINCT keyword to retrieve distinct Country column values
Figure 3.17: Using the UNION operator to combine retrieved rows from two SELECT statements
Figure 3.18: Using the GROUP BY clause to divide rows into blocks
Figure 3.19: Using the HAVING clause to restrict retrieved groups of rows
Figure 3.20: Using the AS clause to specify the display name for columns
Figure 3.21: Using a multitable SELECT statement to retrieve orders placed by a specific customer
Figure 3.22: Using an INSERT statement to add a new row to the Customers table
Figure 3.23: Using an UPDATE statement to modify the Address column of a row in the Customers table
Figure 3.24: Using an UPDATE statement to remove a row from the Customers table
Figure 3.25: Using a transaction
Figure 3.26: Entering database details using the Data Link Properties dialog box
Figure 3.27: Viewing the rows in the Customers table using the Server Explorer
Figure 3.28: Entering a SQL statement
Figure 3.29: Building a SQL statement visually
Figure 3.30: Properties of the CustomerID columns

Chapter 4: Introduction to Transact-SQL Programming

Figure 4.1: Executing T-SQL using Query Analyzer
Figure 4.2: Using the AVG() function to compute the average value of the UnitPrice column
Figure 4.3: Using the SUM() function to compute the total of the UnitPrice column
Figure 4.4: Using Enterprise Manager to define a function
Figure 4.5: Using an inline table-valued function
Figure 4.6: Using a multistatement table-valued function
Figure 4.7: Using Enterprise Manager to define a procedure
Figure 4.8: Using Enterprise Manager to view a trigger

Chapter 5: Overview of the ADO.NET Classes

Figure 5.1: Some of the managed provider objects
Figure 5.2: Some of the generic data set objects

Chapter 6: Introducing Windows Applications and ADO.NET

Figure 6.1: Creating a C# Windows application in Visual Studio .NET
Figure 6.2: A blank form
Figure 6.3: The form with a label and button control
Figure 6.4: The running form
Figure 6.5: Hiding code in VS .NET using the #region directive
Figure 6.6: Viewing hidden code in VS .NET
Figure 6.7: The Solution Explorer
Figure 6.8: The Class View
Figure 6.9: Form with a DataGrid
Figure 6.10: Form with SqlConnection and SqlDataAdapter objects
Figure 6.11: Setting the ConnectionString property for the sqlConnection1 object
Figure 6.12: SelectCommand property for the sqlDataAdapter1 object
Figure 6.13: The Query Builder
Figure 6.14: Previewing the rows retrieved by the SELECT statement
Figure 6.15: Entering the DataSet details in the Generate Dataset dialog box
Figure 6.16: The running form
Figure 6.17: The running form
Figure 6.18: Adding a data form using the Data Form Wizard
Figure 6.19: Entering the name of the new DataSet
Figure 6.20: Choosing the data connection
Figure 6.21: Logging in to the SQL Server Northwind database
Figure 6.22: Selecting the Customers and Orders tables for use in the form
Figure 6.23: Creating a relationship between two tables
Figure 6.24: Selecting the columns to display from each table
Figure 6.25: Choosing the display style
Figure 6.26: The completed form
Figure 6.27: The editCustomerID text box is bound to the CustomerID column
Figure 6.28: Binding the City column to the editCity text box
Figure 6.29: Setting the ConnectionString property
Figure 6.30: The running form

Chapter 7: Connecting to a Database

Figure 7.1: Creating a SqlConnection object with Visual Studio .NET
Figure 7.2: Selecting the provider
Figure 7.3: Entering the connection details
Figure 7.4: Entering the advanced connection details
Figure 7.5: Viewing all the connection details
Figure 7.6: sqlConnection1 object's events
Figure 7.7: The beginning StateChange event handler method
Figure 7.8: The completed StateChange event handler method

Chapter 8: Executing Database Commands

Figure 8.1: A SqlCommand object in a form
Figure 8.2: Adding the Customers table to the query using the Add Table dialog
Figure 8.3: Adding the CustomerID, CompanyName, and ContactName columns to the query using Query Builder

Chapter 9: Using DataReader Objects to Read Results

Figure 9.1: Obtaining the type of a column using Visual Studio .NET's Server Explorer
Figure 9.2: Adding a ListView control to the form
Figure 9.3: The completed Form1_Load() method
Figure 9.4: The running form

Chapter 10: Using Dataset Objects to Store Data

Figure 10.1: Some of the DataSet objects
Figure 10.2: Using the AS keyword
Figure 10.3: Adding a new Data Set
Figure 10.4: MyDataSet.xsd
Figure 10.5: Customers table added to form
Figure 10.6: Viewing all the files using the Solution Explorer window
Figure 10.7: The running form
Figure 10.8: The Data Adapter Configuration Wizard
Figure 10.9: Choosing your data connection
Figure 10.10: Choosing your query type
Figure 10.11: Generating the SQL statements
Figure 10.12: Final dialog box for the Data Adapter Configuration Wizard
Figure 10.13: The new SqlDataAdapter object in the tray
Figure 10.14: The Generate Dataset dialog box
Figure 10.15: The new DataSet object in the tray
Figure 10.16: The running form

Chapter 12: Navigating and Modifying Related Data

Figure 12.1: The Relationships tab for FK_Orders_Customers
Figure 12.2: Creating the Windows application
Figure 12.3: Selecting both the Customers and Orders tables from Server Explorer
Figure 12.4: The new objects in the tray beneath the form
Figure 12.5: The Generate Dataset dialog box
Figure 12.6: The Schema Editor
Figure 12.7: The Edit Relation dialog box
Figure 12.8: The properties of the new relation

Chapter 13: Using DataView Objects

Figure 13.1: Setting the Properties of dataView1
Figure 13.2: Setting the Properties of dataGrid1
Figure 13.3: The running form

Chapter 14: Advanced Transaction Control

Figure 14.1: Running the Savepoint.sql script in Query Analyzer
Figure 14.2: Running the TransactionIsolation.sql script in Query Analyzer
Figure 14.3: Viewing the locks using the Locks/ Process ID node of Enterprise Manager
Figure 14.4: The transaction on the top part is blocking the transaction on the bottom.
Figure 14.5: Once the top transaction is committed, the bottom UPDATE proceeds.

Chapter 15: Introducing Web Applications-ASP.NET

Figure 15.1: Creating an ASP.NET Web application in Visual Studio .NET
Figure 15.2: Adding TextBox and Button controls to the form
Figure 15.3: The running form
Figure 15.4: The appearance of the final form
Figure 15.5: The ListItem Collection Editor
Figure 15.6: Message from the NameRequired-FieldValidator control
Figure 15.7: Form with a DataGrid
Figure 15.8: The running form
Figure 15.9: The General properties
Figure 15.10: The Columns properties
Figure 15.11: The Paging properties
Figure 15.12: The Format properties
Figure 15.13: The Borders properties
Figure 15.14: Displaying the DataGrid events
Figure 15.15: The running form
Figure 15.16: Form with a DataList
Figure 15.17: The modified header and footer templates with Label controls
Figure 15.18: The Item Templates editor
Figure 15.19: Setting the properties of the table
Figure 15.20: Adding the Label
Figure 15.21: Binding the Label to the ProductID column
Figure 15.22: The running form
Figure 15.23: The running CookieTest.aspx page
Figure 15.24: The running form
Figure 15.25: DataGrid1 properties
Figure 15.26: Buy button properties
Figure 15.27: DataGrid1 with Buy button
Figure 15.28: ShoppingCart DataGrid

Chapter 16: Using SQL Server's XML Support

Figure 16.1: Running a SELECT statement containing a FOR XML RAW clause in Query Analyzer
Figure 16.2: Retrieving rows from the Employees table
Figure 16.3: Customers.xml document structure
Figure 16.4: Viewing Customers.xml in Internet Explorer
Figure 16.5: Viewing CustomersUsing-Stylesheet.xml in Internet Explorer
Figure 16.6: The IIS Virtual Directory Management for SQL Server console
Figure 16.7: Setting the Virtual Directory Name and Local Path
Figure 16.8: Setting the authentication details
Figure 16.9: Setting the data source
Figure 16.10: Setting the type of access
Figure 16.11: Setting the virtual name configuration
Figure 16.12: Selecting customers and displaying results
Figure 16.13: Adding a new row to the Customers table
Figure 16.14: Running a stored procedure
Figure 16.15: Running the Customers.xml file
Figure 16.16: Running the CustomersUsing-Stylesheet .xml file
Figure 16.17: Running the RunAddCustomers .sql script

Chapter 17: Web Services

Figure 17.1: Creating a Web service in VS .NET
Figure 17.2: Adding a new Web service
Figure 17.3: Accessing a Web service
Figure 17.4: The Web service test page
Figure 17.5: Running the RetrieveCustomers() method with a whereClause of CustomerID= 'ALFKI'
Figure 17.6: Running the RetrieveCustomers() method with a whereClause of CustomerID IS NOT NULL
Figure 17.7: Form with controls
Figure 17.8: Northwind Web Service
Figure 17.9: The new Web reference in Solution Explorer
Figure 17.10: The running form
Figure 17.11: The XML Web Services page
Figure 17.12: The UDDI Web Service Registration page
Figure 17.13: The UDDI Business Registry Node page
Figure 17.14: Logging in using a Microsoft Passport account
Figure 17.15: Entering your email address, name, and phone number
Figure 17.16: The terms of use page
Figure 17.17: Setting the business name and description
Figure 17.18: Setting the Web service details




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net