Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
|
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 10th, 2006, 06:44 PM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default XML integration

People
Iam a new in XMl but i have a problem and i think the XML is the solution.
Scenario 1:
A web site with a webform.asp whos write the forms fields into a xxxx.xml file where xxxx=name of file

scenario 2:
my local(intranet) webserver where have an asp page whos read the xxxx.xml in my website(www) and put/convert all datas in xml file and update datas into my SQl-table.

workflow of scenario 1:
(mywebsite)
form.html=>script.asp=>xxxx.xml
a form.html is filled by a user then a srcript.asp put the informations into the xxxx.xml file

workflow of scenario 2:
script.asp==>read xxx.xml and create a dataset then update my SQL-table

how to doit?
anyone knows an article who could show me it?

other scenario i need is: another script.asp reads my sql-table and fill another yyy.xml in mywebsite file to return informations from my local database to webuser.

at this time iam studing about soap ithink it will be very helpfull.

regards

Clovis Rolemberg


Rolemberg Jr.
 
Old May 11th, 2006, 02:41 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

As you're using ASP then it's fairly straightforward to read the form's variables and save them to a local drive on the server using msxml (use version 4 or greater if possible).

Your intranet page can then load the file, again using msxml, and send it to a database, either semi-directly, if your database has reasonable XML support, or after extracting the data and constructing suitable SQL.

If you're using SQL Server search for OPENXML on msdn.com for the SQL part, there are dozens of examples on this forum for the first part, search for msxml, asp etc.



--

Joe (Microsoft MVP - XML)
 
Old May 11th, 2006, 06:46 PM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok
I will study it

Thank you for the tip

At this time, I am studing ASPNET in a official MS course here in brazil

regards

Clovis Rolemberg

Rolemberg Jr.





Similar Threads
Thread Thread Starter Forum Replies Last Post
HL7 integration with C# Sudheer C# 3 August 29th, 2012 02:42 PM
PayPal Integration takwirira ASP.NET 2.0 Basics 0 May 12th, 2008 05:44 AM
Quickbook integration baburman ASP.NET 2.0 Professional 0 December 9th, 2007 05:25 AM
ASP and XML integration k00k Classic ASP XML 0 June 10th, 2006 02:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.