ColdFusion --> XML --> VisualBasic .net application

[Silvano]

Hi all,

Here is scenario that I am thinking about:
I have a customer with a Site built in ColdFusion. The site is using Access database to store all the relevant info. ColdFusion is capable to query the database and output the query result in the XML format.

The next step is to build the Windows application in VisualBasic .net that would have to relate to the information that are stored in the Site's database.

question: how can i from the application get the XML packet that is created on the Web Server?

The application users do not have to be connected to the database all the time so if I can get the query results that are stored in the XML format to populate the dataset in the .net application, they will be able to work on it and just apply the changes when they are finished.

Is this scenario possible? Can someone give me some info I can use here?

Thanks in advance... Sylvano
dsylvano@hotmail.com

 

[link9]

The dataset object in ado.net is able to use a well formed xml document as its data source.

You implement this via the .readXML method of the dataset, so all the application needs is access to this xml document, and you're in business.

Conversely, when the application is through doing it's thing with the data, you can plop the xml right back out with the .writeXML method -- put it back on the server for the cfm routines to pick back up and update the database.

Here's a link for you on some strategies:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconxmldataset.asp

paul