I have a stored procedure that shows that data as an XML file as an example below. This data changes throughout the day a lot. I am wanting to get this to be a website so we can goto www.website.com/detainee.xml it it pulling the data each time someone visits
this site or even if it cachs the data for 20-30 mins is the update if that makes sense? What would be an easy way to accomplish this? Once I have once completed I will be able to figure out how to do the other's that we have to do
khoffhines
0 Points
1 Post
XML from Stored Procedure to a website
Jan 25, 2012 07:02 PM|LINK
I have a stored procedure that shows that data as an XML file as an example below. This data changes throughout the day a lot. I am wanting to get this to be a website so we can goto www.website.com/detainee.xml it it pulling the data each time someone visits this site or even if it cachs the data for 20-30 mins is the update if that makes sense? What would be an easy way to accomplish this? Once I have once completed I will be able to figure out how to do the other's that we have to do
thanks
<Detainee>
<BookNum>11-823</BookNum>
<FirstName>John</FirstName>
<LastName>Doe</LastName>
<Age>55 YRS</Age>
<Race>W</Race>
<Sex>M</Sex>
<ITime>2011-09-10</ITime>
</Detainee>
C
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: XML from Stored Procedure to a website
Jan 27, 2012 01:18 AM|LINK
Hello khoffhines：）
In my mind，I think you can just use catch to save the data contents for 20——30 minutes：
<%@ OutputCache Duration="30" VaryByParam="None" %>
This will catch the data contents for 30 minutes，after the period of time，it will refresh the page and get the new contents。
For more about catch，you can refer to：
http://msdn.microsoft.com/en-us/library/aa478965.aspx
C