Unsure on XML/ASP.net project

[talon121a]

Ok this is what im tryin to accomplish..

Can someone help me with a process I should develop?? Im not sure how to efficiently make this app.

1. Need to obtain remote XML data (ie. from a website/file.xml)

2. Have it update an SQL db, when it changes. ie. When it detects a file change, itll insert new record in SQL. (For example being able to then run queries or writing an application for web).

.... Any ideas how I should go about this perhaps references to any materials..



--------
Jason Burton
Leximedia,LLC.
jab@leximedia.net
(im confident with my spam fighting solution)

 

[vbkris]

obtaning an XML file is easy, u could use the
HttpWebRequest object.

once u get the XML string u can use the XMLDocument Object.
after that it will be easy to make changes in the SQL server database.

the problem is in detecting the change in the XML file and then trying to execute your ASPX file. to do that would be virtually impossible (as its on a different server, even in the same server will be a problem).

you may have to use Windows Tasks or SQL Jobs...

Known is handfull, Unknown is worldfull

 

[talon121a]

Are you aware of an SQL 2000 method? ie. a job I can run?

Ive decided to use wget. to get the xml,

Now Im tryin to figure out how to import the XML into table format (sql). (the particular node..)

XML source:

http://www.virtualatc.net:8080/xml

--------
Jason Burton
Leximedia,LLC.
jab@leximedia.net
(im confident with my spam fighting solution)

 

[vbkris]

>>Are you aware of an SQL 2000 method? ie. a job I can run?

jobs are something like stored procedures. they can be created. They can be created using the "Management -> SQL Server Agent" tool...

Known is handfull, Unknown is worldfull

 

[talon121a]

yea, Im aware it exists. But do you know of any method, I can run to import the data... I have the file downloaded now, just tryin to figure out how to convert the XML data to SQL data. ---

I decided to use wget. Then just schedule it..



--------
Jason Burton
Leximedia,LLC.
jab@leximedia.net
(im confident with my spam fighting solution)

 

[vbkris]

lots of way to read the XML data, the best method would be to use the XMLDocument() object...

Known is handfull, Unknown is worldfull