Index_R

R

RAD (rapid application development) tools, 3

RADIANS function, 111

RadioButton controls, 165, 525

RadioButtonList controls, 525, 528-529

RAISERROR statement, 103

RAND function, 111

ranges

in populating objects, 306-308

in retrieving rows, 69

RangeValidator controls, 526

rapid application development (RAD) tools, 3

RAW mode for XML, 227, 568-569, 569

RDBMSs (relational database management systems), 30

READ COMMITTED isolation level, 492-493

Read method

in mySqlDataReader, 212, 283

in SqlDataReader, 262-263

in XmlReader, 228

READ UNCOMMITTED isolation level, 492, 494

ReadCommitted value, 493

reading data, 259

multiple statements for, 282-288

null values, 281-282

SqlDataReader objects for, 259-262

creating, 262-263

reading rows from, 263-266

strongly typed column values, 266-281, 332-337, 333-335, 337

in VS.NET, 288-291, 289-291

in XML, 325-328

ReadNode method, 602

ReadOnly property, 350-351

ReadOuterXml method, 228

ReadSchema value, 326

ReadUncommitted value, 493

ReadXml method, 301, 321, 325-326

ReadXmlSchema method, 301, 321

real type in SQL Server, 43, 270

Real value in SqlDbType, 241

RecordsAffected property

in SqlDataReader, 260

in SqlRowUpdatedEventArgs, 403

references in Solution Explorer, 163

#region preprocessor directive, 161, 524

Register Your XML Web Service Today link, 626

registering Web services, 626-630, 627-631

RegularExpressionValidator controls, 526

RejectChanges method

in DataRow, 349

in DataSet, 301

in DataTable, 347, 468

RelatedColumns property, 421

RelatedTable property, 421

relational database management systems (RDBMSs), 30

relational databases, 29, 40

RelationName property, 424

Relations property, 143, 300

relationships, 39-40, 39, 417-418

creating, 54, 54

DataRelation objects for, 143

constraints in, 427-428

creating and using, 424-429

properties for, 423-424

ForeignKeyConstraint objects for, 420-423

modifying rows, 429-437

nested XML for, 443-447

in Northwind database, 40-41, 41

primary key updates for, 437-443, 439

UniqueConstraint objects for, 418-420

VS.NET for, 448-452, 448-452

Relationships tab, 438, 439

RemoveAll method, 603

RemoveChild method, 603

RemoveCustomersRow method, 337, 413

RemoveDataRow method, 383, 396-397

removing

DataRow objects, 382-384, 396-397, 435

DataRowView objects, 468

functions, 120

rows, 84-85, 85

stored procedures, 126

REPEATABLE READ isolation level, 492

repeatable read transactions, 506-509

RepeatableRead value, 493

Repeater controls, 525

ReplaceChild method, 603

REPLICATE function, 114

Replication folder, 32

Request object, 553

RequiredFieldValidator controls, 526

Reset method, 301

ResetCommandTimeout method, 209

Resource column for transaction locks, 503

Response object, 552

restrictions

on DataColumn objects, 356-362

on DataRelation objects, 427-428

on DataTable objects, 352-353

FillSchema for, 362-367

in Persons table, 56-57, 57

in retrieving rows, 64-65, 64, 77, 78

results sets

stored procedures not returning, 245-252

stored procedures returning, 252-255

Retrieve Customers link, 624

Retrieve Data From Table option, 92

RetrieveCustomers method, 616, 621-622, 623

retrieving data, 63-64, 63

calculated fields in, 79

combining in, 76, 76

from cursors, 104-105

display names and aliases in, 78-79, 78

dividing into blocks, 76-77, 77

duplicates in, 74-75, 75

group restrictions in, 77, 78

identity column values, 384-386

lists in, 68-69, 69

multiple conditions for, 71-72, 71-72

from multiple tables, 79-81, 80

NOT operator in, 70

with null values, 70, 70

pattern matching in, 65-68, 66-68

ranges in, 69

restrictions in, 64-65, 64

sorting in, 72-73, 73-74

TOP N, 74, 75

from views, 81-82

as XML, 227-229

RETURN statement, 102

REVERSE function, 114

RID (Row) lock type, 501

RIGHT function, 114-115

RIGHT OUTER JOINs, 80

roles, 36-38, 37

Rollback method, 486, 488

ROLLBACK TRANSACTION statement, 87-89, 503

root nodes in XML, 578-580

ROUND function, 111-112

Row (RID) lock type, 501

Row property

in DataColumnChangeEventArgs, 405

in DataRowChangeEventArgs, 406

in DataRowView, 461

in SqlRowUpdatingEventArgs, 402

RowChanged event, 347, 404-407

RowChangedEventHandler method, 406

RowChanging event, 347, 404-407

RowChangingEventHandler method, 406

@@ROWCOUNT function, 118

RowDeleted event, 347, 404, 407

RowDeletedEventHandler method, 407

RowDeleting event, 347, 404, 407

RowDeletingEventHandler method, 407

RowFilter property, 454, 460, 476

rows, 29

adding, 82, 83

modifying, 83-84, 84, 373-384

ranges of, 69, 306-308

removing, 84-85, 85

retrieving. See retrieving data

sorting, 72-73, 73-74

SqlDataReader objects for, 263-266

storing locally, 144-151

in XML, 568

Rows property

in DataRow, 142

in DataTable, 346

in myDataTable, 304

RowState property

in DataRow, 348

in myNewDataRow, 379

RowStateFilter property, 454

RowUpdated event

in DataAdapter, 403-404

in SqlDataAdapter, 297

RowUpdatedEventHandler method, 403-404

RowUpdating event

in DataAdapter, 401-403

in SqlDataAdapter, 297

RowUpdatingEventHandler method, 403

RowVersion property, 462

RTRIM function, 114-115

Rule enumeration, 439

rules in SQL Server, 38

Run method, 162-163

RunAddCustomers.sql script, 598-599, 599

running

forms, 157, 158, 182-183, 182

programs, 10-12, 23, 23

statements, 8, 60-62, 61

stored procedures, 127




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