|
|
Data Adapter Configuration Wizard, 337-341, 338-340
Data Adapter Preview dialog box, 168, 169
data binding, 179-180
Data category in Toolbox, 155
Data Connections node, 323, 332
Data Definition Language (DDL) statements, 59
with ExecuteNonQuery, 233-236
working with, 89
Data Field setting, 537
Data Form Wizard, 172-179, 172-179
Data Formatting Expression field, 537
Data Key Field property, 536
Data Link Properties dialog box, 91, 91, 200-202, 201-203
Data Manipulation Language (DML) statements, 59, 62
Data namespace, 143
data set classes, 137
Data Source tab, 588, 588
Data Transformation Services folder, 32
data types
fixed length, 51
in SQL Server, 42-44
in SqlDbType, 241-242
for T-SQL variables, 95
DataAdapter directory, 337
DataAdapter objects, 140-141, 293
events for, 399-404
FillSchema method for, 351, 362-367
for populating objects, 316-318
for pushing changes, 373-377
setting up, 429-433
for stored procedures, 390-392
Transaction property in, 413
in VS.NET, 337-341, 338-341
database administrators (DBAs), 8
database connections, 187
Access, 12-14
Oracle, 14-17
SQLConnection objects for, 187-189
connection pooling with, 192-195
connection state with, 195-196
events for, 196-200
opening and closing, 190-192
VS.NET for, 200-204, 200-205
database element in connection strings, 7
Database (DB) lock type, 501
database management systems, 30
Database property, 188
databases, 29-30
connecting to. See database connections
integrity of, 85-86
Northwind. See Northwind database
transactions in. See transactions
Databases folder, 32
DataBind method, 534, 541, 549
DataBindings group, 179
DataBindings property, 548
DataColumn objects, 142-143
properties for, 349-350
restrictions on, 356-362
DataColumnChangeEventArgs class, 404-405
DataColumnCollection class, 142
DataColumnMapping object, 330
DataColumnMappingCollection class, 330
DataGrid controls, 525
Borders properties for, 539-540, 539
Columns properties for, 536-537, 536
for database access, 165-172, 166-171, 532-535, 532, 534
Format properties for, 538, 539
General properties for, 535-536, 535
PageIndexChanged event handler, 540-543, 540, 542
Paging properties for, 537-538, 537
for shopping cart, 563, 563
DataGrid1_PageIndexChanged method, 541
DATALENGTH function, 118-119
DataList controls
for database access, 543-551, 544-548, 550
in Web forms, 525
DataMember property
in DataGrid, 533, 535
in DataList, 545
DataReader objects, 140-141, 259
multiple SQL statements for, 282-288
for null values, 281-282
SqlDataReader objects, 259-262
creating, 262-263
reading rows from, 263-266
for strongly typed column values, 266-281
in VS.NET, 288-291, 289-291
DataRelation objects, 143
constraints in, 427-428
creating and using, 424-429
properties for, 423-424
DataRelationCollection, 143
DataRow objects, 142-143, 148
with CustomersDT and OrdersDT
adding, 434
deleting, 435
updating, 434
with DataTable objects
adding, 377-380, 393-394, 434
deleting, 382-384, 396-397
filtering and sorting, 368-373
finding, 367-368
modifying, 380-382, 395-396
merging, 318-321
navigating, 428-429
properties and methods for, 347-349
DataRowChangeEventArgs class, 405-406
DataRowCollection class, 142, 148
DataRowState enumeration, 379
DataRowsVersion enumeration, 376
DataRowView objects, 461-462
adding, 467
finding, 464-466
indexes for, 463
modifying, 467-472
removing, 468
DataSet objects, 138, 293-294, 298, 299
automatic SQL statements for, 398-399
creating, 302, 433-434
DataAdapter objects for. See DataAdapter objects
DataRow objects for, 347-349
DataTable objects for. See DataTable objects
for forms, 170
for mapping tables and columns, 328-331, 329
merging objects into, 318-321
populating, 433-434
DataAdapter objects for, 316-318
DataTable objects for, 311-316
ranges of rows for, 306-308
SELECT statements for, 302-306
stored procedures for, 309-311
properties and methods for, 299-302
purpose of, 141
SqlDataAdapter objects for
creating, 297-298
properties and methods for, 294-297
strongly typed, 332
creating, 332-336, 333-335
modifying data with, 413-415
working with, 336-337, 337
transactions with, 412-413
update failures in, 408-412
in VS.NET, 342-343, 342-344
working with, 143-144, 146
for XML
schema relationships, 450-452, 451-452
writing and reading objects, 321-328
DataSet property
in DataRelation, 424
in DataTable, 346
in DataViewManager, 475
DataSet tab, 332
DataSetName property, 299
DataSource property
in DataGrid, 170, 533, 535
in DataList, 545
in SqlConnection, 188
DataTable objects, 141-143, 147-148
with DataRow objects
adding, 377-380, 393-394, 434
deleting, 382-384, 396-397
filtering and sorting, 368-373
finding, 367-368
modifying, 380-382, 395-396
navigating, 428-429
with DataSet objects
merging into, 318-321
populating, 311-316
events for, 347, 404-407
identity columns for, 384-386
modifying rows in, 373-384
properties and methods in, 345-347
restrictions on, 350-356
DataTable property, 401
DataTableCollection object, 141
DataType property
in DataColumn, 349
in schema columns, 219
DataView objects, 143
child, 472-475
creating, 456-458
DataRowView. See DataRowView objects
filtering, 460-461
properties and methods in, 453-456
sorting with, 460
VS.NET for, 478-480, 479-480
working with, 458-460
DataView property, 461
DataViewManager objects, 475
creating, 475-476
working with, 476-478
DataViewManager property, 454
DataViewRowState enumeration, 368, 436, 455-456
DataViewSettings property, 475
DATEADD function, 116-117
DATEDIFF function, 116-117
DATENAME function, 116-117
DATEPART function, 116-117
dates
constraints for, 56
T-SQL functions for, 116-117
datetime type in SQL Server, 43, 51, 268-269
DateTime value in SqlDbType, 241
DAY function, 116-117
DB (Database) lock type, 501
db_owner role, 36
DBAs (database administrators), 8
dbo user, 36, 36
DDL (Data Definition Language) statements, 59
with ExecuteNonQuery, 233-236
working with, 89
Deadlock.cs program, 511-514
deadlocks in transactions, 509-514
DEALLOCATE statement, 105
Debug menu, 20
decimal type in SQL Server, 43, 268-269
Decimal value in SqlDbType, 241
DECLARE statement, 96, 104
declaring cursors, 104
Default value
in CommandBehavior, 215
in DataRowsVersion, 376
in Persons table, 52
default values in SQL Server, 38
DefaultValue property, 350-351
DefaultViewManager property, 299
DEGREES function, 111
DELAY keyword, 103
Delete method
in DataRow, 348
in DataRowView, 462
in DataView, 455, 468
Delete option for row display, 178
DELETE permission, 38
DELETE statement, 62, 84-85, 85
with browsers, 592, 592
with ExecuteNonQuery, 230-233
multiple, 286-288
DeleteCommand property
in DataAdapter, 376-377, 392, 398
setting, 382
in SqlDataAdapter, 294, 339
Deleted value
in DataRowState, 379
in DataViewRowState, 368, 456
DeleteProduct stored procedure, 388-389
DeleteProduct2.sql stored procedure, 389-390
DeleteProductTrigger.sql script, 133-134
DeleteRule property, 421, 428, 439-440
deletes
DeleteRule property for, 439-440
SQL Server for, 438, 439
deleting
DataRow objects, 382-384, 396-397, 435
DataRowView objects, 468
functions, 120
rows, 84-85, 85
stored procedures, 126
Depth property, 260
DESC keyword, 73, 74, 457
descriptions for columns, 52
Design Table, 41, 438
DesignTypeVisible property, 208
Detached value, 379
Diagram Pane, 49-50, 49
diagrams
in query builder, 49-50, 49
in SQL Server, 33, 33
Dialog Editor category, 155
DIFFERENCE function, 113, 115
DiffGram value
in XmlReadMode, 326
in XmlWriteMode, 323
directives
preprocessor, 161, 524
for XML, 571-572
Dirty Reads, 492
DiscountPrice function, 120-121
DiscountPrice.sql program, 120-121
display names, 78-79, 78
DisplayDataRow method, 379, 396
DisplayDataRows method, 607
DisplayRow method, 231-232
DisplayRows method, 497, 506
Dispose method, 159
DISTINCT keyword, 74-75, 75, 108
dividing retrieved rows into blocks, 76-77, 77
DML (Data Manipulation Language) statements, 59, 62
Do not automatically recompute statistics option, 56
document structure in XML, 578-579, 579-580
documentation
in SQL Server, 26, 27
in VS.NET, 23-26, 24-26
DocumentElement property, 600
DocumentType property, 600
double type, 268
Downloads link, 18
DRI permission, 38
DROP FUNCTION statement, 120
DROP INDEX statement, 91
DROP PROCEDURE statement, 126
DROP TABLE statement, 90
DropDownList controls, 525, 529
duplicates in retrieved rows, 74-75, 75
|
|