Beginning ASP.NET 2.0 Databases Beta Preview

Cover......Page 1
Contents......Page 10
Foreword......Page 18
Introduction......Page 22
Introduction to ASP.NET 2.0 and ADO.NET......Page 26
Introduction to the .NET Framework......Page 27
Introduction to ASP.NET......Page 29
Introduction to ASP.NET 2.0......Page 30
Introduction to ADO.NET......Page 32
ASP.NET 2.0 and Data Access......Page 33
Review of Terminology......Page 34
Setup Requirements for This Book......Page 36
Install the .NET Framework Version 2.0......Page 37
Install an Editor to Create Web Pages......Page 38
Install a Database Management System......Page 39
Setup......Page 41
Install the Sample Databases......Page 42
Demonstrations......Page 43
Summary......Page 52
Exercises......Page 53
Connecting to an Access Database......Page 54
in Visual Web Developer......Page 55
The AccessDataSource Control......Page 58
Variations in Select Statements......Page 61
Variations in MDB File Location......Page 65
Handling File Permissions......Page 66
Handling Access Connection Failures......Page 67
Applications......Page 70
Controls......Page 71
Summary......Page 72
Exercises......Page 73
Connecting to SQL Server and SQL Server Express......Page 74
Strings......Page 75
Connection Strings......Page 76
Using the SqlDataSource Control......Page 78
Understanding Security in SQL Server......Page 82
Web.Config File......Page 84
Choosing between DataSet and DataReader......Page 88
Database......Page 89
SqlDataSource......Page 91
Summary......Page 94
Exercises......Page 96
Providers......Page 98
Relationship between Layers of Connectivity Software......Page 99
Supported ADO.NET Providers......Page 100
Using Providers in ASP.NET 2.0......Page 101
Used......Page 103
Connecting to an MDB with a Security Scheme......Page 104
Theory and Syntax......Page 108
Syntax for an ODBC Connection to MySQL......Page 109
Connecting to Other Databases......Page 111
Summary......Page 112
Exercises......Page 113
Displaying Data in Tables......Page 114
Types of Data-Bound Controls......Page 115
Capabilities of the GridView Control......Page 116
Connecting a GridView to Data......Page 117
Drag-and-Drop Controls from Toolbox......Page 118
Selecting Columns in the Edit Columns Dialog......Page 120
Types of Column Fields......Page 121
AutoGenerateColumns Property of the GridView......Page 135
Handling Null Field Values......Page 136
DetailsView Rendering Elements......Page 137
Connecting the DetailsView to Data......Page 138
Summary......Page 140
Customizing the Appearance of Tables......Page 142
BackColor and BackImageUrl......Page 143
Height and Width......Page 144
Borders and Gridlines......Page 145
ToolTip......Page 147
GridView and DetailsView Styles......Page 149
Empty Tables......Page 151
DetailsView-Specific Styles......Page 153
Column Styles and Field Styles......Page 154
Using Cascading Style Sheets......Page 156
Precedence of Styles......Page 160
Themes and Skins......Page 163
Common Mistakes......Page 165
Summary......Page 166
Exercises......Page 167
Paging and Sorting Data......Page 168
Sorting......Page 169
Requirements to Enable Sorting......Page 170
Sort Expressions......Page 172
Paging......Page 176
Enabling Paging......Page 177
Customizing Paging and the Pager......Page 178
Selecting......Page 183
Common Mistakes......Page 184
Exercises......Page 185
Displaying Data in Lists......Page 186
Transition from GridView to Other Formats......Page 187
Concepts Common to List Controls......Page 188
Text versus Value in List Items......Page 189
DataTextField and DataValueField......Page 190
DropDownList Control......Page 192
SelectedIndex and SelectedValue......Page 194
Automatic Postback......Page 196
Common Mistakes......Page 198
Summary......Page 199
Filtering and Master-Child Data......Page 200
QueryString......Page 202
Filtering GridView Records Using a TextBox......Page 204
Using the SQL LIKE Operator......Page 206
ControlParameters......Page 207
Master Control by DropDownList with Hard-Coded Items......Page 209
Master Control by List Boxes with Data-Bound Items......Page 210
Initially Hides the GridView......Page 212
DetailsView on the Same Page......Page 216
DetailsView on Different Pages......Page 220
Cascading DropDownLists......Page 225
Summary......Page 226
Exercises......Page 227
Displaying Data in Templated Controls......Page 230
BookmarkTitle:......Page 0
Data Binding in Templates......Page 234
Content Suitable for Addition to a Template......Page 235
GridView and DetailsView Template Fields......Page 236
DataList Control......Page 239
Repeater Control......Page 244
Navigation in Templated Controls......Page 245
FormView Control......Page 246
Controls......Page 248
Common Mistakes......Page 250
Summary......Page 251
Exercises......Page 252
Updating and Deleting Data......Page 254
Overview of Modifying......Page 255
Command Fields......Page 256
Simple Update......Page 258
DataKeyNames and Updates......Page 261
Update in a DetailsView......Page 263
Parameters Collections......Page 264
Handling NULLs in Updates......Page 265
Delete to Remove Entire Records......Page 267
Common Mistakes......Page 269
Exercises......Page 270
Inserting New Records......Page 272
What Happens under the Hood?......Page 273
Database Considerations When Inserting......Page 274
Basic Insert Using DetailsView......Page 275
Enabling Insert in a Data Source Control......Page 277
GridView on One Page with DetailsView on a Second Page......Page 279
Insert Using Template Fields......Page 280
Using the Bind Syntax in InsertItemTemplate......Page 281
DropDownLists......Page 282
Data Entry with Check Boxes......Page 285
Inserting with FormView......Page 286
Summary......Page 290
Introduction......Page 292
Layers of an N-Tier Application......Page 293
Designer......Page 294
Data-Binding to a DataSet......Page 297
Implementing Master Details Capability......Page 298
Objects......Page 302
Implementing Sorting in a Custom Object......Page 309
Summary......Page 313
XML and Other Hierarchical Data......Page 314
ASP.NET 2.0 Hierarchical Data Controls......Page 315
TreeView Control to Display Hierarchical Data......Page 316
XPath with XmlDataSource......Page 319
Formatting the TreeView......Page 322
XSL Transformation with XML......Page 325
Handling Events in a TreeView Control......Page 328
TreeView......Page 330
XML and GridView......Page 331
Use XML Source with DataList......Page 333
Use XPath to Display Data in a DataList Control......Page 335
XML and DataList with Nesting......Page 337
Summary......Page 340
Caching and Its Benefits......Page 342
When to Use Caching......Page 343
Caching Options in ASP.NET 2.0......Page 344
Displaying Data in ASP.NET......Page 345
Time-Based Caching......Page 348
Caching with Parameters......Page 350
Implementing Filtering Capability......Page 352
SQL Cache Invalidation......Page 355
Caching Partial Pages......Page 359
Summary......Page 362
Handling Events for Data Controls......Page 364
Types of Events......Page 365
Handlers......Page 366
General Error Events......Page 383
Common Mistakes......Page 386
A. A Short and Practical Introduction to SQL Statements......Page 388
B. Exercise Answers......Page 400
Index......Page 416