Quake3World

Turbanator wrote:Wondering if anyone can help me on this one.

I have an XML file in the following format:

Code: Select all

<product>
	<tier1>
		<id>1</id>
	</tier1>
	<tier2>
		<relation>2</relation>
	<tier2>
</product>
<product>
	<tier1>
		<id>2</id>
	</tier1>
</product>

This is being pulled into a dataset using Dataset.ReadXml. The resulting XML has 3 tables, product (empty rows), tier1 (just ids), tier2 (just relations).

To read out all the id's i can simply reference to them using:
myDS.Tables["tier1"].Rows[0].ToString();

To get all the relations, similarly I can use myDS.Tables["tier2"].Rows[0].ToString();

How do I get 2 figures out of this, the relation and it's corresponding id, so the output for the above example would be:
ID: 1 Relation: 2
ID: 2 Relation: Null

?

Dim i as Int32
Dim j as Int32
Dim _innerRow as DataRow
dim _id as String
dim _relation as String

For i = 0 to myDs.Rows.Count - 1
    _innerRow = myDs.Rows(i)
    for j = 0 to _innerRow.Rows.Count - 1
        _id = _innerRow.Rows(j)(0).ToString
        _relation = iif(_innerRow.Rows(j)(1).ToString = String.Empty, DbNull.Value, _innerRow.Rows(j)(1).ToString))
    next
Next

Turbanator wrote:this is a data file that holds information i need to visualize, so i'm reverse engineering it. I've got it back to an XML form, and now I need to load data off the XML into a new dataset so I can output a "clean xml" to work with for visualization.

Here is a real world example of the data I'm working with:

Code: Select all

<LI>
	<BASICS>
		<LI_KEY>1140</LI_KEY>
		<LABEL>Allowed CAB to meet target coverage</LABEL>
	</BASICS>
	<T_DATA>
		<F_TOKENS>
			<F_TK>
				<TK_T>5</TK_T>
				<TK_TX>IF</TK_TX>
				<TK_EX_T>1</TK_EX_T>
			</F_TK>
			<F_TK>
				<TK_T>4</TK_T>
				<TK_LI_ID>1132</TK_LI_ID>
				<TK_EX_T>0</TK_EX_T>
			</F_TK>
			<F_TK>
				<TK_T>8</TK_T>
				<TK_TX>/</TK_TX>
				<TK_EX_T>6</TK_EX_T>
			</F_TK>
			<F_TK>
				<TK_T>4</TK_T>
				<TK_LI_ID>62</TK_LI_ID>
				<TK_EX_T>0</TK_EX_T>
				<TK_ANC>T</TK_ANC>
			</F_TK>
		</F_TOKENS>
	</T_DATA>
</LI>

I can pull out all the LI->BASICS->LI_KEY and LABEL values quite easily, they're in the same "basics" table in the dataset... i need to pull out all the TK_LI_ID values and their corresponding LI_KEY values, but these values are stored in two different tables bound together by the same LI parent. So in this above example my first clean data table would read:
1140, "Allowed CAB to meet target coverage"
and my 2nd data table would read:
1140, 1132
1140, 62

inolen wrote:Edit: Feel free to IM me, I'm not doing much atm

Turbanator wrote:

inolen wrote:Edit: Feel free to IM me, I'm not doing much atm

i can't remember my icq password... lol

is my e-mail address on my icq account set to raj [at] turbanator [dot] net ?

Turbanator wrote:and now I need to load data off the XML into a new dataset so I can output a "clean xml" to work with for visualization.

^misantropia^ wrote:

Turbanator wrote:and now I need to load data off the XML into a new dataset so I can output a "clean xml" to work with for visualization.

This is the kind of work XSLT was invented for.