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
Download
These projects are fun to build and fun to use
Make lights dance to music, play with radio remote control, or build your own metal detector
Who says the Science Fair has to end? If you love building gadgets, this book belongs on your radar. Here are complete directions for building ten cool creations that involve light, sound, or vibrations — a weird microphone, remote control gizmos, talking toys, and more, with full parts and tools lists, safety guidelines, and wiring schematics.
Check out ten cool electronics projects, including
* Chapter 8 — Surfing the Radio Waves (how to make your own radio)
* Chapter 9 — Scary Pumpkins (crazy Halloween decorations that have sound, light, and movement)
* Chapter 12 — Hitting Paydirt with an Electronic Metal Detector (a project that can pay for itself)
Download
The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.
You’ll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle® and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.
What you will learn from this book
* The platform independence capability that comes from using XML— including independence from database vendors
* The basics of XML, XSL, the XML DOM, and SQL
* XML datatypes and features in Oracle Database and SQL Server
* How to move data anywhere using XML (B2B)
* Ways to read XML documents using XQuery and navigate documents using XPath®
* XML, the object data model, native XML databases, and industry applications of XML
Download
Pro T-SQL 2005 Programmer’s Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you’ll find it described clearly here.
Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer’s guide to T-SQL and SQL Server 2005.
Download
