|
|
Cache objects, 559
calculated fields, 79
Calendar controls, 526
calling functions, 120
Cancel All option, 178
Cancel method in SqlCommand, 209
Cancel option for row display, 178
CancelEdit method
in DataRow, 348, 404
in DataRowView, 462, 467
Caption property, 349
carets (^) in pattern matching, 65
Cascade Delete Related Fields option, 54, 438
Cascade Update Related Fields option, 54, 438, 440-442
Cascade value, 439
CASE statement, 98-99
CaseSensitive property
in DataSet, 299
in DataTable, 346
casting objects, 267
catch blocks, 7, 9-10
cdata directive, 572
CEILING function, 111-112
Cell Padding property, 540
Cell Spacing property, 540
ChangeDatabase method, 188
Chaos value, 493
CHAR function, 113, 115
char type in SQL Server, 43, 268-269
Char value in SqlDbType, 241
CHARINDEX function, 113, 115
Check existing data on creation option, 54, 56
CheckBox controls, 165, 525
CheckBoxList controls, 525
CheckedListBox controls, 165
child DataView objects, 472-475
child tables, 40, 86, 417
child XML nodes, 579
ChildColumns property, 424
ChildKeyConstraint property, 424
ChildNodes property, 600
ChildRelations property, 346
ChildTable property, 424
Choose a data connection screen, 174, 174
Choose a Query Type screen, 339, 339
Choose tables and columns to display on the form screen, 177, 177
Choose tables or views screen, 175, 175
Choose the dataset you want to use screen, 173, 174
Choose the display style screen, 178, 178
Choose Your Data Connection screen, 338, 338
Class View, 164, 164
Clear method
in DataSet, 301
in DataTable, 346
ClearErrors method, 348
clients for Web state information, 552-556, 554
Clone method
in DataSet, 301
in DataTable, 346
CloneNode method, 601
Close method
in mySqlConnection, 378
in SqlCommand, 9
in SqlConnection, 147, 188
in SqlDataReader, 9
CLOSE statement, 105
CloseConnection value, 215
Closed value, 195
closing
cursors, 105
database connections, 190-192
DataReader objects, 264
SqlCommand objects, 9
SqlDataReader objects, 9
COALESCE function, 118-119
code behind forms, 158-163, 162
code files in Solution Explorer, 163
Codebehind attribute, 521
Collation field, 53
colons (:) for labels, 101
Column List option, 536
Column property, 405
column types, 42-44
ColumnChanged event, 347, 404-405
ColumnChanging event, 347, 404-405
ColumnMapping property, 349
ColumnMappings property, 330
ColumnName property
in DataColumn, 349
in schema columns, 219
ColumnOrdinal property, 219
columns, 29
computations in, 79
for DataGrid controls, 536-537, 536
display names for, 78-79, 78
identity
generating, 351
retrieving values of, 384-386
mapping, 328-331, 329
in Persons table, 52-53
in XML, 568
Columns property
in DataColumn, 142
in DataTable, 346
in ForeignKeyConstraint, 421
in UniqueConstraint, 418
Columns tab, 52-53
ColumnSize property, 219
combining retrieved rows, 76, 76
ComboBox controls, 165
Command objects, 139
parameters for
adding, 241-242
placeholders for, 240
VS.NET for, 255-257, 256-257
Command Prompt tool, 11-12
Command Prompt window, 23, 23
Command property, 402
CommandBehavior enumeration, 215
CommandBuilder
classes for, 140, 398
performance with, 398
commands, executing, 207
Command objects for, 255-257, 256-257
ExecuteNonQuery for, 230-236
ExecuteReader for, 212-225
ExecuteScalar for, 225-226
ExecuteXmlReader for, 227-229
parameters for, 239-245
SqlCommand objects for, 207-211
stored procedures, 245-255
transactions, 236-239
CommandText property
in Command, 210, 230, 234
in mySqlCommand, 242
in SelectCommand, 168, 314
in SqlCommand, 8, 146, 208, 256-257
CommandTimeout property, 208
CommandType enumeration, 210
CommandType property, 208
comments in Transact-SQL, 97
Commit method
in SqlConnection, 237
in SqlTransaction, 486
COMMIT TRANSACTION statement, 87-89, 503, 505
CompareValidator controls, 526
compiling programs
process, 10-12
using VS.NET, 23, 23
Components category in Toolbox, 156
computations in fields, 79
Compute method, 346
concurrency in changes, 375-376, 441-442
conditional logic, 97-98
conditions, multiple, 71-72, 71-72
configuration functions, 107
Configure Data Adapter link, 341
Configure SQL XML Support in IIS option, 586
Connect To Database option, 91
Connect to SQL Server dialog box, 60, 60
connecting to databases, 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
Connecting value, 195
Connection objects, 139, 141
events for, 196-200
state of, 195-196
VS.NET for, 200-204, 200-205
connection pooling, 192-195
Connection property
in SelectCommand, 341
in SqlCommand, 208
in SqlTransaction, 486
connection strings, 7, 12
for Oracle database connections, 15
for SqlConnection objects, 167, 167
Connection tab, 201, 201
ConnectionPooling.cs program, 193-195
ConnectionState enumeration, 195
ConnectionString property
for passwords, 181, 182
in SqlConnection, 188, 200, 202
ConnectionTimeout property, 188
console applications, 17
Constraint class, 143
CONSTRAINT clause, 89
ConstraintCollection class, 143, 352
ConstraintName property
in ForeignKeyConstraint, 421
in UniqueConstraint, 418
constraints. See restrictions
Constraints property, 143, 346, 352
Contents option, 25
Contents tab, 26
context in XML, 580
Continue property, 401
CONTINUE statement, 100
ContinueUpdateOnError property, 294, 409, 411
controls
in Web forms, 524-526
in Windows applications, 164-165
adding, 180, 181
data binding in, 179-180
DataGrid, 165-172, 166-171
labels and button, 156-158, 157-158
CONVERT function, 118
cookies, 552-554, 554
Cookies collection, 553
CookieTest.aspx file, 553-554, 554
Copy method, 301
CopyTo method, 455
COS function, 111
COT function, 111
COUNT function, 77, 107-108, 110
COUNT_BIG function, 108
Count property, 454
Create a relationship between tables screen, 176, 176
Create as CLUSTERED option, 56
Create Columns Automatically At Run Time option, 536
CREATE FUNCTION statement, 120
CREATE INDEX statement, 90
CREATE TABLE statement, 89, 233-234
CREATE TRIGGER statement, 129, 133
Create UNIQUE option, 55
CreateAttribute method, 601
CreateCDataSection method, 601
CreateChildDataView.cs program, 473-475
CreateChildView method, 462, 472-473
CreateCommand method, 146, 188, 211
CreateComment method, 601
CreateDataView method, 475-476
CreateDocumentFragment method, 601
CreateDocumentType method, 601
CreateElement method, 601
CreateEntityReference method, 602
CreateNavigator method, 602
CreateNode method, 602
CreateParameter method, 209
CreateTextNode method, 602
CreateWhitespace method, 602
CreateXmlDeclaration method, 602
Current value, 376
CurrentPageIndex property, 541
CurrentRows value, 368, 456
cursor type, 43
cursors, 103-104
closing, 105
declaring, 104
example, 106-107
functions for, 107
opening, 104
retrieving rows from, 104-105
Customers.asmx.cs program, 615-616
Customers table
contents of, 39-40, 44-45, 44
definition of, 45
indexes for, 42
relationships for, 54, 54
Customers.xml file, 578-579, 579-580, 593-594, 594
customersDA DataAdapter object, 430-431
customersDT, DataRow objects for
adding, 434
deleting, 435
pushing changes in, 435-437
updating, 434
CustomersFromCountry.sql script, 592-593
CustomersStylesheet.xsl file, 582-584, 586, 594-595
CustomersUsingStylesheet.xml file, 584-585, 585, 595-596, 596
CustomersWebService.cs program, 616-617
CustomersWithAttributes.xml script, 581-582
CustomValidator controls, 526
CustOrderHist stored procedure, 309
|
|