book cover

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.

TABLE OF CONTENT:
Chapter 01 - Database Basics
Chapter 02 - Structured Query Language Queries and Commands
Chapter 03 - Getting Started with SQL Server 2000
Chapter 04 - ADO.NET—Data Providers
Chapter 05 - ADO.NET—The DataSet
Chapter 06 - ADO.NET—The DataAdapter
Chapter 07 - ADO.NET—Additional Features and Techniques
Chapter 08 - Visual Studio.NET Database Projects
Chapter 09 - XML and .NET
Chapter 10 - ADO.NET and XML
Chapter 11 - WebForms: Database Applications with ASP.NET
Chapter 12 - Web Services and Middle-Tier Technologies

Download Here

Password:ganelon

cover

This book provides the detailed guidance you need to make the right choices as you design and build enterprise-level applications with Visual Basic .NET. The author—a former member of the MS Visual Studio® .NET team with extensive experience in designing, testing, and optimizing enterprise applications—discusses the technical and architectural trade-offs you’ll face as you develop large, multitier, multideveloper distributed applications. He also shows how to create a workable enterprise infrastructure, and he reveals inside tips and techniques for implementation, performance tuning, and testing. You’ll find out how to take advantage of key state-of-the-art OOP features in Visual Basic .NET plus platform enhancements in MS .NET to develop serious enterprise applications quickly.

Most of what I’ll cover in this book applies to a broad spectrum of applications. Our discussion will focus on development for the enterprise, but you can use the advanced programming techniques and strategies presented here to write better and more sophisticated applications of all kinds in Visual Basic .NET. In addition, much of the techniques, technologies, and development approaches covered here apply equally well to all .NET languages, including C#.

This is not a design patterns book. This book will instead focus on how to use more advanced features of Visual Basic .NET and the .NET Framework to build into your applications common features that have in the past been too difficult to build in. Also, do not think that the purpose of this book is to make you an “enterprise developer.” This book provides a set of fundamental skills and technologies in an accessible fashion for the average developer. Think of this book as a stepping-stone to more advanced development topics.

There are two core audiences for this book: the novice Visual Basic .NET programmer and the classically trained Visual Basic developer who, already familiar with the Visual Basic .NET language, wants to see how new platform features can be and should be integrated into applications. Most of the material in this book is intended to be an extension of existing technical resources. If you’re expecting a ground-up introduction to Visual Basic .NET, you’ll be disappointed. I have an expectation that you have a basic familiarity with the language and platform. If you do not, there are plenty of excellent books from MS Press on the subject of Visual Basic .NET and I’d recommend starting there.

TABLE OF CONTENT:
Chapter 01 - Enterprise Application Development and VB.NET
Chapter 02 - Visual Basic .NET for the Enterprise
Chapter 03 - Multithreaded Programming
Chapter 04 - Playing Nice with Others
Chapter 05 - Distributed Programming in .NET
Chapter 06 - Custom Network Communication
Chapter 07 - Windows Services
Chapter 08 - Integrating Enterprise-Level Services
Chapter 09 - Adding Security to Your Applications
Chapter 10 - Essential Debugging Techniques
Chapter 11 - Common Performance Issues
Chapter 12 - The Art of Performance Tuning
Appendix A - Using VB.NET in a Multideveloper Environment
Appendix B - Getting Started with Application Center Test
Appendix C - Common Language Runtime Performance Counters
Appendix D - Performance Counter Quick Reference

Download Here

Password:ganelon

Next Page »