Beginning ASP.NET 2.0 and Databases
Home > Computing and Information Technology > Computer programming / software engineering > Beginning ASP.NET 2.0 and Databases
Beginning ASP.NET 2.0 and Databases

Beginning ASP.NET 2.0 and Databases

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

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

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 Master—Details 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.


Best Sellers


Product Details
  • ISBN-13: 9780470083994
  • Publisher: John Wiley & Sons Inc
  • Binding: Digital (delivered electronically)
  • No of Pages: 535
  • ISBN-10: 0470083999
  • Publisher Date: 28 Aug 2009
  • Language: English


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Beginning ASP.NET 2.0 and Databases
John Wiley & Sons Inc -
Beginning ASP.NET 2.0 and Databases
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Beginning ASP.NET 2.0 and Databases

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!