Web Services

Web services, as discussed in Chapter 2, Evolution of the Tier Development, provide a way of exposing remote methods. These methods provide programming logic with access to other assemblies and data. Web services also fit nicely into the .NET architecture by introducing loosely connected components. Web services offer a variety of advantages over classic COM development. For one, they take advantage of XML and HTTP to provide a method for creating distributed applications that can pass through...

Creating the Supporting Stored Procedures

You'll implement data access through SQL Server stored procedures to improve performance and to add XML support. You'll pass all of the stored procedure parameters in a single XML string. This will allow the application to process multiple data requests significantly faster because a single call can now perform the same work that once required multiple database calls. Also, your dependency on interface compatibility in the component layers is significantly reduced when adding and removing...

Brief History of COM

Component technologies have developed significantly over the last decade. Microsoft first introduced componentized code in components described as providing a service called OLE (Object Linking and Embedding) that quickly became COM. For awhile everything seemed to be COM until the technology matured and Microsoft marketing renamed COM to ActiveX. Then, of course, everything became ActiveX but we all know this is still the same old COM, so for the remainder of this chapter we will refer to...

Quick Watch Dialog

The QuickWatch window Figure 5-11 works closely with the Watch window. This dialog allows you to take a quick look at variables rather than adding them to the Watch window then later having to remove them. Figure 5-11 The QuickWatch dialog box. Figure 5-11 The QuickWatch dialog box. Before committing to using any variable in the Watch window, you can right-click the variable and select QuickWatch. From here, you can quickly evaluate the variable value, then decide whether or not to add it to...

Building a Data Set Table from Excel

Place the following code behind the btnBuildDataSetFromExcel click event. This will access your Excel document as if it were a database and populate the DataSet. From that point, the client application has no idea where the data came from, only that is exists in a format it understands. You will need to change the path to the Excel document to the path of your Excel document. Dim objConnection As OleDb.OleDbConnection Dim objCmd As OleDb.OleDbCommand Dim objDataAdapter As OleDb.OleDbDataAdapter...

NET Class Framework

The .NET Class Framework, also referred to as the .NET Base Classes, is a set of object models that provides easy access to base functionality thought a common namespace. All objects in this framework are accessible to all .NET languages. The .NET Class Framework provides a variety of base services divided among a variety of second-level namespaces under the System namespace. These second-level namespaces include base services such as data access, security, collections, XML, error handling, and...