ADO Programmer's Reference

ADO Programmer's Reference

Author: David Sussman

Publisher: Apress

Published: 2008-01-01

Total Pages: 701

ISBN-13: 1430207183

DOWNLOAD EBOOK

* This is the most definitive book on the subject and has been the leading reference on ADO since its first release. * Covers all versions of ADO. * Covers related technologies, such as ADOX and ADOMD. * Supported by online samples in multiple languages. * Examines performance aspects of ADO.


ADO Programmer's Reference

ADO Programmer's Reference

Author: David Sussman

Publisher: Apress

Published: 2004-02-11

Total Pages: 716

ISBN-13: 9781590593424

DOWNLOAD EBOOK

All programmers working in database technology using Microsoft development tools will find this book useful. As a reference, it is suitable for beginners and experienced programmers alike. This is a great addition and complement to any other ADO manual, and its one you'll want to keep on the desk at all times. This informative guide provides a complete reference to the ADO API, covering all versions up to 2.8. Code samples are concise, and emphasis is placed on ADO techniques rather than the specific environments in which it may be used. Some of the book's highlights include: Coverage of related technologies, such as ADOX and ADOMD Online samples in multiple languages Examination of ADO performance aspects This is the most definitive book on the subject to date, and has been the leading reference on ADO since its first release. Please note: source code can be downloaded from the following URL: http://www.ipona.com/samples/


Access 2010 Programmer's Reference

Access 2010 Programmer's Reference

Author: Teresa Hennig

Publisher: John Wiley & Sons

Published: 2010-10-28

Total Pages: 132

ISBN-13: 047093896X

DOWNLOAD EBOOK

A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features


A Programmer’s Guide to ADO.NET in C#

A Programmer’s Guide to ADO.NET in C#

Author: Mahesh Chand

Publisher:

Published: 2002-04-25

Total Pages: 748

ISBN-13:

DOWNLOAD EBOOK

A Programmer's Guide to ADO.NET in C# begins by taking readers through a fast-paced overview of C# and then delves into ADO.NET. Why should C# programmers use it instead of the existing technologies? What new functionality does it offer? The chapters that follow go through the details on each of the major Data Providers of the .NET platform (OleDb, SQL Server, and ODBC) that enable you to read and write data to the targeted database. These chapters also serve as a good reference for looking up detailed methods and properties for these data provider classes. Authors Chand and Gold also show C# programmers how to work with XML classes and how to integrate XML into the ADO.NET architecture. The book provides programmers with handy ideas about taking advantage of the VS.NET IDE and how you can tie your data to the myriad of powerful controls including the multi-faceted Data Grid. Finally, it goes through creating a guest book application for the Web so you can see how all the pieces fit together.


ADO ActiveX Data Objects

ADO ActiveX Data Objects

Author: Jason T. Roff

Publisher: "O'Reilly Media, Inc."

Published: 2001

Total Pages: 628

ISBN-13: 9781565924154

DOWNLOAD EBOOK

The architecture of ADO (ActiveX Data Objects), Microsoft's newest form of database communication, is simple, concise, and efficient. This indispensable reference takes a comprehensive look at every object, collection, method, and property of ADO for developers who want to get a leg up on this technology.


Access 2003 VBA Programmer's Reference

Access 2003 VBA Programmer's Reference

Author: Patricia Cardoza

Publisher: John Wiley & Sons

Published: 2004-04-14

Total Pages: 982

ISBN-13: 0764571664

DOWNLOAD EBOOK

What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.


Excel 2003 VBA Programmer's Reference

Excel 2003 VBA Programmer's Reference

Author: Paul T. Kimmel

Publisher: John Wiley & Sons

Published: 2004-10-06

Total Pages: 1176

ISBN-13: 0764578987

DOWNLOAD EBOOK

What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book cover? In this book, you'll discover how to do the following: Set up applications and convert them to add-ins Package and distribute Excel applications Set up interaction with other Office applications and databases Program the VB Editor and use the Windows API Use VB6 and VB.NET with Excel Set up internationalization Advanced debugging and error handling techniques


Access 2003 VBA Programmer's Reference

Access 2003 VBA Programmer's Reference

Author: Patricia Cardoza

Publisher: John Wiley & Sons

Published: 2004-04-09

Total Pages: 982

ISBN-13: 0764559036

DOWNLOAD EBOOK

What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.


Microsoft ADO.NET

Microsoft ADO.NET

Author: David Sceppa

Publisher:

Published: 2002

Total Pages: 704

ISBN-13: 9780735614239

DOWNLOAD EBOOK

For every developer who's uttered, "I wish I knew that before I started writing all this code!" this guide demonstrates how to save time, write less code, and build more powerful, data-driver solutions using Microsoft ActiveX Data Objects. CD contains code samples in VB, along with examples in Visual C++, and Visual J++.


Excel 2000 VBA Programmer's Reference

Excel 2000 VBA Programmer's Reference

Author: John Green

Publisher: Wrox

Published: 1999

Total Pages: 760

ISBN-13: 9781861002549

DOWNLOAD EBOOK

Office 2002 is the next version (after Office 2000) of Microsoft's program suite that includes Word, Access, Outlook and Excel. The aim of 2002 is to take advantage of Office's core position within most business systems and make it the interface to business processes and web services. One of the most significant advances is the XML capability that has been added to Access and Excel, with the latter becoming the key to future Web Service integration and an essential part of any Office developer's skill set. -- Written by two active and popular members of the Excel community -- Includes coverage of all the new features including smart tags, pivot tables, and web components -- Examines all the new XML capabilities that 2002 brings to the Excel world