Beginning ASP.NET 2.0 and Databases

Overview

  • 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 ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (35) from $1.99   
  • New (14) from $1.99   
  • Used (21) from $1.99   
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 14 (2 pages)
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2009

Feedback rating:

(2410)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2006-08-07 Paperback 1 New 0471781347 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. Try ... Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$2.99
Seller since 2007

Feedback rating:

(180)

Condition: New
Brand New. No remainder mark. Ship daily. Pack carefully. E-mail when shipped. 66E

Ships from: Denver, CO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$12.57
Seller since 2010

Feedback rating:

(941)

Condition: New
PAPERBACK New 0471781347 Friendly Return Policy. A+++ Customer Service!

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.57
Seller since 2011

Feedback rating:

(757)

Condition: New
PAPERBACK New 0471781347 SERVING OUR CUSTOMERS WITH BEST PRICES. FROM A COMPANY YOU TRUST, HUGE SELECTION. RELIABLE CUSTOMER SERVICE! ! HASSLE FREE RETURN POLICY, SATISFACTION ... GURANTEED**** Read more Show Less

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.60
Seller since 2014

Feedback rating:

(284)

Condition: New
PAPERBACK New 0471781347 XCITING PRICES JUST FOR YOU. Ships within 24 hours. Best customer service. 100% money back return policy.

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.60
Seller since 2010

Feedback rating:

(708)

Condition: New
PAPERBACK New 0471781347! ! ! ! BEST PRICES WITH A SERVICE YOU CAN RELY! ! !

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.60
Seller since 2014

Feedback rating:

(429)

Condition: New
PAPERBACK New 0471781347! ! KNOWLEDGE IS POWER! ! ENJOY OUR BEST PRICES! ! ! Ships Fast. All standard orders delivered within 5 to 12 business days.

Ships from: Southampton, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$14.65
Seller since 2008

Feedback rating:

(169)

Condition: New
0471781347 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$14.95
Seller since 2014

Feedback rating:

(0)

Condition: New

Ships from: Clifton, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$33.98
Seller since 2008

Feedback rating:

(281)

Condition: New
0471781347 New item in stock, may show minimal wear from storage. No remainder mark. I ship daily and provide tracking! 100% Money Back Guarantee!

Ships from: FORT MYERS, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 2
Showing 1 – 10 of 14 (2 pages)
Close
Sort by
Sending request ...

Overview

  • 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
Read More Show Less

Product Details

  • ISBN-13: 9780471781349
  • Publisher: Wiley
  • Publication date: 7/31/2006
  • Series: Wrox Beginning Guides Series
  • Edition number: 1
  • Pages: 535
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.20 (d)

Meet 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.
Read More Show Less

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted November 13, 2007

    A must for an ASP.NET newbie as well as a professional programmer from different disciplines

    I am a spare-time software developer and I have a lot of experience building web sites and previous versions of Visual Basic. I needed to build a database driven intranet site to exchange information betlween my 3 offices of my company in different continents and wanted a book that would give a good taste of ASP.NET. I wanted a book that didn't drown the reader with useless details and over simplification. And this book does the job. John Kauffman and Bradley Millington managed to hit a good compromise - enough words to get the point across in a clear manner, without boring the reader. Not boring yet still explanatory. Wrox support behind this books is excellent as other books published by Wrox. A rich content support web site really helpful in the sleepless nights when you keep some broken code coming back to your mind. I fully recommend!..

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)