Last post Jun 03, 2008 03:31 PM by Mikesdotnetting
Jun 02, 2008 08:14 PM|darrenfaulk|LINK
I am using MS Access as the database for a project that displays written articles. What I would like to do is create a dynamic RSS feed from the access database that lists the 10 most recently added articles. I have tried to adapt the many tutorials their
are for syndicating web content using sql, but I can't find a single tutorial for using ADO.net and MS Access databases. The more specific the example or explanation the better, as this is the first time I am trying to syndicate database content.
Please let me know if you can help or have any links to a tutorial I missed. Below are links to a couple of the (seemingly popular) sql tutorials for doing the same project:
Jun 02, 2008 11:27 PM|whighfield|LINK
Here is a
tutorial for Access
Jun 03, 2008 03:07 PM|darrenfaulk|LINK
Thanks for the fast response whighfield. I actually came across that tutorial before, but I received the error in connecting to the online database and I'm not sure if using a .ashx page is the solution. What is the advantage/difference between using an
xml file and an ashx file?
I would ideally like to create an rss.xml file programatically that pulls the 10 most recent articles. How would I go about doing this?
Jun 03, 2008 03:31 PM|Mikesdotnetting|LINK
I received the error in connecting to the online database and I'm not sure if using a .ashx page is the solution
What the code in the sample does is pull the ten most recent items out of the database then create an xml file containing them. It's just what you appear to be after. Posting the error here so that we can pick over it is the solution.