Special Edition Using Microsoft® SharePoint Portal Server

Employee Locator Web Part (Version 3)

In the first version of the Employee Locator Web Part, you saw how we can retrieve data from a SQL Server database, save it in an offline form in an XML file, and transform it into an HTML format using an XSL file.

In the second version, we used the same approach for representing employee information, but with real-time access to the SQL Server database using an ADO stream object.

Both versions showed how the data is separated from the interface, which makes the code much easier to follow and more reusable. As you saw in the second version, we changed the logic of data retrieval without changing the XSL file that is responsible for reformatting XML into HTML. In spite of the separation of data and the interface, ...