This book is about accessing databases in Visual Basic (VB) .NET, Microsoft's latest incarnation of the popular development tool and programming language that revolutionized Windows application development. With this release, Microsoft has departed from the traditional VB paradigm by introducing object-oriented programming to VB for the first time. Microsoft has also changed lanes in its approach to database access. Until now, all of the past technologies (DAO, RDO, ADO) have relied on a connected model, where a connection to the database was maintained throughout the user 's session. With ADO .NET, this has been reversed . Now we are going to a disconnected model, where connections are established just long enough to read or update the data, then closed.
Because of these changes, we will be discussing ADO .NET and VB in detail. We will be looking at how object-oriented programming is implemented in VB, as this is necessary to understand how ADO .NET works.
To alleviate version shock , we will jump right in to creating a simple database form in VB. This is not intended to be a complete discussion of ADO .NET or VB. That will come later. This chapter is intended to show you that you can do this! Remember there was a time when Windows programming was new to us and we thought we would never get it. We all managed to learn it and we will also manage to learn this new paradigm. As a matter of fact, that is the purpose of this book: to make you a productive VB .NET database programmer. We will not look at every property and method of every class out there. We will show you the most productive practices and give you a thorough understanding of how to use ADO .NET with VB. We will then leave it to you to dig deeper and go build something.