Index_I

I

icon files, 163

ID directive, 572

ID property

for forms, 522

for Label controls, 528

IDENTITY clause, 128

identity columns

generating, 351

retrieving values of, 384-386

Identity field, 52

@@IDENTITY function, 118, 125

Identity Increment field, 52

Identity Seed field, 52

IDREF directive, 572

IDREFS directive, 572

IF keyword, 97-98

Ignore duplicate key option, 55

Ignore value, 319

IgnoreSchema value

in XmlReadMode, 326

in XmlWriteMode, 323

IIS (Internet Information Server)

installing, 518

XML support for, 586-590, 586-590

IIS Virtual Directory Management for SQL Server console, 586-587, 586, 590

Image controls, 525

image type in SQL Server, 43, 269

Image value in SqlDbType, 241

ImageButton controls, 525

images, functions for, 107

Implementation property, 600

ImportNode method, 602

IN operator, 68-69, 69

Index column for transaction locks, 503

Index Filegroup field, 55

Index Results window, 24, 24

Index tab, 24

Index window, 24

indexes

creating, 55-56, 55, 90-91

for DataRowView objects, 463

for documentation, 24, 24

dropping, 91

in Northwind database, 41-42, 42

InferSchema value, 326

infinity sign for relationships, 40

InfoMessage.cs program, 198-200

InfoMessage event, 189, 198-200

InitializeComponent method, 161, 524

inline table-valued functions, 119, 121-122

InnerText property, 600

InnerXml property, 600

INSERT permission, 38

INSERT statement, 62, 82, 83

with browsers, 592, 592

with ExecuteNonQuery, 230-233

integrity with, 85-86

multiple, 286-288

Insert Table dialog box, 546, 547

InsertAfter method, 602

InsertBefore method, 602

InsertCommand property

in DataAdapter, 373-374, 391, 398

setting, 391

in SqlDataAdapter, 294, 339

InsertProductTrigger.sql script, 129-131

instances, Query Analyzer for, 60, 60

int type in SQL Server, 43, 51, 268-269

Int value in SqlDbType, 241

Int16 type, 269

Int32 type, 268

Int64 type, 268

integrity of databases, 85-86

Intent exclusive (IX) locking mode, 501

Intent shared (IS) locking mode, 501

internal access modifier, 161

Internet Information Server (IIS)

installing, 518

XML support for, 586-590, 586-590

IS (Intent shared) locking mode, 501

IS NULL operator

with joins, 81

working with, 70, 70

IsAliased property, 219

IsAutoIncrement property, 219

IsClosed property, 260

IsContactNameNull method, 337, 414

ISDATE function, 118-119

IsDBNull method

in DataReader, 281

in SqlDataReader, 262

IsEdit property, 461

IsExpression property, 219

IsHidden property, 220

IsIdentity property, 219

IsKey property, 219

IsLong property, 220

IsNew property, 461

ISNULL function, 118-119

IsNull method, 349

IsNullable property, 243

ISNUMERIC function, 118-119

isolation levels for transactions, 492-500, 495

IsolationLevel enumeration, 493

IsolationLevel property, 486

IsPostBack property, 534

IsPrimaryKey property, 418

IsReadOnly property, 600

IsReadOnly value, 220

IsRowGuid field, 53

IsRowVersion property, 219

IsUnique property, 219

Italic property, 538

Item Templates editor, 546, 546

ItemArray property, 348

Items property, 528

IX (Intent exclusive) locking mode, 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