How to access your MSSQL Data through template

How to access your MSSQL Data through template

Step 1

First of all we need to create our query statement in XML format. It looks like this.

SELECT *

FROM Employees

FOR XML AUTO

Step 2

Then save this file into the template that we have created above. Which is

C:\Inetpub\wwwroot\nwind\Template as File1.xml

Step 3

Then open up your browser and just run the file as a normal HTML file that you would run.

Step 4

Type the following in your browser address bar http://compact/northwind/Template/File1.xml

The output from browser look something similar to this.