|
|
Edit menu, 20
Edit Relation dialog box, 451-452, 451
editing DataList templates, 545
element directive, 571
elements
in XML, 579
in XPath expressions, 581
ELEMENTS option, 227, 576
ELSE keyword, 97-98
END keyword, 97
EndEdit method
in DataRow, 348
in DataRowView, 467
EndInit method
in DataSet, 301
in DataView, 455
#endregion preprocessor directive, 161, 524
Enforce constraint for INSERTs and UPDATEs option, 57
Enforce constraint for replication option, 57
Enforce relationship for INSERTs and UPDATEs option, 54
Enforce relationship for replication option, 54
EnforceConstraints property, 299, 351
entering statements, 60-62, 61
Enterprise Manager, 31-38, 31, 33-37
for functions, 120, 121
for indexes, 42
for queries, 48-50, 49-50
for relationships, 41
for stored procedures, 126
for tables, 51-52, 51-52
for triggers, 130
environment variables, 11
EOF property, 228
equal operator (=) in WHERE clauses, 64-65
@@ERROR function, 88-89, 118
error messages, raising, 103
Error value, 319
errors in updates
checking for, 411
fixing, 411-412
Errors property
in FillErrorEventArgs, 401
in SqlRowUpdatingEventArgs, 402
event handlers, 196
EventArgs class, 400
events
for Connection, 196-200
for DataAdapter, 399-404
for DataTable, 347, 404-407
in VS.NET, 203-204, 203-205
exception handling, 9-10
Exclusive (X) locking mode, 501
EXEC permission, 38
EXECUTE statement, 127
ExecuteAddProduct.cs program, 249-250
ExecuteAddProduct3.cs program, 254-255
ExecuteDDL.cs program, 234-236
ExecuteInsertUpdateDelete.cs program, 231-233
ExecuteMultipleSelects.cs program, 284-285
ExecuteMultipleSQL.cs program, 286-288
ExecuteNonQuery method
DDL statements with, 233-236
modify commands with, 230-233
in SqlCommand, 209
ExecuteReader method, 8, 211
controlling command behavior with, 214-223
with SELECT statement, 212-214
in SqlCommand, 209
in SqlDataReader, 262-263
for TableDirect, 223-225
ExecuteScalar.cs program, 226
ExecuteScalar method, 211
with SELECT statement, 225-226
in SqlCommand, 209
ExecuteSelect.cs program, 213-214
ExecuteTableDirect.cs program, 224-225
ExecuteTransaction.cs program, 237-239
ExecuteXmlReader.cs program, 228-229
ExecuteXmlReader method, 209, 211, 227-229
executing commands, 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
executing multiple SQL statements, 282-288
Executing value, 195
EXP function, 111
EXPLICIT mode for XML, 227, 570-574
expressions in XPath, 580-582
ExtendedProperties property
in DataRelation, 424
in DataSet, 300
in ForeignKeyConstraint, 421
in UniqueConstraint, 418
Extensible Markup Language Path (XPath)
expressions in, 580-582
and XML document structure, 578-579, 579-580
Extensible Stylesheet Language Transformation (XSLT), 582-586, 585
Extent lock type, 501
|
|