List of Tables

Chapter 2: Introduction to Databases

Table 2.1: SOME ROWS FROM THE PRODUCTS TABLE
Table 2.2: MEANING OF THE AVAILABLE PERMISSIONS
Table 2.3: SQL SERVER DATABASE TYPES
Table 2.4: DEFINITION FOR THE COLUMNS OF THE Customers TABLE
Table 2.5: DEFINITION FOR THE COLUMNS OF THE Orders TABLE
Table 2.6: DEFINITION FOR THE COLUMNS OF THE Order Details TABLE
Table 2.7: DEFINITION FOR THE COLUMNS OF THE Products TABLE
Table 2.8: DEFINITION FOR THE COLUMNS OF THE Persons TABLE

Chapter 3: Introduction to Structured Query Language (SQL)

Table 3.1: SQL MATHEMATICAL OPERATORS
Table 3.2: WILDCARD CHARACTERS
Table 3.3: LOGICAL OPERATORS

Chapter 4: Introduction to Transact-SQL Programming

Table 4.1: RETURN VALUES FROM THE @@FETCH_STATUS FUNCTION
Table 4.2: FUNCTIONS
Table 4.3: AGGREGATE FUNCTIONS
Table 4.4: MATHEMATICAL FUNCTIONS
Table 4.5: STRING FUNCTIONS
Table 4.6: DATE AND TIME FUNCTIONS
Table 4.7: SYSTEM FUNCTIONS
Table 4.8: ROW ADDED TO THE ProductAudit TABLE BY InsertProductTrigger
Table 4.9: ROW ADDED TO THE ProductAudit TABLE BY UpdateUnitPriceProductTrigger
Table 4.10: ROW ADDED TO THE ProductAudit TABLE BY DeleteProductTrigger

Chapter 6: Introducing Windows Applications and ADO.NET

Table 6.1: ACCESS MODIFIERS
Table 6.2: COMMONLY USED WINDOWS FORM CONTROLS

Chapter 7: Connecting to a Database

Table 7.1: SqlConnection PROPERTIES
Table 7.2: SqlConnection METHODS
Table 7.3: SqlConnection EVENTS
Table 7.4: ConnectionState CONSTANTS

Chapter 8: Executing Database Commands

Table 8.1: SqlCommand PROPERTIES
Table 8.2: SqlCommand METHODS
Table 8.3: CommandType ENUMERATION VALUES
Table 8.4: METHODS THAT RETRIEVE INFORMATION FROM THE DATABASE
Table 8.5: CommandBehavior ENUMERATION VALUES
Table 8.6: SCHEMA COLUMN VALUES
Table 8.7: FOR XML KEYWORDS
Table 8.8: THE ExecuteNonQuery() METHOD
Table 8.9: SqlDbType ENUMERATION MEMBERS

Chapter 9: Using DataReader Objects to Read Results

Table 9.1: SqlDataReader PROPERTIES
Table 9.2: SqlDataReader METHODS
Table 9.3: STANDARD C# AND .NET TYPES
Table 9.4: SQL SERVER TYPES, COMPATIBLE STANDARD C# TYPES, AND GET* METHODS
Table 9.5: Products TABLE COLUMNS, TYPES, AND METHODS
Table 9.6: Sql* TYPES
Table 9.7: SQL SERVER TYPES, COMPATIBLE Sql* TYPES, AND GetSql* METHODS
Table 9.8: Products TABLE COLUMNS, TYPES, AND GetSql* METHODS

Chapter 10: Using Dataset Objects to Store Data

Table 10.1: SqlDataAdapter PROPERTIES
Table 10.2: SqlDataAdapter METHODS
Table 10.3: SqlDataAdapter EVENTS
Table 10.4: DataSet PROPERTIES
Table 10.5: DataSet METHODS
Table 10.6: DataSet EVENT
Table 10.7: MissingSchemaAction ENUMERATION MEMBERS
Table 10.8: XmlWriteMode ENUMERATION MEMBERS
Table 10.9: XmlReadMode ENUMERATION MEMBERS

Chapter 11: Using DataSet Objects to Modify Data

Table 11.1: DataTable PROPERTIES
Table 11.2: DataTable METHODS
Table 11.3: DataTable EVENTS
Table 11.4: DataRow PROPERTIES
Table 11.5: DataRow METHODS
Table 11.6: DataColumn PROPERTIES
Table 11.7: SchemaType ENUMERATION MEMBERS
Table 11.8: DataViewRowState ENUMERATION MEMBERS
Table 11.9: DataRowVersion ENUMERATION MEMBERS
Table 11.10: DataRowState ENUMERATION MEMBERS
Table 11.11: SqlDataAdapter EVENTS
Table 11.12: FillErrorEventArgs PROPERTIES
Table 11.13: SqlRowUpdatingEventArgs PROPERTIES
Table 11.14: ADDITIONAL SqlRowUpdatedEventArgs PROPERTY
Table 11.15: DataTable EVENTS
Table 11.16: DataColumnChangeEventArgs PROPERTIES
Table 11.17: DataRowChangeEventArgs PROPERTIES

Chapter 12: Navigating and Modifying Related Data

Table 12.1: UniqueConstraint PROPERTIES
Table 12.2: ForeignKeyConstraint PROPERTIES
Table 12.3: DataRelation PROPERTIES
Table 12.4: Rule ENUMERATION MEMBERS

Chapter 13: Using DataView Objects

Table 13.1: DataView PROPERTIES
Table 13.2: DataView METHODS
Table 13.3: DataViewRowState ENUMERATION MEMBERS
Table 13.4: DataRowView PROPERTIES
Table 13.5: DataRowView METHODS
Table 13.6: DataViewManager PROPERTIES

Chapter 14: Advanced Transaction Control

Table 14.1: SqlTransaction PROPERTIES
Table 14.2: SqlTransaction METHODS
Table 14.3: SQL Standard Isolation Levels
Table 14.4: IsolationLevel Enumeration Members
Table 14.5: SQL Server Lock Types
Table 14.6: SQL Server Locking Modes

Chapter 15: Introducing Web Applications-ASP.NET

Table 15.1: WEB FORM CONTROLS
Table 15.2: Label CONTROLS
Table 15.3: RadioButtonList ITEMS
Table 15.4: DropDownList ITEMS

Chapter 16: Using SQL Server's XML Support

Table 16.1: FOR XML KEYWORDS
Table 16.2: DIRECTIVES
Table 16.3: SPECIFYING THE CONTEXT
Table 16.4: SPECIAL CHARACTERS IN A SQL STATEMENT AND THEIR REPLACEMENTS IN A URL
Table 16.5: XmlDocument Properties
Table 16.6: XmlDocument Methods
Table 16.7: XmlDocument Events
Table 16.8: XmlDataDocument Methods




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