Index_R

R

Raising ListBox Events (code listing), 303

Rapid Application Development (RAD) Web development, 488

RDO (Remote Data Objects), overview of, 5

Read method (DataReader), 162

read-only data binding, 537

Reader objects. See also DataReader; PipedDataReader object, 441–443

Reading

All Bindings of a Form (code listing), 290–291

All Constraints of a Collection (code listing), 352

All Controls Participating in Data Binding (code listing), 294

Data from Northwind Using ODBC Data Provider (code listing), 379–380

Data from SQL Server (code listing), 371–373

Database Schema Programmatically (code listing), 825

DataSet Columns and Their Data Types (code listing), 814–815

Only Modified Rows of DataSet (code listing), 843

TextBox Control's Binding Properties (code listing), 291–292

and Writing to and from Windows Registry (code listing), 831

an XML File (code listing), 239

reading XML, 238–246

closing document, 245–246

fundamentals, 238–239

GetAttributes of a node, 243–244

getting node information, 239–242

moving to content node, 242–243

searching for a node, 244

ReadXml method, 122, 127, 262–263

ReadXmlSchema method, 127, 264

Rearranging a DataGrid Column's Sequence (code listing), 588

Receive method (MessageQueue), 741

Receiving and Sending Transactional Messages (code listing), 749–750

Receiving Messages from a Queue (code listing), 743–744

Record Button Click Event Handlers, Moving (code listing), 337–338

record navigation system

building, 296–300

building DataGrid, 335–338

Record Navigation System Variables (code listing), 298

RecordSets

Creating Custom (code listing), 337

and cursors, 786–787

vs. DataSets, 12

defined, 121

Filling DataAdapter from, 175–176

reference materials

ADO Examples and Best Practices for Programmers, 760

ADO.NET, 760

Building Distributed Applications with Microsoft .NET, 776

Concurrency Control and Recovery in Database Systems, 789

Hitchhiker's Guide to Visual Basic and SQL Server, 760

relational databases info, 792

SQL online references, 810

Transaction Processing: Concepts and Techniques, 791

references, adding to Oracle .NET data provider, 415

RefreshSchema method, 184

Register.aspx Code (code listing), 616

Register.aspx page (Online Job Board application), 615–616

Registry, Windows, 828–831

RejectChanges method (DataRow), 95–96, 127, 191–192, 231

relational databases, 779–792

fundamentals, 779–780

locking, 788–791

isolation levels, 788–789

locking modes, 790–791

normalization, 780–786

Boyce-Codd Normal Form (BCNF), 785

Fifth Normal Form (5 NF or PJ/NF), 786

First Normal Form (1 NF), 780–782

Fourth Normal Form (4 NF), 785

Second Normal Form (2 NF), 782–784

Third Normal Form (3 NF), 784–785

online resources, 792

recordsets and cursors, 786–787

Relations property, 124

ReleaseObjectPool, Calling (code listing), 149

Removing

All Items of a Node (code listing), 257

Column From a Collection (code listing), 117

RemoveAll for books.xml, Calling (code listing), 258

RemoveHandler statement, 209

a Row and Calling the Update Method of a DataAdapter (code listing), 177

Repeater control (Web Forms)

supporting templates, 548

using, 552–555

ReplaceChild, Calling (code listing), 258

report queues (system), 726

ResetCommandTimeout method (SqlCommand), 160

ReshuffleColumns Method (code listing), 329–330

reshuffling DataGrid columns, 326–331

response queues (user), 726

Resumes.aspx HTML View (code listing), 630–632

Resumes.aspx pages (Online Job Board Application), 623–632

retrieving data, 775–777

Rollback, Commit, and Savepoints, 204–206

root nodes, getting, 256

rows

Adding to DataTable Using DataRow (code listing), 96–98

and DataTable operations

adding, 106, 109–110

deleting, 106, 110–111

editing, 119

searching, 106, 112–113

sorting, 106, 113–114

of DataView, Adding, Updating, and Deleting (code listing), 130

deleting, 176

RowChanged event, 222, 224

RowChanging and RowChanged Event Handlers, Writing (code listing), 224

RowDeleted event, 222, 225–226

RowDeleting and RowDeleted Event Handlers, Writing (code listing), 225–226

RowFilter property (DataView), 131

RowState property, 99

RowUpdated Event Handler (code listing), 218

RowUpdating and RowUpdated events, 216, 218–219

RowUpdating Event Handler (code listing), 218–219