Index_P

P

PacketSize property, 188

Pad Index option, 56

Page lock type, 501

Page Size property, 538

PageIndexChanged handler, 540-543, 540, 542

Paging properties for DataGrid controls, 537-538, 537

Panel controls, 165, 525

Parameter classes, 140

ParameterCollection classes, 140

parameters, 239

adding, 241-242

executing commands with, 244-245

placeholders for, 240

setting values of, 243

Parameters property

in mySqlCommand, 242

in SqlCommand, 208

parent-child relationships, 40, 417

parent rows, primary keys in, 437-443, 439

parent tables, 40

ParentColumns property, 424

ParentKeyConstraint property, 424

ParentNode property, 601

ParentTable property, 424

Parse method, 553

passwords

ConnectionString property for, 181, 182

in integrated security, 190

for Oracle database connections, 15

saving, 202

for SqlConnection objects, 167

in Windows applications, 181, 182

Path environment variable, 11

PATINDEX function, 113

pattern matching, 65-68, 66-68

pauses

SQL Server, 31

in T-SQL, 102

percent signs (%)

in filters, 461

in pattern matching, 65

in URLs, 591

PerformReadCommittedTransaction method, 497

PerformSerializableTransaction method, 497

periods (.) in XPath expressions, 581

permissions

in Persons table, 53, 53

for SQL Server roles, 37-38, 37

persist security info setting, 202

Persons table

columns in, 52-53

constraints for, 56-57, 57

creating, 51-52

indexes in, 55-56, 55

permissions in, 53, 53

primary keys for, 53

relationships for, 54, 54

phantom rows, 492

PI function, 111-112

PictureBox controls, 165

PlaceHolder controls, 525

placeholders for parameters, 240

pooling connections, 192-195

PopulateDataSetUsingProcedure.cs program, 310-311

PopulateDataSetUsingRange.cs program, 307-308

PopulateDataSetUsingSelect.cs program, 305-306

populating DataSet objects, 433-434

DataAdapter objects for, 316-318

DataTable objects for, 311-316

ranges of rows for, 306-308

SELECT statements for, 302-306

stored procedures for, 309-311

Position property, 538

POWER function, 111-112

Precision field, 52

Prefix property

in DataSet, 300

in XmlDocument, 601

Prepare method, 209

PrependChild method, 602

preprocessor directives, 161, 524

PreserveWhitespace property, 601

Preview Data link, 341

Previous Page Button Text property, 538

PreviousSibling property, 601

primary keys, 42, 89-90

integrity of, 85-86

in Northwind database, 40

in Order Details table, 47, 355

in Orders table, 46, 354

in Persons table, 53

in Products table, 48, 353

updating, 437-443, 439

PrimaryKey property

in DataTable, 346, 380

in Order Details table, 355

in Orders table, 354

in Products table, 353

PRINT statement, 98

private access modifier, 161

ProductAudit.sql script, 128

ProductCursor.sql script, 106-107

Products table

contents of, 29-30, 48, 48

primary key for, 353

ProductsToBeReordered function, 121-122

ProductsToBeReordered.sql script, 121-122

ProductsToBeReordered2 function, 122-124

ProductsToBeReordered2.sql script, 122-124

programs, compiling and running, 10-12, 23, 23

Project menu, 20

projects

creating, 19, 19

names for, 154

properties, viewing, 92, 94

Properties dialog box

for DataGrids, 535, 535

for Windows applications, 156

Property Builder link, 535

Proposed value, 376

ProposedValue property, 405

protected access modifier, 161

protected internal access modifier, 161

Provider tab, 201, 201

ProviderType property, 219

public access modifier, 161

public role, 36, 37

PushChangesToDatabase method, 437

PushChangesUsingProcedures.cs program, 397

pwd element, 7




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