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.

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)

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.