PREREQUISITES FOR THE SAMPLE CODE
=================================
In addition the the prerequisites listed in the opening section of the book, you will need to install SQLXML 3.0 for the project Main in the solution to compile. It can be downloaded from http://www.microsoft.com/downloads.


INSTALLING THE DATABASE
=======================
1. Extract the contents of the file AdoDotNetCookbookDB.zip to the C:\AdoDotNetCookbookDB directory.
2. Optionally, backup the Northwind database on your SQL Server. Alternatively, Northwind can be recreated to its original version using the script instnwnd.sql, usually found in the directory C:\Program Files\Microsoft SQL Server\MSSQL\Install.
3. The backup file AdoDotNetCookbook_Northwind.bak contains a version of Northwind with additional objects that are used in some samples. The Northwind data is identical to the default install of Northwind with one exception - the MS Access OLE image headers stored on the images in the Photo field of the Employees have been removed. Restore this file, replacing the Northwind table in your database.


INSTALLING THE C# Sample Code
=============================
1. Extract the contents of the file AdoDotNetCookbookCS.zip to the C:\AdoDotNetCookbookCS directory.
2. From the start menu, select Administrative Services -> Internet Information Services. Create a New Virtual Directory with the alias AdoDotNetCookbookCS_Web and directory C:\AdoDotNetCookbookCS\Web. Grant the default Read and Run scripts access permissions. Once the virtual directory is created, open the Properties page, select the Documents tab, Add a default document named "default.aspx", and move it to the top of the list using the up arrow to the left of the list box.
3. From the start menu, select Administrative Services -> Internet Information Services. Create a New Virtual Directory with the alias AdoDotNetCookbookCS_WebService and directory C:\AdoDotNetCookbookCS\WebService. Grant the default Read and Run scripts access permissions.
4. Using Explorer, right click the C:\AdoDotNetCookbookCS\Web directory and select Sharing and Security from the context menu. Add Read permissions for the Internet Guest Account (IUSR_<user name>) to the directory.
5. Using Explorer, right click the C:\AdoDotNetCookbookCS\WebServices directory and select Sharing and Security from the context menu. Add Read permissions for the Internet Guest Account (IUSR_<user name>) on the directory.
6. Open the solution file c:\AdoDotNetCookbookCS\AdoDotNetCookbookCS.sln using Visual Studio .NET 2003.


INSTALLING THE C# Sample Code
=============================
1. Extract the contents of the file AdoDotNetCookbookVB.zip to the C:\AdoDotNetCookbookVB directory.
2. From the start menu, select Administrative Services -> Internet Information Services. Create a New Virtual Directory with the alias AdoDotNetCookbookVB_Web and directory C:\AdoDotNetCookbookVB\Web. Grant the default Read and Run scripts access permissions. Once the virtual directory is created, open the Properties page, select the Documents tab, Add a default document named "default.aspx", and move it to the top of the list using the up arrow to the left of the list box.
3. From the start menu, select Administrative Services -> Internet Information Services. Create a New Virtual Directory with the alias AdoDotNetCookbookVB_WebService and directory C:\AdoDotNetCookbookVB\WebService. Grant the default Read and Run scripts access permissions.
4. Using Explorer, right click the C:\AdoDotNetCookbookVB\Web directory and select Sharing and Security from the context menu. Add Read permissions for the Internet Guest Account (IUSR_<user name>) to the directory.
5. Using Explorer, right click the C:\AdoDotNetCookbookVB\WebServices directory and select Sharing and Security from the context menu. Add Read permissions for the Internet Guest Account (IUSR_<user name>) on the directory.
6. Open the solution file c:\AdoDotNetCookbookVB\AdoDotNetCookbooVB.sln using Visual Studio .NET 2003.