ProgrammingMSAccess.com

Learn about Developers Group
Join Developers Group
Order SPAM Blocker
Free Stuff
Guest Book
.NET Resources
SQL Server Resources
Favorites
Technical Support
Books & DVDs by Webmaster
Articles, tutorials, & more
FAQs
Product Reviews
Samples
Prior Newsletters
Contact Us
Home
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

by Rick Dobson, Ph.D.

Who is it for?

This book targets professional Visual Basic and Visual Basic for Applications developers. From my seminar tours and Web sites, I know that these professionals are driven by a passion to deliver solutions to their clients through applying 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 systems and databases. Independent developers specialize in serving niche situations 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 wasting their time. This book strives to serve this broad need in two specific areas.

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 create 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’ll 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 presentation of these technologies demonstrates coding techniques and explores concepts that equip you to build better solutions with SQL Server 2000 databases. In addition, the book highlights innovations introduced through the Web releases for SQL Server 2000 that integrate SQL Server 2000 tightly 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 value from this book. If you have looked at any of the computer magazines over the past couple of years, 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’ll learn about XML documents, fragments, and formatting as well as related technologies, such as XPath (XML Path Language) queries, XSLT (Extensible Stylesheet Language Transformation), and WSDL (Web Services Description Language).