Flylib.com
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
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
Table of Contents
BackCover
Mastering C Database Programming
Introduction
How to Use This Book
Downloading the Example Programs
Part 1: Introduction to ADO.NET and Databases
Chapter 1: Introduction to Database Programming with ADO.NET
Obtaining the Required Software
Developing Your First ADO.NET Program
Connecting to Access and Oracle Databases
Introducing Visual Studio .NET
Using the .NET Documentation
Using the SQL Server Documentation
Summary
Chapter 2: Introduction to Databases
Introducing Databases
Using SQL Server
Exploring the Northwind Database
Building Queries Using Enterprise Manager
Creating a Table
Summary
Chapter 3: Introduction to Structured Query Language (SQL)
Using SQL
Accessing a Database Using Visual Studio .NET
Summary
Chapter 4: Introduction to Transact-SQL Programming
Fundamentals of Transact-SQL
Using Cursors
Using Functions
Creating User-Defined Functions
Introducing Stored Procedures
Introducing Triggers
Summary
Chapter 5: Overview of the ADO.NET Classes
The Managed Provider and Generic Data Set Classes
Performing a SQL SELECT Statement and Storing the Rows Locally
Summary
Chapter 6: Introducing Windows Applications and ADO.NET
Developing a Simple Windows Application
Using Windows Controls
Using a DataGrid Control to Access a Database
Using the Data Form Wizard to Create a Windows Form
Summary
Part 2: Fundamental Database Programming with ADO.NET
Chapter 7: Connecting to a Database
Understanding the SqlConnection Class
Using a SqlConnection Object to Connect to a SQL Server Database
Creating a Connection Object Using Visual Studio .NET
Summary
Chapter 8: Executing Database Commands
The SqlCommand Class
Creating a SqlCommand Object
Executing SELECT Statements and TableDirect Commands
Executing Commands that Modify Information in the Database
Introducing Transactions
Supplying Parameters to Commands
Executing SQL Server Stored Procedures
Creating a Command Object Using Visual Studio .NET
Summary
Chapter 9: Using DataReader Objects to Read Results
The SqlDataReader Class
Creating a SqlDataReader Object
Reading Rows from a SqlDataReader Object
Returning Strongly Typed Column Values
Using the Get Methods to Read Column Values
An Example of Using the Get Methods
Reading Null Values
Executing Multiple SQL Statements
Using a DataReader Object in Visual Studio .NET
Summary
Chapter 10: Using Dataset Objects to Store Data
The SqlDataAdapter Class
The DataSet Class
Writing and Reading XML Using a DataSet Object
Mapping Tables and Columns
Reading a Column Value Using Strongly Typed DataSet Classes
Creating a DataAdapter Object Using Visual Studio .NET
Creating a DataSet Object Using Visual Studio .NET
Summary
Chapter 11: Using DataSet Objects to Modify Data
The DataTable Class
The DataRow Class
The DataColumn Class
Adding Restrictions to DataTable and DataColumn Objects
Finding, Filtering, and Sorting Rows in a DataTable
Modifying Rows in a DataTable
Retrieving New Identity Column Values
Using Stored Procedures to Add, Modify, and Remove Rows from the Database
Automatically Generating SQL Statements
Exploring the DataAdapter and DataTable Events
Dealing with Update Failures
Using Transactions with a DataSet (SQL)
Modifying Data Using a Strongly Typed DataSet
Summary
Chapter 12: Navigating and Modifying Related Data
The UniqueConstraint Class
Creating a UniqueConstraint Object
The ForeignKeyConstraint Class
Creating a ForeignKeyConstraint Object
The DataRelation Class
Creating and Using a DataRelation Object
Adding, Updating, and Deleting Related Rows
Issues Involved When Updating the Primary Key of a Parent Row
Nested XML
Defining a Relationship Using Visual Studio .NET
Summary
Chapter 13: Using DataView Objects
The DataView Class
Creating and Using a DataView Object
Using the Default Sort Algorithm
Performing Advanced Filtering
The DataRowView Class
Finding DataRowView Objects in a DataView
Adding, Modifying, and Removing DataRowView Objects from a DataView
Creating Child DataView Objects
The DataViewManager Class
Creating and Using a DataViewManager Object
Creating a DataView Using Visual Studio .NET
Summary
Part 3: Advanced Database Programming with ADO.NET
Chapter 14: Advanced Transaction Control
The SqlTransaction Class
Setting a Savepoint
Setting the Transaction Isolation Level
Understanding SQL Server Locks
Summary
Chapter 15: Introducing Web Applications-ASP.NET
Creating a Simple ASP.NET Web Application Using VS .NET
The Web Form Controls
Building a More Complex Application
Using a DataGrid Control to Access a Database
Using a DataList Control to Access a Database
Maintaining State in a Web Application
Creating a Simple Shopping Cart Application
Summary
Chapter 16: Using SQL Server s XML Support
Using the SQL Server FOR XML Clause
Introducing XPath
Introducing XSLT
Accessing SQL Server Using HTTP
Using the SQL Server OPENXML() Function
Using an XmlDocument Object to Store an XML Document
Using an XmlDataDocument Object to Store an XML Document
Summary
Chapter 17: Web Services
Creating a Web Service
Viewing a WSDL File and Testing a Web Service
Using a Web Service
Registering a Web Service
Summary
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Y
List of Figures
List of Tables
List of Listings
List of Sidebars
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
FileMaker Pro 8: The Missing Manual
Relational Databases
Connecting Databases
Text Parsing Calculations
The Let Function and Variables
Export Formats
Building Web Applications with UML (2nd Edition)
Role of Modeling
Web Application Basics
Web Applications
Architecture Activities
Design
The Complete Cisco VPN Configuration Guide
Overview of VPNs
Introduction to Accessing a Concentrator
IPsec Connections
ISAKMP/IKE Phase 1 Connections
ISAKMP/IKE Phase 1 Connections
Data Structures and Algorithms in Java
Summary
Problems
Projects
Vocabulary
C.6. Constant Factors
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 7. Will the Kids Barf?
Hack 12. Create a Distance Grid in Excel
Hacks 22-34
Hack 62. Build a Car Computer
Conclusion
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
Creating a Struts-based MVC Application
Managing Business Logic with Struts
Building a Data Access Tier with ObjectRelationalBridge
Templates and Velocity
Building the JavaEdge Application with Ant and Anthill
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