Professional ASP.NET 2.0 Databases and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Good See details
$5.61 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
Professional ASP.NET 2.0 Databases (Wrox Professional Guides)
 
 
Start reading Professional ASP.NET 2.0 Databases on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Professional ASP.NET 2.0 Databases (Wrox Professional Guides) [Paperback]

Thiru Thangarathinam (Author)
5.0 out of 5 stars  See all reviews (2 customer reviews)

Price: $49.99 & this item ships for FREE with Super Saver Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 1 left in stock--order soon (more on the way).
Want it delivered Monday, February 13? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $35.21  
Paperback $49.99  

Book Description

February 12, 2007 047004179X 978-0470041796 1
Now you can uncover the secrets behind accessing and retrieving data from a wide range of data sources such as SQL Server and XML sources. This book walks you through the array of ADO.NET 2.0 features and clearly shows you how they can be used to develop database-driven web applications in ASP.NET.

You’ll first gain an in-depth understanding of the data source controls that enable data binding in the ASP.NET platform. Next you’ll uncover the advanced features of ASP.NET, including site navigation, implementing sorting and paging, and editing data in templates. You’ll then focus on designing transactions in ADO.NET 2.0, displaying data, and utilizing SQL Server 2005 XML.

Throughout the chapters, you’ll find examples and source code (with ASP.NET examples written in C#) that you can integrate into your applications. This will enable you to leverage ADO.NET and ASP.NET features so you can easily create a scalable N-Tier web site.

Some of the topics covered include:

  • ASP.NET 2.0 Data Controls
  • Data Binding with the SqlDataSource Control, XML Data, and Objects
  • Selecting, Updating, Deleting Records
  • Programmatically Creating and Adding Controls
  • XSL Transformations with XmlDataSource Control
  • Using Generics with the ObjectDataSource Control
  • ASP.NET 2.0 Site Navigation including Implementing Breadcrumbs and Binding to Other Controls
  • Displaying and Editing Data Using Templates
  • GridView Sorting and Paging
  • Advanced Data Source and Data-Bound Controls including Master/Detail Display, Displaying Images from a Database, and Using Themes with Data Bound Controls
  • Transactions in .NET and Interoperability between System.Transactions and System.EnterpriseServices
  • Advanced ADO.NET for ASP.NET Data Display including DataSet Object, ADO.NET 2.0 DataTable, and Provider-Independent Data Access Code
  • Accessing Data from SQL Server 2005 including CLR in SQL Server 2005, New XML Features in SQL Server 2005, and Working with XML Data-Typed Columns from ADO.NET
  • N-Tier Architecture with ASP.NET 2.0 and SQL Server 2005
  • Best Practices for Creating ASP.NET Web Sites including Implementation of CLR Stored Procedures and Implementation of Layers

Frequently Bought Together

Customers buy this book with Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional) $29.69

Professional ASP.NET 2.0 Databases (Wrox Professional Guides) + Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional)


Editorial Reviews

From the Back Cover

Now you can uncover the secrets behind accessing and retrieving data from a wide range of data sources such as SQL Server and XML sources. This book walks you through the array of ADO.NET 2.0 features and clearly shows you how they can be used to develop database-driven web applications in ASP.NET.

You'll first gain an in-depth understanding of the data source controls that enable data binding in the ASP.NET platform. Next you'll uncover the advanced features of ASP.NET, including site navigation, implementing sorting and paging, and editing data in templates. You'll then focus on designing transactions in ADO.NET 2.0, displaying data, and utilizing SQL Server 2005 XML.

Throughout the chapters, you'll find examples and source code that you can integrate into your applications. This will enable you to leverage ADO.NET and ASP.NET features so you can easily create a scalable N-Tier web site.

What you will learn from this book

  • All about the new ASP.NET page architecture, data controls, and code sharing features
  • How to work with hierarchical XML data
  • Ways to fine-tune formatting with templates
  • Tips for providing transaction support in your business applications
  • Techniques for creating high performance web sites with the advanced features of ADO.NET 2.0
  • How to build better architected applications using the new XML data type in SQL Server 2005

Who this book is for

This book is for intermediate or experienced programmers who have started developing with ASP.NET and are familiar with relational databases such as SQL Server. The ASP.NET example code is written in C#.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Thiru Thangarathinam works for Intel Corporation in Phoenix, Arizona. He is an MVP and specializes in architecting, designing, and developing distributed enterprise-class applications using .NET-related technologies. He is the author of Professional ASP.NET 2.0 XML from Wiley and has also coauthored a number of books in .NET-related technologies. Thiru has also been a frequent contributor to leading technology-related online publications. At Intel, he is part of the team that is focused on developing the Enterprise Architecture and Service Oriented Architectures for Intel. He can be reached at thiruthangarathinam@yahoo.com.

Product Details

  • Paperback: 504 pages
  • Publisher: Wrox; 1 edition (February 12, 2007)
  • Language: English
  • ISBN-10: 047004179X
  • ISBN-13: 978-0470041796
  • Product Dimensions: 9.2 x 7.4 x 1.2 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Best Sellers Rank: #311,454 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

24 of 25 people found the following review helpful:
5.0 out of 5 stars Great ASP.NET 2.0 book for Real Developers, February 13, 2007
This review is from: Professional ASP.NET 2.0 Databases (Wrox Professional Guides) (Paperback)
There are many ASP.NET 2.0 books on the market now, but they either come in two categories: The beginner who knows another server-side technology (ASP or PHP or even Java) or the advanced who wants to knows about web services or XML implementations or advanced web architecture. I have not found a book that is a solid intermediate ASP.NET 2.0 book on teaching the reader solid, real-life database applications, until now. This book fills in the gaps of so many other books out there on ASP.NET that it really should be the 2nd ASP.NET book you get. If you're already familiar with ASP.NET then this should be your first book. Because pretty much after you know how to use the basic controls and create some master pages and maybe some web parts you really know as much as the majority of the basic ASP.NET developer. This book by Thiru Thangarathinam really gives you a great understanding of "real-world" implementations of ASP.NET applications using any type of database.

Like any book, there always will be an introduction on the technology taught, so basically the first three chapters caters to refresh the reader on this technology. Chapter 1 introduces the ASP.NET 2.0 technology and terminology, the new data controls, how master pages work, and web parts framework. Chapter 2 is a very important chapter because it sets the stage for later chapters focusing on ADO.NET. You do not know how many books I have gone through trying to find a book with anything more than 20 pages on ADO.NET. It amazes me that no book (other than this one), really takes the time and explains this corroborating technology in detail when talking about ASP.NET. Yes, I have seen the pure ADO.NET books out there, but they put most of the explanation towards Windows forms, not web forms. I like how the author organizes the material and then further gives greater detail in other chapters (13 and 14). Chapter 3 introduces the reader to the updated data controls with some good detail on the advantages and disadvantages of using them, the new ObjectDataSource control, and how to incorporate the usual data-bound controls (GridView, DetailView and FormView) to them. A very good introduction to the basics.

The book (Chapter 4) then goes into using the SqlDataSource control (a good 35 pages) with topics like: Executing stored procedures and returning data, How to process return values from a stored procedure, How to handle null values, How to handle exceptions raised by the SqlDataSource control, How to detect conflict during updates, etc. Not to be overly praising this book, but I cannot remember one book that covered all these interesting topics before. Maybe I've seen this in two or three but not just one. A great chapter. The following chapter (5), the author reviews how to data bind XML data using the XmlDataSourceControl, how to filter the data, applying XSLT stylesheets, programmatically creating a XmlDataSource control, etc. A very thorough explanation of a control that is not talked about enough in other books.

One of the most interesting chapters of this book in my opinion is Chapter 6 which shows the basics (and much more) of data binding with objects. Instead of always depending on inline data source controls, you can create n-tier controls (though somewhat limited) and separate the code logic in separate classes. Though this chapter is semi-misleading because it still is talking about using a control (ObjectDataSource) in its examples. A better title would have been: Creating Object with the ObjectDataSource Control (or something like that). In any event, this chapter opens your eyes on one of the ways you can create some "real-world" development techniques.

The next two chapters (7 and 8) focus on making site wide changes to either your web pages (site navigation - SiteMapDataSource control) and how to modify existing controls like the GridView to create template columns and fields to unify your page look.

A great chapter that I automatically started reading right away was chapter 10 which focused on advanced data binding concepts such as creating a master/detail page (or parent/child), displaying selected rows in a GridView, creating custom templates in a GridView, using themes, using other controls (DropDownList) in a GridView, and extending the GridView. Lots of good stuff in this chapter that you will find on a bunch of websites or blogs or forums.

The last few chapters the author goes through creating a nice application (Rental Resevation System) and puts everything taught together. I think every book should have the last couple chapters of the book to put all the pieces together so the reader can get some ideas on how to use them in their own web applications. The code in the book is in C#, so for all you VB.NET developers you'll need to spend some time converting the code.

Apart from that this is an excellent book that teaches the reader how to really use ASP.NET 2.0 to its full potential and lots of tricks of the trade that would take you hours of searching online to find the answer. I highly recommend this book to any ASP.NET developer.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Nice book, June 26, 2011
Amazon Verified Purchase(What's this?)
This review is from: Professional ASP.NET 2.0 Databases (Wrox Professional Guides) (Paperback)
Nice book, it covers everything I expected, there is already a 4.0 version of Asp but as long as I use 2.0 this book has everything about gridviews,formviews and other asp 2.0 data-base related controls.
Buying this used was very good deal :)
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
data access block, sitemap information, sitemap provider, ionscope object, script callback feature, sitemap data, templated columns, data source controls, callback manager, sitemap file, sglcommand object, sitemap node, site navigation system, security trimming, data bound controls, products that belong, cache dependency, data access code, object sender, data access class, sglconnection object, sqlcommand objects, xml schema collection, serviced components, dbo dbo
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Import Namespace, Microsoft Internet Explorer, File Edit View Favorites Tools Help, Visual Studio, Group Name, Property Description, Web Parts, Enterprise Library, Purchasing Inventory Management, Done Local, Production Control Manufacturing, Production Manufacturing, Adjustable Race, Name Data Type Length, Product Name, Editing Data, Bearing Ball, Product Where, Server Management Studio, Ball Bearing, Method Description, Document Control Quality Assurance, Pride And Prejudice, Production Technician, Quality Assurance Quality Assurance
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:




Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject