Flylib.com
List of Figures
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181
Authors:
Kevin McDonald
,
Andreas Wilmsmeier
,
David C. Dixon
,
W. H. Inmon
BUY ON AMAZON
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Creating Forms
Validating Form Data
Working with Advanced Form Elements
Publishing Form Templates
Introducing InfoPath Form Template Projects
C++ How to Program (5th Edition)
Exercises
Exercises
Self-Review Exercises
Other Headers
Summary
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Eight Creating Visions Biased to Your Solution
Chapter Eleven Gaining Access to People with Power
Chapter Twelve Controlling the Buying Process
Appendix B Solution Selling: A Scalable Approach
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
Rethinking Efficient Replenishment in the Grocery Sector
Transforming Technologies: Retail Exchanges and RFID
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Success Story #1 Lockheed Martin Creating a New Legacy
Success Story #2 Bank One Bigger… Now Better
Success Story #4 Stanford Hospital and Clinics At the forefront of the quality revolution
Service Process Challenges
First Wave Service Projects
Programming .Net Windows Applications
The Integrated Development Environment (IDE)
The Forms Namespace
Mouse Events
Text Controls
Updating with SQL
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies