473,326 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

XML Centric application advice

Hi,

I'm attempting to write a web application that helps us keep track of
our PC fleet. Data on our PC's is collected by a 3rd party application
that outputs XML.
I want to load this data into Sql Server, and allow people to query it
via a web application.

My previous experience in this kind of this is using PHP and Oracle,
but now that I've moved to .Net, I want to do things the right way.

After making a few false starts, I've used the xsd inference tools to
generate a C# class that can de-serialize the XML documents.
From there I've manually created an SQL Server database, schema and

some t-sql procedures to load the data. Now that i'm coming to retrieve
the data I've realised that this was a bit cumbersome.

Can anyone let me know if the following makes sense.

--------

1. Use XSLT to convert the basic XML into a format that more accurately
reflects how I need to use the data.
2. Generate an ADO.NET dataset for these new XML documents.
3. Somehow create an SQL db schema that maps to my new DataSet file.
4. Load XML->XSLT->ADO.NET DataSet->SQL Database
5. Return AD0.NET DataSet that matches Web Query
6. Display in a custom ascx control.

Assuming that process makes sence, I know what needs to be done for
steps 1, 2 and 6.

For step 3, what tool can be used to take an ADO.NET Dataset and create
a matching set of SQL tables?

Step 4, I should be ok... but if there are any examples people can
point me at...

Step 5. Assuming that a SQL persisted dataset has a PK of some kind,
how do i retrieve all the data from that?
Thanks for any help at all.

Peter Bates

Nov 12 '05 #1
0 828

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Meh-Lit Kim | last post by:
Hi All, I'd like to use SOAP 1.2 messaging in a document-centric fashion. Does anyone know - 1. What to do to validate an incoming SOAP message ? Do people write an XML schema for their...
1
by: bogachkov | last post by:
Hello Joe Over the past several years, I have found your responses to jdbc usage/driver related issues to be extremely helpful. I am sure that you're very busy so I will make my question as...
5
by: Loane Sharp | last post by:
Hi there I've got a hang of a problem ... I'm running the .NET framework (2.0.40903), SQL Server 2000 and SQL Express 2005 on Windows XP Pro on a pretty good and new IBM Thinkpad X41. Some...
0
by: CodeMonkey | last post by:
Hi, I was wondering if anybody could give me some advice on how to structure an application that I am about to start work on. The vague requirements will be: 1) Always-On monitoring of data...
2
by: Mr Newbie | last post by:
I've just spent some considerable time putting together an application which works pretty much OK. The issue I have around design is mainly concerned with the Data Access layer. Yes, we can pull...
5
by: David Moskowitz | last post by:
Infoblazer LLC is pleased to release the XX Framework under the LGPL open source license. Version 1.0 is available for immediate download. The XX framework is a configurable, XML-centric...
0
by: Kenneth Downs | last post by:
Hello, Secure Data Software is announcing that our GPL'd database-centric PHP framework has gone into beta. It is available for download now from the main project site at: ...
0
by: Suresh.Eddala | last post by:
Hi, I am trying to do Form validation on client side by using atlas client-centric script. Grouping all the field validation by using "validationGroup" and on button click event checking the...
1
by: darrel | last post by:
Can anyone recommend a course/class/training event that focuses on OOP concepts in the context of ASP.net? My background: My education is in art/graphic design. Later spending most of my time...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.