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