|
|
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
|
|