Programming Microsoft SQL server 2000 with Microsoft Visual Basic .NET /

This book targets professional Visual Basic and Visual Basic for Applications developers. From my seminar tours and Web sites (http://www.program-mingmsaccess.com and http://wwtv.cabinc.net), I know that these professionals are driven by a passion to deliver solutions to their clients through appiying the most innovative technologies their clients will accept. In-house developers are the go-to persons for getting results fast-particularly for custom in-house sys-tems and databases. Independent developers specialize in serving niche situa-tions that can include under-served business needs and work overflows. In both cases, these professionals need training materials that address practical business requirements while showcasing innovative technologies without wast-ing their time. This book strives to serve this broad need in two specific áreas. This book is for developers looking for code samples and step-by-step instructions for building SQL Server 2000 solutions with Visual Basic .NET. The book focuses on the integration of SQL Server 2000 with .NET technologies tapped via Visual Basic .NET. It is my firm belief that you cannot créate great SQL Server solutions in any programming language without knowing SQL Server. Therefore, this book goes beyond traditional coverage of SQL Server for Visual Basic developers. You'11 learn T-SQL programming techniques for data access, data manipulation, and data definition. A whole chapter equips you to secure your SQL Server solutions. In addition, there's plenty of content in this book on Visual Basic .NET and related technologies, such as ADO.NET, ASP.NET, XML (Extensible Markup Language), and XML Web services. The pre-sentation of these technologies demónstrales coding techniques and explores concepts that equip you to build better solutions with SQL Server 2000 databases. In addition, the book highiights innovations introduced through the Web releases for SQL Server 2000 that intégrate SQL Server 2000 tightiy with Visual Basic .NET. This isn't a book about XML, but three of the book's 13 chapters focus in whole or in part on XML. Therefore, those seeking practical demonstrations of how to use XML with SQL Server and Visual Basic .NET will derive valué from this book. If you have looked at any of the computer magazines over the past couple ofyears, you know that XML is coming to a solution near you. However, the rapid pace of XML innovation may have dissuaded some from jumping on the bandwagon while they wait to see what's going to last and what's just a fad. In the book's three chapters on XML technology, you'11 learn about XML docu-ments, fragments, and formatting as well as related technologies, such as XPath (XML Path Language) queries, XSLT (Extensible Styiesheet Language Transfor-mation), and WSDL (Web Services Description Language).