Index_C

C

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




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