473,320 Members | 1,883 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,320 software developers and data experts.

querying XML document

I'm trying to migrate from Access database data into XML
data, and i'm having a lot of confusion.

Before XML, in my ASP.NET page, i'd connect to a database,
query it (SELECT * IN whatever WHERE...), and then display
the results in something like a Datagrid. Very easy.

How can this be done if i'm using an XML file instead of a
database file? I know how to put the entire XML info into
a DataSet, and then display in a DataGrid, but i don't
want ALL the info in the XML file... i just want the
filtered (queried) data.

Am i supposed to use XSLT for this? Please someone show
me to the right direction!

Thanks!
John
Nov 11 '05 #1
3 1432
There are many things you can do including xslt.

you can just filter the dataset that contains the xml information.

it is not a best practice just to create and use everything in Xml just to
say you did it.

Is all the data in your site now in xml documents instread of a database of
some type?

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"John Buchmann" <or****@informatik.com> wrote in message
news:0f****************************@phx.gbl...
I'm trying to migrate from Access database data into XML
data, and i'm having a lot of confusion.

Before XML, in my ASP.NET page, i'd connect to a database,
query it (SELECT * IN whatever WHERE...), and then display
the results in something like a Datagrid. Very easy.

How can this be done if i'm using an XML file instead of a
database file? I know how to put the entire XML info into
a DataSet, and then display in a DataGrid, but i don't
want ALL the info in the XML file... i just want the
filtered (queried) data.

Am i supposed to use XSLT for this? Please someone show
me to the right direction!

Thanks!
John

Nov 11 '05 #2
Thanks for your reply!

I actually thought of filtering the dataset info, but it "seemed" to me
like a workaround solution. Do you think this is the best way? I'm
slowly learning XSLT, and it seems really complex, and alot of work for
doing something really simple, like in my example above.

I'm in the learning stages of XML right now, and all i really hope to do
is replace my Access database info with XML... just for stuff like
storing customer information, or contact info for mailing lists. So a
very simple XML file will work.

I got the impression that XML should be used as a datastore in almost
all situations... because of the huge hype over it. In what cases would
a regular database be preferable?

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 11 '05 #3
Xslt is going to add an extra step and will slow down the performance of the
action you are trying to perform.

Xml documents will start to have performance issues as they get larger where
a database will not have as great of a problem.

it should be used as a datastore depending on what you are going to do with
it, like xslt or serialize it over a web service.

but just to use xml to say you are using it is not always a good thing.

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"John Buchmann" <an*******@devdex.com> wrote in message
news:O4**************@TK2MSFTNGP11.phx.gbl...
Thanks for your reply!

I actually thought of filtering the dataset info, but it "seemed" to me
like a workaround solution. Do you think this is the best way? I'm
slowly learning XSLT, and it seems really complex, and alot of work for
doing something really simple, like in my example above.

I'm in the learning stages of XML right now, and all i really hope to do
is replace my Access database info with XML... just for stuff like
storing customer information, or contact info for mailing lists. So a
very simple XML file will work.

I got the impression that XML should be used as a datastore in almost
all situations... because of the huge hype over it. In what cases would
a regular database be preferable?

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 11 '05 #4

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

Similar topics

4
by: VJ | last post by:
Hello All, The xml document below describes the contents of a folder in a Document Managment System. I need to retrieve the DocId for the most recently added (<Add_Date>) spreadsheet file(<name>...
1
by: Hakan Akkas | last post by:
Hello all, I need to build a search engine wherewith users can query huge Xml Documents (+/- 100 MB) in a user friendly way. The searcher shouldn't be aware of the underlying structure of the...
1
by: Markus | last post by:
Hi, I am trying to query the value of a textfield outside of a form but with no success so far... the reason why I am not using a form is that there seams to be an annoying issue with hitting...
2
by: Richard L Rosenheim | last post by:
I have the following XML document, loaded in MyDoc (declared as XML.XMLDocument): <configuration> <appSettings> <add key="LastUpdate" value="9/3/2003" /> </appSettings> </configuration> ...
6
by: Greg | last post by:
I am working on a project that will have about 500,000 records in an XML document. This document will need to be queried with XPath, and records will need to be updated. I was thinking about...
5
by: Shane | last post by:
I wonder if someone has any ideas about the following. I am currently producing some reports for a manufacturing company who work with metal. A finished part can contain multiple sub-parts to...
0
by: zhuang | last post by:
Hi, There are some articles online showing how to do this. But my scenario is different, and I could not figure out how to do it at design level. I developed a web application, which will be...
5
by: sql_er | last post by:
Guys, I have an XML file which is 233MB in size. It was created by loading 6 tables from an sql server database into a dataset object and then writing out the contents from this dataset into an...
1
by: pavan.madireddy | last post by:
Hi, My name is pavan kumar. I am working as a software engineer. I have a doubt in XQL (XML Querying). I want to retrive the data from an XML Document. So that i have to use XQL. I know how to...
2
by: RajSharma | last post by:
Hi, I am facing a problem regarding querying thru a large table having millions of rows....... Its hanging in between while querying for all those rows Can anybody suggest me a query regarding :...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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.