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...

Enterprise Services Checklist

Here is a quick and dirty checklist for building the WeddingList assembly to leverage Enterprise Services. The checklist effectively summarizes what you have already done. Use this checklist for future reference when creating new Serviced Components 1. Create a new class library project. 2. Add the appropriate classes and methods. 3. Organize your code using Regions 5. Region Business Level Logic 7. Public Function MyFunction As DataSet 13. Organize code in the middle tier to perform these...

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...