|
|
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
|
|