473,326 Members | 2,110 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.

Querying XML Files

Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman
Nov 19 '05 #1
12 1278
XQuery?

"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end
to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman

Nov 19 '05 #2
Onin is XQUERY still supported
Asking because i went to the site http://xqueryservices.com/ and nothing
came uo.
What is microsoft doing with Xquery?
Patrick
"Onin Tayson" <Le*********@compaid.com> wrote in message
news:ua**************@tk2msftngp13.phx.gbl...
XQuery?

"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end
to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman


Nov 19 '05 #3
Hi,

I believe it is (it will be W3C a standard -
http://www.w3schools.com/xquery/xquery_intro.asp)

Here's to get you started using XQuery:
http://www.w3schools.com/xquery/

HTH,

"Patirck Ige" <na********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Onin is XQUERY still supported
Asking because i went to the site http://xqueryservices.com/ and nothing
came uo.
What is microsoft doing with Xquery?
Patrick
"Onin Tayson" <Le*********@compaid.com> wrote in message
news:ua**************@tk2msftngp13.phx.gbl...
XQuery?

"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
> Hello!
>
> I have one issue that I am trying to work out.
>
> I am creating an RSS XML feed. However, I want the user at the other
> end
> to
> be able to query the XML file, for example, display only records for a
> particular room. This would be similar to 'where room_id = 12'.
>
> Is there an easy way to do this?
>
> Thank you very much!
>
> -Bahman



Nov 19 '05 #4
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end
to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman

Nov 19 '05 #5
Ken hm...the ADO.NET XML Provider -- WilsonXmlDbClient v1.0 must be GREAT
I'm doing some stuuf on it right away..
By the way i tried the sample code you pasted in your blog but i get error
at:-
xmldbda.Fill(ds)
"Object reference not set to an instance of an object. "
Any ideas
"Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
news:er**************@TK2MSFTNGP10.phx.gbl...
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end
to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman


Nov 19 '05 #6
All good Ken
I was missing somethng..
Will explore more of it.
Patrick
** Nice stuff to query XML

"Patirck Ige" <na********@hotmail.com> wrote in message
news:eY**************@TK2MSFTNGP10.phx.gbl...
Ken hm...the ADO.NET XML Provider -- WilsonXmlDbClient v1.0 must be GREAT
I'm doing some stuuf on it right away..
By the way i tried the sample code you pasted in your blog but i get error
at:-
xmldbda.Fill(ds)
"Object reference not set to an instance of an object. "
Any ideas
"Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
news:er**************@TK2MSFTNGP10.phx.gbl...
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman



Nov 19 '05 #7
Ken if i would like to Query and xml file like (Will it be possible to use
the WilsonXmlDbClient ) :-
<?xml version="1.0" encoding="utf-8"?>
<TREENODES>
<TreeNode Text="Human Resources">
<TreeNode Text="Add Employee" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="Forms">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
<TreeNode Text="Rosters">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
</TREENODES>
This is the XML structure a Treeview Webcontrol Menu uses and i have wanted
to have the
easiest way to manage it.This XML above is a simple structure but they grow
more complicated
when you have 5 nodes or more under a main NODE.
I don't want to query the database because the Nodes are growing and that
means the
Treeview menu when loading will be very slow.
Also i was thinking of passing XML strings to the TREENODESRC but i can't
imagine how long that would be.
If its possible what i want is have a Whole bunch of the XML file that
contains the whole links and then query it and pass it to the right
pages based on Roles from the Active Directory
Any ideas?
Patrick



"Patirck Ige" <na********@hotmail.com> wrote in message
news:eI*************@TK2MSFTNGP10.phx.gbl...
All good Ken
I was missing somethng..
Will explore more of it.
Patrick
** Nice stuff to query XML

"Patirck Ige" <na********@hotmail.com> wrote in message
news:eY**************@TK2MSFTNGP10.phx.gbl...
Ken hm...the ADO.NET XML Provider -- WilsonXmlDbClient v1.0 must be GREAT
I'm doing some stuuf on it right away..
By the way i tried the sample code you pasted in your blog but i get error at:-
xmldbda.Fill(ds)
"Object reference not set to an instance of an object. "
Any ideas
"Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
news:er**************@TK2MSFTNGP10.phx.gbl...
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
> Hello!
>
> I have one issue that I am trying to work out.
>
> I am creating an RSS XML feed. However, I want the user at the other

end > to
> be able to query the XML file, for example, display only records for a > particular room. This would be similar to 'where room_id = 12'.
>
> Is there an easy way to do this?
>
> Thank you very much!
>
> -Bahman



Nov 19 '05 #8
Hi Patrick,

You've gone beyond my limited knowledge of WilsonXmlDbClient. Best to ask
the author how to query that type of data.

BTW, you name is misspelled in your header (Patirck)

Ken

"Patirck Ige" <na********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Ken if i would like to Query and xml file like (Will it be possible to use
the WilsonXmlDbClient ) :-
<?xml version="1.0" encoding="utf-8"?>
<TREENODES>
<TreeNode Text="Human Resources">
<TreeNode Text="Add Employee" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="Forms">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
<TreeNode Text="Rosters">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
</TREENODES>
This is the XML structure a Treeview Webcontrol Menu uses and i have
wanted
to have the
easiest way to manage it.This XML above is a simple structure but they
grow
more complicated
when you have 5 nodes or more under a main NODE.
I don't want to query the database because the Nodes are growing and that
means the
Treeview menu when loading will be very slow.
Also i was thinking of passing XML strings to the TREENODESRC but i can't
imagine how long that would be.
If its possible what i want is have a Whole bunch of the XML file that
contains the whole links and then query it and pass it to the right
pages based on Roles from the Active Directory
Any ideas?
Patrick



"Patirck Ige" <na********@hotmail.com> wrote in message
news:eI*************@TK2MSFTNGP10.phx.gbl...
All good Ken
I was missing somethng..
Will explore more of it.
Patrick
** Nice stuff to query XML

"Patirck Ige" <na********@hotmail.com> wrote in message
news:eY**************@TK2MSFTNGP10.phx.gbl...
> Ken hm...the ADO.NET XML Provider -- WilsonXmlDbClient v1.0 must be GREAT > I'm doing some stuuf on it right away..
> By the way i tried the sample code you pasted in your blog but i get error > at:-
> xmldbda.Fill(ds)
> "Object reference not set to an instance of an object. "
> Any ideas
>
>
> "Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
> news:er**************@TK2MSFTNGP10.phx.gbl...
> > Hi Bahman,
> >
> > If you know SQL and want an easy way to query XML, check out
> > WilsonXmlDbClient. I wrote about it recently on my blog:
> >
> > http://weblogs.asp.net/kencox/archiv...04/426600.aspx
> >
> > Ken
> > Microsoft MVP [ASP.NET]
> >
> >
> > "Bahman" <Ba****@discussions.microsoft.com> wrote in message
> > news:73**********************************@microsof t.com...
> > > Hello!
> > >
> > > I have one issue that I am trying to work out.
> > >
> > > I am creating an RSS XML feed. However, I want the user at the
> > > other

end
> > > to
> > > be able to query the XML file, for example, display only records
> > > for a > > > particular room. This would be similar to 'where room_id = 12'.
> > >
> > > Is there an easy way to do this?
> > >
> > > Thank you very much!
> > >
> > > -Bahman
> >
> >
>
>



Nov 19 '05 #9
Ken,

This is great.

One question:

How do I install and reference the dll on the web server?

I don't have any tools with me. Just a web server. So this would need to be
a C# implementation. Somehow I have the feeling this is not how it is
intended to work.

If not, where do I go from here?

Thank you very much!

-Bahman

"Ken Cox [Microsoft MVP]" wrote:
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
Hello!

I have one issue that I am trying to work out.

I am creating an RSS XML feed. However, I want the user at the other end
to
be able to query the XML file, for example, display only records for a
particular room. This would be similar to 'where room_id = 12'.

Is there an easy way to do this?

Thank you very much!

-Bahman


Nov 19 '05 #10
Hi Bahman,

Just get or build the binary (dll) and put it in your Web's /bin directory.
The language (C# or VB) shouldn't make a difference as long as the DLL can
be found.

Ken
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:E6**********************************@microsof t.com...
Ken,

This is great.

One question:

How do I install and reference the dll on the web server?

I don't have any tools with me. Just a web server. So this would need to
be
a C# implementation. Somehow I have the feeling this is not how it is
intended to work.

If not, where do I go from here?

Thank you very much!

-Bahman

"Ken Cox [Microsoft MVP]" wrote:
Hi Bahman,

If you know SQL and want an easy way to query XML, check out
WilsonXmlDbClient. I wrote about it recently on my blog:

http://weblogs.asp.net/kencox/archiv...04/426600.aspx

Ken
Microsoft MVP [ASP.NET]
"Bahman" <Ba****@discussions.microsoft.com> wrote in message
news:73**********************************@microsof t.com...
> Hello!
>
> I have one issue that I am trying to work out.
>
> I am creating an RSS XML feed. However, I want the user at the other
> end
> to
> be able to query the XML file, for example, display only records for a
> particular room. This would be similar to 'where room_id = 12'.
>
> Is there an easy way to do this?
>
> Thank you very much!
>
> -Bahman


Nov 19 '05 #11
I will contact Paul then.
And thx for the misspelled name but at the same time the name looks more
interesting.
Patrick alias Patirck:)

"Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
news:eS**************@TK2MSFTNGP12.phx.gbl...
Hi Patrick,

You've gone beyond my limited knowledge of WilsonXmlDbClient. Best to ask
the author how to query that type of data.

BTW, you name is misspelled in your header (Patirck)

Ken

"Patirck Ige" <na********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Ken if i would like to Query and xml file like (Will it be possible to use the WilsonXmlDbClient ) :-
<?xml version="1.0" encoding="utf-8"?>
<TREENODES>
<TreeNode Text="Human Resources">
<TreeNode Text="Add Employee" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="Forms">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
<TreeNode Text="Rosters">
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
<TreeNode Text="" NavigateUrl="a.aspx" target=""/>
</TreeNode>
</TREENODES>
This is the XML structure a Treeview Webcontrol Menu uses and i have
wanted
to have the
easiest way to manage it.This XML above is a simple structure but they
grow
more complicated
when you have 5 nodes or more under a main NODE.
I don't want to query the database because the Nodes are growing and that means the
Treeview menu when loading will be very slow.
Also i was thinking of passing XML strings to the TREENODESRC but i can't imagine how long that would be.
If its possible what i want is have a Whole bunch of the XML file that
contains the whole links and then query it and pass it to the right
pages based on Roles from the Active Directory
Any ideas?
Patrick



"Patirck Ige" <na********@hotmail.com> wrote in message
news:eI*************@TK2MSFTNGP10.phx.gbl...
All good Ken
I was missing somethng..
Will explore more of it.
Patrick
** Nice stuff to query XML

"Patirck Ige" <na********@hotmail.com> wrote in message
news:eY**************@TK2MSFTNGP10.phx.gbl...
> Ken hm...the ADO.NET XML Provider -- WilsonXmlDbClient v1.0 must be

GREAT
> I'm doing some stuuf on it right away..
> By the way i tried the sample code you pasted in your blog but i get

error
> at:-
> xmldbda.Fill(ds)
> "Object reference not set to an instance of an object. "
> Any ideas
>
>
> "Ken Cox [Microsoft MVP]" <BA**********@hotmail.com> wrote in message
> news:er**************@TK2MSFTNGP10.phx.gbl...
> > Hi Bahman,
> >
> > If you know SQL and want an easy way to query XML, check out
> > WilsonXmlDbClient. I wrote about it recently on my blog:
> >
> > http://weblogs.asp.net/kencox/archiv...04/426600.aspx
> >
> > Ken
> > Microsoft MVP [ASP.NET]
> >
> >
> > "Bahman" <Ba****@discussions.microsoft.com> wrote in message
> > news:73**********************************@microsof t.com...
> > > Hello!
> > >
> > > I have one issue that I am trying to work out.
> > >
> > > I am creating an RSS XML feed. However, I want the user at the
> > > other
end
> > > to
> > > be able to query the XML file, for example, display only records
> > > for

a
> > > particular room. This would be similar to 'where room_id = 12'.
> > >
> > > Is there an easy way to do this?
> > >
> > > Thank you very much!
> > >
> > > -Bahman
> >
> >
>
>



Nov 19 '05 #12
Yes, Patirck really catches the eye!

"Patrick.O.Ige" <pa********@optusnet.com.au> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
I will contact Paul then.
And thx for the misspelled name but at the same time the name looks more
interesting.
Patrick alias Patirck:)

Nov 19 '05 #13

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

Similar topics

4
by: Matt Young | last post by:
I've been tasked with integrating an older management system based on DBF files with my snappy new ASP application to provide users of the ASP application with real-time data from the management...
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...
3
by: MDB | last post by:
I'd normally Google for a question like this, and hope to snag a few examples along with the answer, but this time I can't see to get the keywords specific enough. Or I'd ask coworkers, but...
3
by: Mikolaj Machowski | last post by:
Hello, I am looking for tool to query Schema/RNG files to find: - all elements of current dialect - allowed children of given element - allowed attributes of given element - values of that...
0
by: Phil Latio | last post by:
OT as this question relates to MSQuery, which maybe the people here could answer - they often know alot more than just Access :) I have a few Excel spreadsheets set up which use MSQuery to...
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...
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: ranganadh | last post by:
Dear Group members, I am new to LINQ, pls help on the deeling with huge amount of data with the C# stand Alone application. I have two file, which contains more then 2 lacs lines in every...
4
by: =?Utf-8?B?U3VoYXMgVmVuZ2lsYXQ=?= | last post by:
Hello, I am facing an issue while querying Active directory using C# code with system.DirectoryServices namespace. Here is the path for my LDAP - "LDAP://CN=XY - C++/Unix and other,...
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...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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.