Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Karelia Stetz-Waters: IMG The Hot Sex Tip Cosmo Won't Tell You



    Cosmopolitan Magazine recently released an article titled "28 Mind-Blowing Lesbian Sex Positions." Where was this vital information when I was a... Continue »

    spacer

Beginning ASP.Net 2.0 and Databases

by

Beginning ASP.Net 2.0 and Databases Cover

 

Synopses & Reviews

Publisher Comments:

ASP.NET is Microsoft's popular technology for creating dynamic web sites that pull unique information for each visitor rather than showing everyone the same static HTML pages. The introduction of the exciting 2.0 version allows for a far easier relationship between data and ASP.NET than ever before. In this book, bestselling author John Kauffman and Microsoft ASP.NET data insider Bradley Millington guide you through the most important uses of ASP.NET—working with databases in your ASP.NET web sites.

As you progress from simple to more complex topics, you'll be introduced to the many additional ASP.NET and data connectivity tools that Microsoft's Web Platform and Tools team has released. Kauffman and Millington take you beyond the basics to discuss the permutations, pitfalls, and best practices that occur in real business scenarios.

What you will learn from this book

  • Fundamentals of connecting web pages to databases
  • The connections to Access, SQL Server, Oracle®, XML, and other data sources
  • Various tricks and traps for displaying data in grids, lists, and trees
  • How to allow users to change, add, and delete data
  • Techniques for creating data objects and events
  • Ways to handle data errors

Who this book is for

This book is for anyone who needs a web front-end or is looking to add data to a site. A comfortable level of understanding with ASP.NET version 1.x or ASP version 3.0 is recommended. Readers should also have some familiarity with databases.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Synopsis:

  • Combining both VB.Net and C# coverage in one book, this guide focuses on using ASP.NET 2.0 for solving business dynamic Web site challenges in a logical progression, from connecting to a database to displaying information to changing data
  • Covers the fundamentals of connecting Web pages to databases, techniques for creating data objects and events, and ways to handle data errors
  • Features tricks and traps for displaying data in grids, lists, and trees
  • Goes beyond the usual basic techniques to discuss the best practices and pitfalls that can occur in real-world scenarios with SQL Server, Oracle, MySQL, Access, and the new SQL Server Express Edition

Synopsis:

The  book focuses  on solving business problems in a logical progression from connecting to displaying to changing the data. Additional chapters cover enhancements to the presentation and alternate types of data. The book follows Kauffman’ s practice of going beyond the basic techniques to discuss the permutations, pitfalls and best practices that occur in real business scenarios.

Some of the topics covered include: Fundamentals of connecting Web pages to databases Complete scenarios with SQL Server (including the new SQL Server Express Edition), Oracle® , MySQL® , Access, and XML Tricks and traps to displaying data in grids, lists, and trees How to allow users to change, add, and delete data Techniques for creating data objects and events and handling data errors

About the Author

John Kaufman (Ogdensburg NY) is a trainer and writer working in Asia and North America specializing in connecting databases to the web. While teaching he keeps a list of student questions and mistakes and uses that information as the basis for future material in books. John authored best-seller Beginning ASP Databases and coauthored several other best-sellers including Beginning Active Server Pages 3. Bradley Millington (Redmond, WA) is a Microsoft Program Manager for the Web Platform and Tools Team with primary responsibility for the database controls in ASP.NET. He is a well-known frequent speaker at Microsoft technical conferences including TechEd and PDC.

Table of Contents

Introduction.

Chapter 1: Introduction to ASP.NET 2.0 and ADO.NET.

Overview of the .NET Technologies.

Introduction to the .NET Framework.

Introduction to ASP.NET.

Introduction to ASP.NET 2.0.

Introduction to ADO.NET.

Review of ASP.NET 1.x and ADO.NET for Data Access.

ASP.NET 2.0 and Data Access.

Review of Terminology.

Requirements for Using ASP.NET 2.0.

A Web Server.

The .NET Framework Version 2.0.

An Editor to Create Web Pages.

A Database Management System.

Setup for This Book.

Install Visual Web Developer Express, SSE, and the ASP.NET Development Server.

Download This Book’s Files.

Create the Practice Web Site.

Install the Sample Databases.

Demonstrations.

Common Mistakes.

Summary.

Exercises.

Chapter 2: Connecting to an Access Database.

Introduction to Microsoft Access and the JET Database Engine.

Pros and Cons of Using Access in Web Applications.

Connecting to a Microsoft Access Database in Visual Web Developer.

Using an AccessDataSource Control.

Variations in Select Statements.

Variations in MDB File Location.

Managing MDB File Permissions.

Handling Access Connection Failures Gracefully.

Common Mistakes.

Summary.

Exercises.

Chapter 3: Connecting to SQL Server and SQL Server Express.

Introduction to SQL Server and Connection Strings.

Preparing to Use a SQL Server Database.

Specifying Connection Strings.

Using the SqlDataSource Control.

Understanding Security in SQL Server.

Authentication Options in SQL Server.

Authentication with SQL Server Express.

Database Rights with SQL Server Express.

Authentication Requirements for the SqlDataSource Control.

Storing the Connection String in the web.config File.

Manually Adding a Connection String to the web.config File.

Encrypting Connection Strings.

Choosing between DataSet and DataReader.

Discovering the Schema of an Unfamiliar Database.

Handling Failures with SqlDataSource.

Common Mistakes.

Summary.

Exercises.

Chapter 4: Connecting to Other Relational Databases.

Introduction to Connections with Providers.

Understanding the Relationship between Layers of Connectivity Software.

Understanding Supported ADO.NET Providers.

Using ADO.NET Providers in ASP.NET 2.0.

Connecting to an Access MDB File When a Password Is Used.

Connecting to Oracle Database.

Connecting to MySQL.

Syntax for an ODBC Connection to MySQL.

Connecting to Excel.

Connecting to Other Databases.

Exploring Common Mistakes.

Summary.

Exercises.

Chapter 5: Displaying Data in Tables.

Displaying Data in ASP.NET 2.0.

Review of Data-Bound and Data Source Controls.

Types of Data-Bound Controls.

Introduction to the GridView Control.

Capabilities of the GridView Control.

GridView Rendering Elements.

Connecting a GridView to Data.

Drag and Drop Fields from Data Explorer.

Drag and Drop Controls from the Toolbox.

Customizing the GridView’s Columns.

Selecting Columns in the Edit Columns Dialog Box.

Types of Column Fields.

Using the AutoGenerateColumns Property of the GridView.

Handling Null Field Values.

The DetailsView Control.

DetailsView Rendering Elements.

Connecting the DetailsView to Data.

Common Mistakes.

Summary.

Exercises.

Chapter 6: Customizing the Appearance of Tables.

Customizing the Appearance of an Entire Table.

Setting the BackColor and a BackImageUrl.

Font and ForeColor.

Height and Width.

CellSpacing and CellPadding.

Borders and GridLines.

HorizontalAlign.

ShowHeader and ShowFooter.

ToolTip.

Customizing Styles within a Table.

GridView and DetailsView Styles.

Empty Tables.

Styles Specific to the DetailsView Control.

Column Styles and Field Styles.

Using Cascading Style Sheets.

Understanding the Precedence of Styles.

Implementing Themes and Skins.

Using Auto Format in VWD.

Solving Common Mistakes.

Summary.

Exercises.

Chapter 7: Sorting and Paging Data.

Introduction.

Sorting.

Requirements to Enable Sorting.

Understanding How ASP.NET 2.0 Manages Sorting.

Sort Expressions.

Paging.

Enabling Paging.

Customizing Paging and Pager Navigation Tools.

Paging Theory and Alternatives.

The Relationship among Sorting, Paging, and Selecting.

Common Mistakes.

Summary.

Exercises.

Chapter 8: Displaying Data in Selection Lists.

Introduction to Selection Lists.

Transition from GridView to Other Formats.

Types of Selection List Controls.

Concepts Common to All Selection List Controls.

Data-Binding List Controls.

DropDownList Control.

Selection in a List.

SelectedIndex and SelectedValue.

Automatic Postback.

Common Mistakes.

Summary.

Exercises.

Chapter 9: Filtering and MasterDetails Scenarios.

Introducing Master–Details Scenarios.

Filtering GridView Records Using a Query String.

Filtering GridView Records Using a TextBox.

Using the SQL LIKE Operator.

The Theory of Selection and ControlParameters.

Scoping GridView Records Using a Selection List Control.

Master Control by DropDownList with Hard-Coded Items.

Master Control by ListBoxes with Data-Bound Items.

Display Options for GridView in Master-Details Scenario.

Master Control by List Boxes with a Default Setting That Shows all Records in the GridView.

Displaying Details Using a GridView and DetailsView on the Same Page.

Displaying Details Using a GridView and DetailsView on Different Pages.

Cascading DropDownLists.

Common Mistakes.

Summary.

Exercises.

Chapter 10: Displaying Data in Templated Controls and Data Binding.

Introduction to Templates.

Template Location and Scope.

Template Contents.

Record Rendering: Repeat and Single.

Subsections of Templates.

Data Binding in Templates.

General Guidelines for Using Templated Controls.

GridView Template Columns.

DataList Control.

DataList Control Internal Layout.

Repeater Control.

Templates in the DetailsView Control.

FormView Control.

Comparison of the Templated Controls.

A Few More Advanced Ideas on Data Binding.

Common Mistakes.

Summary.

Exercises.

Chapter 11: Updating and Deleting Data.

Overview of Modifying.

Command Fields.

Simple Update.

DataKeyNames and Updates.

Update in a DetailsView.

Parameters Collections.

Handle Nulls in Updates.

Delete to Remove Entire Records.

Common Mistakes.

Summary.

Exercises.

Chapter 12: Inserting New Records.

Theory of Creating New Records.

Support for Insert.

What Happens under the Hood?

Database Considerations When Performing an Insert.

Enabling Insert in a Data Source Control.

Basic Insert Using DetailsView.

DetailsView Insert Starting from GridView.

GridView and DetailsView for Insert on Same Page.

GridView on One Page with DetailsView on a Different Page.

Insert Using TemplateFields.

Using the Bind Syntax in InsertItemTemplate.

Data Entry with RadioButtonLists and DropDownLists.

Data Entry with CheckBoxes.

Inserting with FormView.

Trade-Offs between DetailsView and FormView.

Common Mistakes.

Summary.

Exercises.

Chapter 13: Validation.

Overview of Validation Controls.

What Are Validation Controls?

What Scenarios Do Validations Support?

Common Concepts of Validation Controls.

Common Properties.

Implementation of Validation Controls.

How Validation Works behind the Scenes.

Multiple Validations.

Types of Validation controls.

Validation in Data Scenarios.

Validation Summary.

Validation Groups.

Validation in Code.

Common Mistakes.

Summary.

Exercises.

Chapter 14: Business Objects As a Source of Data.

Introduction to the ObjectDataSource Control.

Layers of an N-Tier Application.

Advantages of N-Tier Architectures.

Simple Objects with Hard-Coded Data.

Binds to a Hard-Coded Array.

Objects That Use Generics.

Objects That Bind to a DataSource.

Using VWD to Build Objects with Data.

Object That Returns a DataSet List.

Objects That Modify Data.

Master-Details with a Data Object.

Sorts in a Data Object.

Common Mistakes.

Summary.

Exercises.

Chapter 15: XML and Other Hierarchical Data.

What Is Hierarchical Data?

Types of Hierarchical Data.

ASP.NET 2.0 Hierarchical Data Controls.

XmlDataSource and the TreeView Control.

DataBinding and Formatting the TreeView.

XPath with XmlDataSource.

Handling Events in a TreeView Control.

Hierarchical Data with Other Controls.

XmlDataSource and the DropDownList.

XmlDataSource and GridView.

XmlDataSource and DataList.

XmlDataSource and DataList with Nesting.

SiteMapDataSource, SiteMapPath, and the Menu Control.

Common Mistakes.

Summary.

Exercises.

Chapter 16: Caching Data.

Caching and Its Benefits.

When to Use Caching.

Understanding State.

Understanding State Staleness.

Caching Options in ASP.NET 2.0.

A Note on Data for the Exercises.

Time-Based Cache Expiration.

Caching with Parameters.

Implementing Filtering Capability.

SQL Server Cache Invalidation.

Caching Partial Pages.

Common Mistakes.

Summary.

Exercises.

Chapter 17: Handling Events for Data Controls.

Introduction to Event Handling.

Execution Control When an Event Is Triggered.

Types of Events.

General Techniques for Writing Event Handlers.

Transfer of Values When an Event Is Triggered.

Location of Event Handlers.

Command and Custom Button Events.

Using Events Raised by Command Buttons or Command FIelds.

Using Events Raised by Buttons with Custom Behavior.

List Selection Events and Page Events.

Data Control Binding Events.

General Error Events.

Common Mistakes.

Summary.

Exercises.

Chapter 18: Performance Checklist.

Convert Pages from Earlier Versions to 2.0.

Switch from Access to SQL Server.

Use the DataReader Instead of the DataSet.

Use OLEDB Instead of ODBC.

Set List Items Statically.

Cache Data.

Cache Whole or Partial Pages.

Use SQL Server Cache Invalidation.

Typecast in Code.

Specifically List Columns Instead of using AutoGenerate Columns.

Turn Off ViewState When Possible.

Set Properties Declaratively.

Use Best Practices in Code.

Precompile Your Pages.

Chapter 19: Case Study: FAQ System.

Project Description.

Database Design.

Development of Files.

Summary.

Appendix A: A Short and Practical Introduction to SQL Statements.

Appendix B: Exercise Answers.

Index.

Product Details

ISBN:
9780471781349
Author:
Kauffman, John
Publisher:
Wrox
Author:
Millington, Bradley
Subject:
Internet - Web Site Design
Subject:
Database Management - General
Subject:
Web site development
Subject:
Web databases
Subject:
Web - Page Design
Subject:
Microsoft .NET
Subject:
Programming - Software Development
Subject:
Internet - General
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Wrox Beginning Guides
Publication Date:
20090828
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Illustrations:
Y
Pages:
535
Dimensions:
9.20x7.34x1.23 in. 1.82 lbs.

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Internet » ASP
Computers and Internet » Internet » Active Server Pages
Computers and Internet » Internet » General
Computers and Internet » Internet » Information
Computers and Internet » Software Engineering » Software Management

Beginning ASP.Net 2.0 and Databases Used Trade Paper
0 stars - 0 reviews
$3.95 In Stock
Product details 535 pages Wrox Press - English 9780471781349 Reviews:
"Synopsis" by ,
  • Combining both VB.Net and C# coverage in one book, this guide focuses on using ASP.NET 2.0 for solving business dynamic Web site challenges in a logical progression, from connecting to a database to displaying information to changing data
  • Covers the fundamentals of connecting Web pages to databases, techniques for creating data objects and events, and ways to handle data errors
  • Features tricks and traps for displaying data in grids, lists, and trees
  • Goes beyond the usual basic techniques to discuss the best practices and pitfalls that can occur in real-world scenarios with SQL Server, Oracle, MySQL, Access, and the new SQL Server Express Edition
"Synopsis" by , The  book focuses  on solving business problems in a logical progression from connecting to displaying to changing the data. Additional chapters cover enhancements to the presentation and alternate types of data. The book follows Kauffman’ s practice of going beyond the basic techniques to discuss the permutations, pitfalls and best practices that occur in real business scenarios.

Some of the topics covered include: Fundamentals of connecting Web pages to databases Complete scenarios with SQL Server (including the new SQL Server Express Edition), Oracle® , MySQL® , Access, and XML Tricks and traps to displaying data in grids, lists, and trees How to allow users to change, add, and delete data Techniques for creating data objects and events and handling data errors

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.