Microsoft insider William R. Vaughn shows developers how to use Visual Basic 5.0 to access data via SQL Server. This fifth edition also reveals the possibilities within the latest Visual Basic 5.0 technology--including its new ability to support a fully event-driven model. The CD contains a new sample database based on the Jet BIBLIO database, plus sample code and white papers.

A developer's one source for a detailed road map to the Visual Basic Library for SQL Server. This book explains the leading techniques for using Visual Basic to create front ends for SQL Server. It discusses the various architectures and approaches to data access, provides information on commonly encountered problems, and includes instructive sample code.

Since 1994 when he wrote his first “Hitchhiker’s Guide”, William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET. With the 7th Edition, Bill has completely rewritten this encyclopedic work from cover to cover–giving readers his insightful views on how applications should be built to maximize both developer and code performance. Visual Studio and the languages it hosts have never been as sophisticated as they are today–the same can be said for SQL Server. This makes it even more important for developers to understand how to best leverage their features without being held back by their complexity. That’s what this book is all about–making it easier for developers regardless of their know-how. The 7th edition is unique in that it’s designed to provide not only up-to-date tutorials on the latest development tools provided by Visual Studio and SQL Server, but also a solid platform of architectural advice and rich examples for developers trying to choose between the myriad of platform options. Beginners and experts alike will find comprehensive step-by-step instructions that can make the reader’s introduction to the latest versions of Visual Studio and SQL Server far easier. Key topic coverage includes: • Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain? • SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know? • Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help. • Using the latest ADO.NET data provider efficiently and safely. • How to protect the security of your database–and your job–by avoiding common mistakes. • How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster. • How to leverage the potential of SQL Server CLR executables and knowing when these features make sense. • How to work with your DBA to maintain database integrity and security. • Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology. William R. Vaughnis the President of Beta V Corporation and a Microsoft MVP. In 2000 he retired from Microsoft after 14 years to focus on mentoring, speaking, and writing. His specialty is data access application design especially when connecting to SQL Server–over the years he’s written 12 books on the subject. He’s a popular speaker at technical conferences all over the world where his wit and no-holds-barred technical insights win him rave reviews. William is also a member of the prestigious INETA Speaker’s Bureau. His works include articles for SQL Server Magazine and a bi-weekly editorial for Processor Magazine as well as books published by Microsoft Press and Apress. The book includes a DVD that contains a wealth of examples as well as several sample databases used to illustrate points discussed in the book. Authenticated readers will also have unrestricted access to the book’s supporting web site, www.hitchhikerguides.net, where additional examples, online forums, and other supplementary materials are available. www.awprofessional.com/msserverseries www.hitchhikerguides.net www.betav.com/blogs/billva www.betav.com

Taking readers far beyond official Microsoft documentation, the co-authors explore topics that range from how to securely install Reporting Services through virtually every facet of creating and deploying reports. In the accompanying DVD, video demonstrations show how to navigate through difficult and confusing parts of the technology.

A hands-on resource for developers, development managers in medium-sized to large MIS development shops, and everyone else who wants to use Visual Basic to tap the power of SQL Server. The enclosed CD-ROM contains sample code from the book, a sample database, code "building blocks" for users' own applications, white papers, and more. Cover Title

Visual Basic database developers are faced with a dizzying cornucopia of choices when it comes to data access paradigms. The purpose of this book is to make the choice and implementation of the best of those technologies far easier. It does this through working examples and numerous discussions of what works and what does not. Vaughns "Best Practices" are the techniques that developers need to know because they cause the least amount of overhead, problems and confusion. While some are quite simple to implement, other "Best Practices" require considerable thought and planning. This is a developers bookfull of hints, tips, and notes passed on from those who show the medals and scars of battles won and lost.

This book covers the basics - the place to get started. It starts with a brief review of computer processing in order to gain an understanding of context. It then covers C#; SQL Server and Networks.

Here is extensive coverage of ADO.NET technology including ADO.NET internals, namespaces, classes, and interfaces for beginning ADO developers.

ADO.NET and ADO Examples and Best Practices for VB Programmers, Second Edition brings the popular first edition up to date with fresh insights and tips on COM-based ADOand adds a voluminous section on the new ADO.NET technology. Written specifically for COM-based ADO developers retooling for ADO.NET, this is a developer's book, packed with practical advice on how to make code run faster, yet be easier to write and understand. Veteran author William Vaughn guides you through the data access maze with working examples and numerous discussions of what works and what doesn't. Derived from years of experience working with data access developers, Vaughn's Best Practices are a set of techniques proven to drastically reduce overhead, problems, and confusion—for the developer, the system, and the entire team. While some are quite simple to implement, others require considerable knowledge and forethought to enable.

This volume contains case studies, theoretical papers and project development reports on one of the greatest challenges facing the new digital enterprises: the life cycle approach to management and production. Main issues discussed in the book include CAD/CAM/CIM/CAE, intelligent manufacturing, and control and robotics applications.