Index_F

F

failures in updates, 408-412

FETCH statement, 104

Fetching value, 195

FieldCount property, 260

File menu, 20

Fill factor field, 55-56

Fill method

in DataAdapter, 353

in DataSet, 303-307

in SqlDataAdapter, 147, 171, 296

FillError event

in DataAdapter, 400-401

in SqlDataAdapter, 297

FillErrorEventArgs class, 400-401

FillErrorEventHandler method, 400

FillSchema.cs program, 363-367

FillSchema method

in DataAdapter, 351, 362-367

in SqlDataAdapter, 296

filtering

DataRow objects, 368-373

DataView objects, 460-461

Find A Service page, 626

Find method, 455

FindByCustomer method, 337

FindByCustomerID method, 414

FindFilterAndSortDataRows.cs program, 370-373

finding

DataRow objects, 367-368

DataRowView object indexes, 463

DataRowView objects, 464-466

documentation, 25

FindingDataRowViews.cs program, 464-466

FindRows method

in DataRowView, 464-466

in DataView, 455

firehose cursors, 259

firing triggers, 127-128

FirstChild property, 600

FirstExample.cs program, 4-7

compiling and running, 10-12

explanation of, 7-10

fixed length data types, 51

float type in SQL Server, 43, 268-270

Float value in SqlDbType, 241

FLOOR function, 111-112

Font Name property, 538

Font Size property, 538

Footer Text field, 537

FOR XML clause, 227, 567-568

for AUTO mode, 228, 570

for BINARY BASE64 option, 576-578, 577

for ELEMENTS option, 575

for EXPLICIT mode, 570-574

for RAW mode, 568-569, 569

for XMLDATA option, 574-575

foreach loops, 148, 218

Forecolor property, 538

foreign keys

integrity of, 85

in Northwind database, 40-41, 41

Order Details table, 47, 356

Orders table, 46

Products table, 48

ForeignKeyConstraint objects, 143

creating, 422-423

properties of, 420-421

for updates and elites, 439-440

Form1.cs program, 158-161, 337

Form1_Load method, 289-290, 336, 343, 414

Format link for DataGrid controls, 538, 539

formatting, XML stylesheets for, 594-596, 596

forms

for Web

building, 527-532, 527-528

controls for, 524-526

for Windows applications

creating, 172-179, 172-179

running, 182-183, 182

Forms namespace, 161

Formula field, 53

ForXmlAuto.sql script, 570

ForXmlAutoBinaryBase64.sql script, 578

ForXmlAutoElements.sql script, 576

ForXmlAutoXmlData.sql script, 575

ForXmlExplicit.sql script, 573-574

ForXmlRaw.sql script, 568-569, 569

Fragment value, 326

FROM clause, 63-64, 63

FULL OUTER JOINs, 80

full-text catalogs, 38

functions in T-SQL, 107

aggregate, 107-110, 109-110

date and time, 116-117

mathematical, 111-113

string, 113-116

system, 117-119

user-defined

inline table-valued, 121-122

multistatement table-valued, 122-124, 123-124

scalar, 119-121, 121

in SQL Server, 38

in T-SQL, 119




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