Index_E

E

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




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