ADO and ADO.NET Programming - Softcover

Gunderloy, Mike

Softcover

ISBN 10: 0782129943 ISBN 13: 9780782129946

Publisher: John Wiley & Sons, 2002

Synopsis

ADO, or ActiveX Data Objects, is Microsoft′s key technology for data access in client/server and Web applications. This book covers both ADO and ADO.NET in one volume, allowing a programmer to select the appropriate technology for their database application. The material is good for not only VB.NET and C# programmers but also those using VBA, Access, and older versions of the Microsoft programming tools. It includes numerous examples showing various combinations of servers and clients, including SQL Server, Jet, and Oracle on the server side, and VB, Access, ASP.NET, and VB.NET on the client side. The book also covers more advanced topics, such as disconnected recordsets, XML integration, schema modification, and multidimensional aggregation. The companion CD–ROM includes all the sample code and applications from the book, plus a collection of third–party ADO utilities.

Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.

About this title

About the Author

Mike Gunderloy has worked with every Microsoft data access technology, from the release of Access 1.1 right through ADO.NET. He′san independent consultant and frequent author on database topics. His other Sybex books include the Access 2002 Desktop and Enterprise Developer′s Handbooks (with Paul Litwin and Ken Getz), SQL Server Developer′s Guide to OLAP with Analysis Services, Visual Basic Developer′s Guide to ADO, and Mastering SQL Server 2000. Mike lives on a farm in eastern Washington, where he raises chickens, llamas, and peacocks when he′s not wrestling with new software releases.

From the Back Cover

Data access technology has come a long way in the past decade. The introduction of Microsoft Access was a major step forward, followed by the giant leaps represented by ADO and now by ADO.NET.

ADO and ADO.NET Programming will help you use both APIs to write data access code that works perfectly, irrespective of the data source or front end. You′ll learn to enlist ADO techniques in support of legacy systems, as well as in other scenarios where ADO is simply the better choice. And you′ll master the special capabilities of ADO.NET, such as support for XML and disconnected data, that promise to make it the dominant data access API for years to come. Simple data retrieval and updating is only the beginning. Advanced topics include schema modification, data synchronization, and multidimensional aggregation.

There′s more to ADO and ADO.NET than universal connectivity, of course. This book offers detailed coverage of source–specific and client–specific functionality, helping you tap into features unique to SQL Server, Oracle, and Jet, on the one hand, and Visual Basic, Access, and Excel, on the other hand. You also get a practical introduction to the .NET Framework and appendices covering major object models and the SQL and MDX query languages on CD.

On the CD
The enclosed CD contains all the book′s sample code—both ADO code written in Visual Basic 6 and ADO.NET code written in Visual Basic .NET. These examples vividly illustrate the book′s techniques and allow you to test their effectiveness and sharpen your own coding skills.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2002
• Language: English
• ISBN 10: 0782129943
• ISBN 13: 9780782129946
• Binding: Paperback
• Number of pages: 1042