Database Access with Visual Basic .NET continues to use techniques developed by Jeffrey McManus that provide solutions to problems faced by developers every day. Since data access is the most used feature in corporate development, it is important for developers to understand the most effective and efficient way to access data using .NET technologies. This book provides clear explanations of how to use ADO.NET to access data stored in relational databases, as well as how XML integrates with ADO.NET. The authors use their years of experience to relate key topics to real-world applications through use of Business Cases that include code listings in Visual Basic .NET.

The purpose of this book is to show you how to develop database applications, using Visual Basic.NET and ADO.NET. Even though we expect that most readers will be working with SQL Server, we do not assume that they are experienced with it. You may be new to database applications or only have experience with other databases such as Microsoft Access or Oracle. We have therefore included a hefty overview of Microsoft SQL Server in Chapter 3. If you are experienced with SQL Server, you may want to skip this chapter. However, it covers a wide variety of topics, and you may still find a "nugget" or two that would make reading the chapter worthwhile.

We assume that you are already familiar with Visual Basic.NET (VB.NET). Although we give step-by-step coding instructions and code examples, we do not cover VB.NET syntax in this book. We assume that you are reasonably comfortable with VB.NET and Visual Studio.NET (VS.NET) and do not waste your time reviewing fundamental concepts. For example, we do not normally step through basic tasks, such as opening and saving project files, except maybe the first time you encounter them. We do, however, often show how to do the same thing in several different ways—we hope that this will extend your knowledge of VB.NET, without rehashing the basics. You may also notice variant coding styles, and even screen shots on different versions of Windows—all illustrating the flexibility of VB.NET.

If you’re new to Visual Basic .NET, this book gets you started right. By chapter 3, you’ll be  developing  simple  but  complete  applications.  By  chapter  5,  you’ll  be  doing  some serious programming. And by chapter 7, you’ll be able to code, test, and debug object-oriented programs with Visual Basic .NET.

Of course, there’s a lot more to Visual Basic .NET than one beginning book can cover. But  this  book  gets  you  started  with  all  of  the  important  features  and  capabilities  of Visual Basic .NET and prepares you for learning more about them on your own. That’s why we say that no other book or course will get you started faster or better than this book.

This  book  is  for  anyone  who  wants  to  learn  how  to  use  Visual  Basic  .NET  for developing business applications. It works if you have no programming experience at all. It works if you have programming experience with another language like COBOL or Java. It works if you already know Visual Basic 6. And it works if you’ve already read three or four other Visual Basic .NET books and still don’t know how to develop a real-world business application.

If you’re completely new to programming, the prerequisites are minimal. First, you need to  be  familiar  with  the  Windows  interface.  This  means  that  you  have  used  Windows applications like Word or Excel so you’re comfortable with tasks like opening, saving, printing, and closing files. Second, you should know how to use the Windows Explorer to copy folders and files from one location to another. 

This book is definitive Visual Basic 2005 programming and development resource.

Get full details on the powerful features of Visual Basic 2005 in this comprehensive one-stop guide that's filled with information not included in the online documentation. Programming expert Ron Petrusha begins by laying out what's new in Visual Basic 2005, such as its object-oriented programming capabilities. You'll find in-depth coverage of current language elements, coding techniques, and troubleshooting procedures.

Syntax explanations, code samples, and real-world examples illustrate each point along the way. Valuable appendices include information on constants and enumerations, compiling applications from the command line, and data conversion. This book is a particularly valuable desktop companion when coding and troubleshooting misbehaving code.

Master this massive programming language upgrade that raises Visual Basic functionality to the level of the .NET platform. Coverage includes all core topics—plus security, debugging, and helpful information on migrating existing Visual Basic projects to Visual Basic.NET.

Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VB. C/C++. Excel Add-in Development in C/C++ - Applications for Finance is a how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Author Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It covers the relative strengths and weaknesses of developing add-ins for Excel in VB versus C/C++.

Essential ASP.NET with Examples in Visual Basic .NET is the Visual Basic programmer's definitive reference for ASP.NET through version 1.1. It provides experienced programmers with the information needed to fully understand the technology, and is a clear guide to using ASP.NET to build robust and well-architected Web applications.

This book begins with a discussion of the rationale behind the design of ASP.NET and an introduction to how it builds on top of the .NET framework. Subsequent chapters explore the host of new features in ASP.NET, including the server-side compilation model, code-behind classes, server-side controls, form validation, the data binding model, and custom control development. Throughout the book, working examples illustrate best practices for building Web-based applications in VB.NET.

This book focuses exclusively on ASP.NET and does not spend time reviewing .NET programming, object-oriented programming techniques, database access, or general Web application development techniques. You will be able to get the most out of this book if you have spent some time gaining experience in each of these areas.

Visual Basic For Application (VBA for short) is a programming environment designed to work with MS Office applications (Word, Excel, Access and Power Point). components in each application (for example, worksheets or documents) are exposed as objects to the programmer to use and manipulate to a desired end. Almost anything you cand do through the normal use of the Office application can also be automated thourgh programming.

VBA is a complete programming language, but you can't use it outside the application in which it is integrated. This does not mean VBA can be integrated only with Office programs. Any software vendor that decides to implement VBA can include it with their application.

Packed with unique, ready-to-use projects, this reference book will help you quickly get up to speed with Visual Basic 2005. Each project is presented in a step-by-step format, which enables you to set up, enhance, and reuse them in different real world situations. The accompanying CD-ROM also includes all of the source code from these projects, making it even easier for you to modify the applications to fit your own needs. Visual Basic 2005 Instant Results not only provides you with ready-to-use classes, but it also shows you how to apply some of the more advanced features of Windows® programming. In addition, you'll discover how to access Web Services from a Visual Basic Windows program as well as access SQL Server Express 2005. This approach will give you the skills to achieve the programming results you want. 

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.

In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2005 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 2.0 and offers you the best contemporary practice in this core programming area, so that you'll find yourself using it in nearly all your .NET projects.

Experience learning made easy, and quickly teach yourself Microsoft Office Excel 2007 Visual Basic for Applications (VBA)–one step at a time! Work at your own pace through the easy numbered steps and practice files on CD, and master the fundamentals for using VBA to create custom software solutions and automating tasks in Excel 2007–no developer experience required! You'll learn how to automate spreadsheets, write your own functions and procedures, and customize menus and toolbars. You'll discover Excel Objects, including workbooks, range objects, graphics, and PivotTables®. Plus, you'll learn how to chart data from databases and other information sources. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction–building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.

The goal of this book is to provide programmers, power users, and system administrators who have a previous programming background with a project-oriented approach to learning the VBScript (Visual Basic Scripting) language. VBScript is a member of the Visual Basic family of programming languages that includes both Visual Basic and VBA (Visual Basic for Applications).

VBScript is a scripting language that acts as a tool for rapid application development in a host of different operating environments. VBScript provides the ability to automate tasks on Windows operating systems using the WSH (Windows Script Host). The WSH provides VBScripts with access to Windows resources, such as the Windows file system, the desktop, the registry, and network resources. In addition, when combined with HTML and executed within Internet Explorer, VBScript allows the user to create interactive client-side Web content.