Index_P

P

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