Page and Control classes in data binding, 539
PageIndexChanged Handler of DataGrid Control (code listing), 500
Page_Load and FillDataGrid Methods (code listing), 627, 629
Page_Load Event Handler Code of ViewGuestBook.aspx (code listing), 512–513
paging
in DataGrid control, 499–500
defined, 708
enabling programmatically, 500–502
implementing in ADO.NET, 815–820
Implementing in ADO.NET (code listing), 817–820
Paging property page, 496
ParameterDirection members (stored procedures), 402
parameters
construction of, 184–187
Creating (code listing), 185–186
Using in Stored Procedures (code listing), 402–404
paranoid programming, 662
parent/child relationship, 99
parent table, 99
ParentRelations property (DataTable), 99–101
Parse and Format Event Handlers, Adding (code listing), 292
Parse event, 291–292
paths for different queues, 739–740
Pessimistic Concurrency (code listing), 204
pessimistic concurrency control, 199
pessimistic locking, 790–791
phantom records, 788
pipe-delimited format, 438
piped format file, 446
PipedDataAdapter object, 460–462
PipedDataCommand object, 449–453
PipedDataConnection object, 446–449
PipedDataProvider application, testing, 462–463
PipedDataProvider Test Case (code listing), 463
PipedDataReader object, 453–459
PJ/NF (Fifth Normal Form), 786
platform requirements, ASP.NET, 466
pooling
connection, 145–149
Connection strings and, 777
session, 146
Populating an Order in Database, Web Service Method for (code listing), 530–531
Post Job Button Click Event Handler (code listing), 619
Post Resume Button Click Event Handler (code listing), 622–623
Post Resume Page, Adding Options to (code listing), 621–622
PostJob.aspx page, 618–620
PostResume.aspx page, 620–623
Prepare method (SqlCommand), 160
Preview Data property, 46–47
primary keys
defined, 779
PRIMARY KEY constraints
adding, 352
defined, 345
Private Members (code listing), 196–197
Private Queues, Retrieving (code listing), 732
private queues (user), 726
private system queues, 726
Profiler, SQL Server, 758–762
Property Builder, 493–494, 581–582
PropertyCollection class, 93
PropertyManager and CurrencyManager, 295–296
proxy files (Service1 .vb), 527
Public Queues, Retrieving (code listing), 732–733
public queues (user), 726