Categories Hierachy

[A. Elamiri]

Hello,

I have a list of product categories and each category may or may not have
children and it goes down in a varying level of depth.
Now I have to pull this category information for navigation, I was thinking
of store the ID#'s and category names as well as parent ID's but actually
using an XML file to store the hierachy.
Would be an efficient way of doing this?

Thank you

[Ignacio Machin]

Hi,

You can keep the parent ID as an attribute of the Category node, and filter
the XML for a particular value. I have no idea how efficient this solution
is though.
What I would do is create a DataSet with a Category table, including a
column ParentID , you can create a Foreign key to the same table to the ID
column then you could use some construction like DataRow.GetChilRows(
"Parent_FK" ); which return a DataRow[]

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"A. Elamiri" <ab************@NOSPAMnexnevo.com> wrote in message
news:D2*****************@nwrdny01.gnilink.net...

Hello,

I have a list of product categories and each category may or may not have
children and it goes down in a varying level of depth.
Now I have to pull this category information for navigation, I was thinking of store the ID#'s and category names as well as parent ID's but actually
using an XML file to store the hierachy.
Would be an efficient way of doing this?

Thank you

[A. Elamiri]

I will do that, thank you

"Ignacio Machin" <ignacio.machin AT dot.state.fl.us> wrote in message
news:ur**************@TK2MSFTNGP09.phx.gbl...

Hi,

You can keep the parent ID as an attribute of the Category node, and filter the XML for a particular value. I have no idea how efficient this solution
is though.
What I would do is create a DataSet with a Category table, including a
column ParentID , you can create a Foreign key to the same table to the ID column then you could use some construction like DataRow.GetChilRows(
"Parent_FK" ); which return a DataRow[]

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"A. Elamiri" <ab************@NOSPAMnexnevo.com> wrote in message
news:D2*****************@nwrdny01.gnilink.net...

Hello,

I have a list of product categories and each category may or may not have children and it goes down in a varying level of depth.
Now I have to pull this category information for navigation, I was

thinking

of store the ID#'s and category names as well as parent ID's but actually using an XML file to store the hierachy.
Would be an efficient way of doing this?

Thank you