By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

need XML help with nested tables

P: n/a
(I posted this in ADO group, but I think this group will be better)

Hi-

I need to develop an FAQ section for our website. We would like to break up
the FAQ by products, then categories with each category having n
question/answer pairs.
I would like to pass parameters in the querystring based on what the
product/category the user selected, then populate a datagrid with the
correct set of question/answer

I am pretty new to XML, but basically I made something like this:
<products>
<product>
<name>prod1</name>
<partNum>prod1</partNum>
<categories>
<category>
<name>basic category</name>
<faqs>
<faq>
<question>This is a sample question</question>
<answer>this is the answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
<product>
<name>prod2</name>
<partNum>prod2</partNum>
<categories>
<category>
<name>basic something or something category</name>
<faqs>
<faq>
<question>This is another question</question>
<answer>and this is another answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
</products>

So, then I use a DataSet and the ReadXML() method, this result in 5 tables.
I was hoping that it would somehow be nested for me, but the way it is right
now I can't see an easy way to use it the way I want.

the first table lists the products(good)
the second table I can't really tell what is in there
third tables has all the categories, so on and so on.

What is confusing is... what is the point of structuring data hierarchically
in XML file if you can't maintain it? I'm sure you can, but how? Is what
I'm doing not common?

Someone please shed a little light on this for me, I would appreciate it!!

Thanks,
Steve
Nov 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Create a dataset with datarelations between the tables you want
nested. Set the Nested property prior to writing the xml:

ds.Relations["relationName"].Nested = true;

-- Mary
MCW Technologies
http://www.mcwtech.com

On Thu, 4 Dec 2003 16:44:58 -0800, "Steve Klett"
<sk************@yahoo.com> wrote:
(I posted this in ADO group, but I think this group will be better)

Hi-

I need to develop an FAQ section for our website. We would like to break up
the FAQ by products, then categories with each category having n
question/answer pairs.
I would like to pass parameters in the querystring based on what the
product/category the user selected, then populate a datagrid with the
correct set of question/answer

I am pretty new to XML, but basically I made something like this:
<products>
<product>
<name>prod1</name>
<partNum>prod1</partNum>
<categories>
<category>
<name>basic category</name>
<faqs>
<faq>
<question>This is a sample question</question>
<answer>this is the answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
<product>
<name>prod2</name>
<partNum>prod2</partNum>
<categories>
<category>
<name>basic something or something category</name>
<faqs>
<faq>
<question>This is another question</question>
<answer>and this is another answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
</products>

So, then I use a DataSet and the ReadXML() method, this result in 5 tables.
I was hoping that it would somehow be nested for me, but the way it is right
now I can't see an easy way to use it the way I want.

the first table lists the products(good)
the second table I can't really tell what is in there
third tables has all the categories, so on and so on.

What is confusing is... what is the point of structuring data hierarchically
in XML file if you can't maintain it? I'm sure you can, but how? Is what
I'm doing not common?

Someone please shed a little light on this for me, I would appreciate it!!

Thanks,
Steve


Nov 18 '05 #2

P: n/a
Hi Mary, thanks for the response.

So I would setup the relationions prior to reading teh XML, correct? Have
you ever seen any examples of this?

Thanks again,
Steve


"Mary Chipman" <mc***@nomail.please> wrote in message
news:qh********************************@4ax.com...
Create a dataset with datarelations between the tables you want
nested. Set the Nested property prior to writing the xml:

ds.Relations["relationName"].Nested = true;

-- Mary
MCW Technologies
http://www.mcwtech.com

On Thu, 4 Dec 2003 16:44:58 -0800, "Steve Klett"
<sk************@yahoo.com> wrote:
(I posted this in ADO group, but I think this group will be better)

Hi-

I need to develop an FAQ section for our website. We would like to break upthe FAQ by products, then categories with each category having n
question/answer pairs.
I would like to pass parameters in the querystring based on what the
product/category the user selected, then populate a datagrid with the
correct set of question/answer

I am pretty new to XML, but basically I made something like this:
<products>
<product>
<name>prod1</name>
<partNum>prod1</partNum>
<categories>
<category>
<name>basic category</name>
<faqs>
<faq>
<question>This is a sample question</question>
<answer>this is the answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
<product>
<name>prod2</name>
<partNum>prod2</partNum>
<categories>
<category>
<name>basic something or something category</name>
<faqs>
<faq>
<question>This is another question</question>
<answer>and this is another answer</answer>
</faq>
</faqs>
</category>
</categories>
</product>
</products>

So, then I use a DataSet and the ReadXML() method, this result in 5 tables.I was hoping that it would somehow be nested for me, but the way it is rightnow I can't see an easy way to use it the way I want.

the first table lists the products(good)
the second table I can't really tell what is in there
third tables has all the categories, so on and so on.

What is confusing is... what is the point of structuring data hierarchicallyin XML file if you can't maintain it? I'm sure you can, but how? Is whatI'm doing not common?

Someone please shed a little light on this for me, I would appreciate it!!
Thanks,
Steve

Nov 18 '05 #3

P: n/a
Once you add the data to a dataset you can then set the DataRelations
between the different DataTables. There's examples in online help --
see the topic "Adding a Relationship between Tables". Gotdotnet.com
probably has other examples or tutorials as well. Then once you've set
up the relations, you can then set the nested property to true.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 8 Dec 2003 09:53:32 -0800, "neverstill"
<sk************@yahoo.com> wrote:
Hi Mary, thanks for the response.

So I would setup the relationions prior to reading teh XML, correct? Have
you ever seen any examples of this?

Thanks again,
Steve


"Mary Chipman" <mc***@nomail.please> wrote in message
news:qh********************************@4ax.com.. .
Create a dataset with datarelations between the tables you want
nested. Set the Nested property prior to writing the xml:

ds.Relations["relationName"].Nested = true;

-- Mary
MCW Technologies
http://www.mcwtech.com

On Thu, 4 Dec 2003 16:44:58 -0800, "Steve Klett"
<sk************@yahoo.com> wrote:
>(I posted this in ADO group, but I think this group will be better)
>
>Hi-
>
>I need to develop an FAQ section for our website. We would like to breakup >the FAQ by products, then categories with each category having n
>question/answer pairs.
>I would like to pass parameters in the querystring based on what the
>product/category the user selected, then populate a datagrid with the
>correct set of question/answer
>
>I am pretty new to XML, but basically I made something like this:
><products>
> <product>
> <name>prod1</name>
> <partNum>prod1</partNum>
> <categories>
> <category>
> <name>basic category</name>
> <faqs>
> <faq>
> <question>This is a sample question</question>
> <answer>this is the answer</answer>
> </faq>
> </faqs>
> </category>
> </categories>
> </product>
> <product>
> <name>prod2</name>
> <partNum>prod2</partNum>
> <categories>
> <category>
> <name>basic something or something category</name>
> <faqs>
> <faq>
> <question>This is another question</question>
> <answer>and this is another answer</answer>
> </faq>
> </faqs>
> </category>
> </categories>
> </product>
></products>
>
>
>
>So, then I use a DataSet and the ReadXML() method, this result in 5tables. >I was hoping that it would somehow be nested for me, but the way it isright >now I can't see an easy way to use it the way I want.
>
>the first table lists the products(good)
>the second table I can't really tell what is in there
>third tables has all the categories, so on and so on.
>
>What is confusing is... what is the point of structuring datahierarchically >in XML file if you can't maintain it? I'm sure you can, but how? Iswhat >I'm doing not common?
>
>Someone please shed a little light on this for me, I would appreciateit!! >
>Thanks,
>Steve
>


Nov 18 '05 #4

P: n/a
great, thanks Mary!
"Mary Chipman" <mc***@nomail.please> wrote in message
news:4v********************************@4ax.com...
Once you add the data to a dataset you can then set the DataRelations
between the different DataTables. There's examples in online help --
see the topic "Adding a Relationship between Tables". Gotdotnet.com
probably has other examples or tutorials as well. Then once you've set
up the relations, you can then set the nested property to true.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 8 Dec 2003 09:53:32 -0800, "neverstill"
<sk************@yahoo.com> wrote:
Hi Mary, thanks for the response.

So I would setup the relationions prior to reading teh XML, correct? Haveyou ever seen any examples of this?

Thanks again,
Steve


"Mary Chipman" <mc***@nomail.please> wrote in message
news:qh********************************@4ax.com.. .
Create a dataset with datarelations between the tables you want
nested. Set the Nested property prior to writing the xml:

ds.Relations["relationName"].Nested = true;

-- Mary
MCW Technologies
http://www.mcwtech.com

On Thu, 4 Dec 2003 16:44:58 -0800, "Steve Klett"
<sk************@yahoo.com> wrote:

>(I posted this in ADO group, but I think this group will be better)
>
>Hi-
>
>I need to develop an FAQ section for our website. We would like to
breakup
>the FAQ by products, then categories with each category having n
>question/answer pairs.
>I would like to pass parameters in the querystring based on what the
>product/category the user selected, then populate a datagrid with the
>correct set of question/answer
>
>I am pretty new to XML, but basically I made something like this:
><products>
> <product>
> <name>prod1</name>
> <partNum>prod1</partNum>
> <categories>
> <category>
> <name>basic category</name>
> <faqs>
> <faq>
> <question>This is a sample question</question>
> <answer>this is the answer</answer>
> </faq>
> </faqs>
> </category>
> </categories>
> </product>
> <product>
> <name>prod2</name>
> <partNum>prod2</partNum>
> <categories>
> <category>
> <name>basic something or something category</name>
> <faqs>
> <faq>
> <question>This is another question</question>
> <answer>and this is another answer</answer>
> </faq>
> </faqs>
> </category>
> </categories>
> </product>
></products>
>
>
>
>So, then I use a DataSet and the ReadXML() method, this result in 5

tables.
>I was hoping that it would somehow be nested for me, but the way it is

right
>now I can't see an easy way to use it the way I want.
>
>the first table lists the products(good)
>the second table I can't really tell what is in there
>third tables has all the categories, so on and so on.
>
>What is confusing is... what is the point of structuring data

hierarchically
>in XML file if you can't maintain it? I'm sure you can, but how? Is

what
>I'm doing not common?
>
>Someone please shed a little light on this for me, I would appreciate

it!!
>
>Thanks,
>Steve
>

Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.