Sams Teach Yourself ADO.NET in 21 Days

RAISERROR statement  

RangeValidator control  

rapid development of multi-tiered applications  

RCW (runtime callable wrapper)  

       COM object   2nd  

RDO

       (Remote Data Objects)  

rdoResultset object  

RDS

       (Remote Data Services  

Read method

       data reader (.NET Data Providers)  

       data readers, traversing   2nd  

read-only data

       caching  

ReadBinaryData method

       code   2nd  

ReadCommitted mode  

readers

       data

               binding to DropDownList controls, code   2nd  

               exposing in data services tier  

               manually binding to ListView controls, code   2nd  

       XmlReader  

readers.   [See also data reader]2nd   [See also data readers]3rd   [See also data readers]

reading

       ADO Recordset object data   2nd   3rd   4th   5th   6th   7th   8th   9th  

       binary data

               code   2nd  

       table column multiple values, code   2nd  

ReadOnly property   2nd  

       DataColumn class  

ReadSchema value (XmlReadMode enumeration)  

ReadUncommitted mode  

ReadXml method   2nd  

ReadXML method

       DataSet class  

ReadXml method

       XmlReadMode enumeration   2nd   3rd  

ReadXmlSchema method   2nd   3rd   4th  

ReadXMLSchema method

       DataSet class  

real data type

       and float data type, comparing  

RecordsAffected property   2nd  

       data reader (.NET Data Providers)  

RecordsAffected property (event arguments)  

Recordset objects   2nd  

       disconnected  

Recordset objects (ADO)

       data, reading   2nd   3rd   4th   5th   6th   7th   8th   9th  

reducing

       programming errors in ADO.NET design   2nd   3rd  

reference types

       definition  

references

       database  

       updating  

       Web References folder  

referencing

       ADO.NET  

       Catalog Web service   2nd  

       data types

               code   2nd  

       remote servers  

       SqlServer namespace  

reformatted

       XML (eXtensible Markup Language)

               code   2nd  

refreshing

       rows   2nd  

registries

       CLSID key (COM components )  

regular expressions

       Parse event  

       Validating event  

RegularExpressionValidator control   2nd   3rd   4th   5th  

RejectChanges method

       DataRow class  

       DataSet class  

       DataTable class  

       rows  

       table rows   2nd   3rd  

Relation icon (XML Schema tab of XML Schema Toolbox)  

relational and object-oriented paradigms , combining   2nd  

relational data access  

relational database engines

       TDS (Tabular Data Stream)  

relational databases

       Access  

       and DataView objects, comparing  

Relations collection

       DataSet class  

relationships

       data tables in DataSets, editing  

       many to many  

       navigating with DataGrid  

       navigating with DataGrid object  

       of tables

               navigating with Expression property  

remotable types

       definition  

Remote Data Objects.   [See RDO]

Remote Data Services.   [See RDS]

remote procedure calls (RPCs)

       XML Web Services  

remote servers

       referencing  

remoted

       DataSets

               NET [edit, period before] Remoting  

remotes

       NET [edit, period before] Remoting

               types, copying  

RemoveStatement method

       data factory class  

reports

       flash  

RequiredFieldValidator control   2nd   3rd  

Reset method  

       DataSet class  

       DataTable class  

       table rows  

ResetCommandTimeout method

       command classes (.NET Data Providers)  

resetting

       connections  

resource pooling.   [See session pooling]

resources

       Asynchronous Design Pattern Overview [edit, in double quotes] article  

       Building Distributed Applications with Visual Basic .NET [edit, italics]   2nd   3rd   4th   5th  

       Building Distributed Applications with Visual Basic .NET [edit, italics}  

       Data Access Application Block [edit, double quotes] article  

       Design Guidelines for Class Library Developers [edit, title in double quotes]  

       Design Patterns Explained

                A New Perspective on Object-Oriented Design [edit, italics]  

       Essential .NET Volume [edit, italics]  

       Object Role Modeling[ colon ] An Overview [edit, place title in double quotes]  

       Pure Visual Basic [edit, italics)  

       Sams Teach Yourself XML in 21 Days [edit, italics], Second Edition  

       Sams Teach Yourself XML in 21 Days, Second Edition [edit, italics]  

       SQL Server

               Books Online  

result sets

       retrieving   2nd   3rd   4th   5th   6th  

               code   2nd  

       returning

               code   2nd  

       returning with data readers   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

Resume method

       threads  

retrieving

       column multiple values   2nd   3rd   4th   5th   6th  

       column single values   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

       column strongly typed values, code   2nd  

       data   2nd   3rd   4th   5th   6th  

               ExecuteReader method   2nd   3rd   4th   5th   6th  

               ExecuteScalar method   2nd   3rd  

               ExecuteXmlReader method   2nd   3rd   4th   5th   6th   7th   8th  

               Fill method   2nd   3rd   4th   5th  

               Fill method, rules   2nd  

               incrementally, code   2nd  

               metadata, adding for SQL Server   2nd   3rd   4th   5th   6th   7th  

               result sets, retrieving   2nd   3rd   4th   5th   6th  

               without strong-typing  

       extended properties, code   2nd  

       result sets   2nd   3rd   4th   5th   6th  

       result sets, code   2nd  

       row changes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

retrieving schemas

       GetSchemaTable method   2nd   3rd  

return values

       command object parameters   2nd   3rd  

       SQL Server  

returning

       custom objects for data access classes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  

       data readers  

       DataSet class

               code   2nd  

       DataSet data over WWW (World Wide Web)  

       IDbCommand object  

       result sets

               code   2nd  

               with data readers   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

reusability of multi-tiered applications  

RevByBook method  

ReviewNo column  

Reviews element

       viewing in XML Schema Designer   2nd  

reviews of books

       ComputeBooks  

       tables

               defining   2nd  

Reviews table

       data

               retrieving  

               retrieving, code   2nd  

ReviewsDataTable class  

       rows

               method to find  

ReviewsRow class  

       rows

               adding  

               code to add   2nd  

       table columns

               exposing as properties   2nd  

               exposing as properties, code   2nd   3rd  

ReviewsRowChangeEvent class  

roles

       ORM

               (Object Role Modeling)  

Rollback method

       transaction classes (.NET Data Providers)  

ROLLBACK TRANSACTION statement  

rolling back transactions  

round trips to database servers

       minimizing   2nd  

round-tripping databases

       definition  

Row property (event arguments)   2nd  

row version

       timestamp columns  

RowChanged event

       DataTable class  

RowChanging event

       DataTable class  

RowDeleted event

       DataTable class  

RowDeleting event

       DataTable class  

RowError property

       DataRow class  

RowFilter property   2nd  

       DataView class   2nd  

RowNotInTableException

       throwing  

rows

       AcceptChanges method   2nd  

       Added value (DataRowState enumeration)  

       Added value (DataViewRowState enumeration)  

       adding  

               code   2nd  

               with Add method  

       changes

               retrieving   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

       committing to tables   2nd   3rd  

       creating

               with NewRow method  

       Current value (DataRowVersion enumeration)  

       Current version   2nd  

       CurrentRows value (DataViewRowState enumeration)  

       data

               changing   2nd  

               changing, code   2nd  

       data tables   2nd   3rd   4th   5th   6th   7th   8th  

       DataRowState enumeration

               values   2nd  

       DataRowVersion enumeration

               values  

       DataSet class

               GetChanges method   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

       DataTable class

               GetChanges method   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

       DataView object   2nd   3rd   4th  

               RowStateFilter property  

       DataViewRowState enumeration

               values  

       Default value (DataRowVersion enumeration)  

       Default version  

       deleted   2nd  

       Deleted value (DataRowState enumeration)  

       Deleted value (DataViewRowState enumeration)  

       Detached

               DataSet class  

       detatched   2nd  

       Detatched value (DataRowState enumeration)  

       DiffGrams   2nd   3rd   4th  

       errors

               checking, code   2nd  

               code to create   2nd  

       filtering

               code   2nd  

       finding

               in DataView objects   2nd  

               in ReviewsDataTable class  

               in TitlesDataTable class  

       GetError method  

       in Orders table

               traversing  

       in Titles table

               code to delete   2nd  

       information

               code to manipulate   2nd  

               manipulating   2nd  

       inserting

               into tables  

       Modified value (DataRowState enumeration)  

       ModifiedCurrent value (DataViewRowState enumeration)  

       ModifiedOriginal value (DataViewRowState enumeration)  

       None value (DataViewRowState enumeration)  

       Original value (DataRowVersion enumeration)  

       Original version   2nd  

       OriginalRows value (DataViewRowState enumeration)  

       Proposed value (DataRowVersion enumeration)  

       Proposed version  

       refreshing   2nd  

       RejectChanges method   2nd   3rd  

       requesting   2nd  

       Reset method  

       states   2nd   3rd   4th   5th   6th   7th  

               code  

       Tables

               Original version  

        Transact -SQL EXISTS clause  

       Unchanged

               DataSet class  

       Unchanged value (DataRowState enumeration)  

       Unchanged value (DataViewRowState enumeration)  

       updating

               Both value (UpdateRowSource enumeration)  

               Command property (event arguments)   2nd  

               Errors property (event arguments)   2nd  

               event argument properties   2nd  

               None value (UpdateRowSource enumeration)  

               OutputParameters value (UpdateRowSource enumeration)  

               RecordsAffected property (event arguments)  

               Row property (event arguments)   2nd  

               StatementType property (event arguments)   2nd  

               Status property (event arguments)   2nd  

               TableMapping property (event arguments)   2nd  

               UpdateRowSource enumeration, values  

       versions   2nd   3rd   4th   5th   6th   7th   8th   9th  

               viewing  

               viewing, code   2nd  

       WriteTitleXml function

               code to copy   2nd  

Rows property

       DataSet object   2nd   3rd   4th   5th   6th   7th   8th  

       DataTable class  

RowState property

       DataRow class  

       DataRow object   2nd  

RowStateFilter property   2nd   3rd   4th  

       DataView class  

       DataView object  

RowUpdated event

       data stores, updating   2nd   3rd   4th   5th  

RowUpdated method

       data adapters (.NET Data Providers)  

RowUpdating event

       data stores, updating   2nd   3rd   4th   5th  

RowUpdating method

       data adapters (.NET Data Providers)  

rowversion synonym for timestamp data type  

RPCs (remote procedure calls)

       XML Web Services  

rules

       Aggregate Functions (expression syntax rule)

               data, selecting  

       Column Names (expression syntax rule)

               data, selecting  

       expression syntax

               data, selecting   2nd   3rd  

       Fill method   2nd  

       Functions (expression syntax rule)

               data, selecting  

       inference

               schemas, infering from documents   2nd   3rd  

       Literal Values (expression syntax rule)

               data, selecting  

       mapping XSD to DataSets   2nd   3rd  

       Operators (expression syntax rule)

               data, selecting  

       Parent and Child Relations (expression syntax rule)

               data, selecting  

       schemas  

       Wildcard Characters (expression syntax rule)

               data, selecting  

running

       command-line utilities  

       product catalogs  

runtime callable wrapper (RCW)  

       COM object   2nd  

runtimes

       DataSet class

               structures, loading   2nd