Beginning VB.NET Databases

  • 12h 44m
  • Thearon Willis
  • John Wiley & Sons (US)
  • 2004

One of the most popular programming languages today, Visual Basic.NET is designed to be the easiest and most productive tool for creating .NET applications. This book will show you how to harness the power of VB.NET in order to write your own practical database programs that can be used throughout the enterprise.

With the help of examples and instructions, you'll discover how to dramatically improve the performance and scalability of your existing databases. you'll also learn how to efficiently access and manipulate data from their applications. And you'll find out how to utilize queries, views, store procedures, and much more.

What you will learn from this book

  • To work effectively with DataSets, DataTables, DataColumns, and DataViews
  • Successful ways to use the VS.NET Data Wizards with Access, SQL Server, and Oracle
  • How to use ADO.Net to access and manipulate data in relational databases
  • Ways to build business logic and data access components
  • How to effectively write database applications using SQL Server and Oracle
  • Techniques for creating and consuming Web Services from Windows and Web applications
  • How to select and update data, use joins, validate input, and much more

Who this book is for

This book is for developers who want to bring their current databases and applications up to speed with the newest .NET framework. Some experience developing Windows and ASP.Net applications with Visual Basic.Net is helpful, but not essential.

About the Author

Thearon Willis is a senior systems engineer with over 20 years of programming experience. He started writing applications using the Basic language in 1980 and later moved on to Visual Basic and finally to Visual Basic .NET.

He began working with databases in 1987 and has been hooked on writing database applications ever since. He has experience with SQL Server, Oracle, and DB2, and works with SQL Server on a daily basis. Thearon has also programmed in several other languages, some of which include C++, Assembler, Pascal, and COBOL. However, he enjoys Visual Basic .NET the best, as it provides the features needed to quickly build Windows and Web applications as well as components and Web Services.

Thearon currently develops intranet applications, Web Services, and server-side and client-side utilities using Visual Basic .NET and Visual Basic. Most of these applications and utilities are database-driven and make heavy use of XML and XSL.

In this Book

  • Databases
  • An Introduction to ADO.NET
  • Visual Studio: .NET Data Wizards
  • Basic SQL
  • SQL and Queries for Access
  • Selecting Data in Access
  • Inserting, Updating, and Deleting Data in Access
  • Migrating Data From Access
  • Stored Procedures and Views for SQL Server and Oracle
  • Building Business Logic and Data Access Components
  • Inserting Data
  • Selecting Data
  • Updating Data
  • Accessing Data in ASP.NET
  • Creating a Web Service
  • Accessing a Web Service
SHOW MORE
FREE ACCESS