Create and Update Web Services Using VB .NET and ADO.NET

摘要

Without a doubt, .NET Web services are the most talked about topic these days. This article shows you how to use VB.NET Web services and ADO.NET DataSets to pass data between client and server applications to build truly disconnected applications. I'll show you how to do this by creating a Web service in VB.NET for updating a database from a remote application. To keep things simple in this article, I use the .NET console application as the client. This lets you build a remote update data service with minimal code. Figure 1 shows this article's example application scenario. Use VB.NET to create a Web service that runs on a Web server connected to PUBS database. The PUBS database is installed as a sample database with SQL Server. The purpose of this Web service is to provide two public Web methods: GetAu-thors and UpdateAuthors. As the name suggests, GetAuthors queries the PUBS database's Authors table to return all the authors in the form of an ADO.NET DataSet. Although GetAuthors provides helpful functionality, it's simple and doesn't offer any transactional capabilities.