Index_D

D

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




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