retrieving distinct attributes from xml doc

[rds80]

In the xml document below, I would like to retrieve the distinct
attributes for the element '<Bal>'. However, I haven't had any
success. Here is what I have so far:

<TRANS>

<TRAN TRAN_DESC_CD="A CRT" TRAN_DESC="Actu al Rate">

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 11-01" />

</BAL>

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 13-01" />

</BAL>

<BAL BAL_FLD_NUM="2" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 112-01" />

</BAL>

<BAL BAL_FLD_NUM="6" BAL_FLD_DSCR="A ctual Dispersion Amount">

<SUBDEAL SUB_Deal_ID="02 342-01" />

</BAL>

</TRAN>

</TRANS>

IEnumerable<XAt tributeICOA =

(from ddList in GxmlCOA.Descend ants("BAL").Att ributes()

select ddList).Distinc t();

So the distinct bal fields should be:

1) Text = "Actual Rate Amount"

Val = 3

2) Text = "Actual Rate Amount"

Val = 2

3) Text = "Actual Dispersion Amount"

Val = 6

Unfortunately, the LINQ query isn't working.

[DaveL]

Test.Xml is A copy of yours

XmlDocument oXml = new XmlDocument();
oXml.Load("d:\\ temp\\test.xml" );
//get attribut
XmlNode testnode =
oXml.SelectSing leNode("TRANS/TRAN/BAL/SUBDEAL[@SUB_Deal_ID='0 0112-01']");
if (testnode==null )
{
Console.WriteLi ne("Not Found");
}
else
{

Console.WriteLi ne(testnode.Att ributes[0].Value);
}
//if u want all of the tran nodes TRANS being your root
XmlNode TranNodes = oXml.SelectSing leNode("TRANS/TRAN");
for (int x = 0; x < TranNodes.Child Nodes.Count; x++)
{
//all attributes
XmlNode node = TranNodes.Child Nodes[x];
Console.WriteLi ne(node.Name);
if (node.Attribute s.Count 0)
{
for (int y = 0; y < node.Attributes .Count; y++)
{
Console.WriteLi ne(node.Attribu tes[y].Name.ToString( )
+ " " + node.Attributes[y].Value.ToString ());
}
}

}
Dave

"rds80" <sh*********@gm ail.comwrote in message
news:6c******** *************** ***********@b1g 2000hsg.googleg roups.com...

In the xml document below, I would like to retrieve the distinct
attributes for the element '<Bal>'. However, I haven't had any
success. Here is what I have so far:

<TRANS>

<TRAN TRAN_DESC_CD="A CRT" TRAN_DESC="Actu al Rate">

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 11-01" />

</BAL>

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 13-01" />

</BAL>

<BAL BAL_FLD_NUM="2" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 112-01" />

</BAL>

<BAL BAL_FLD_NUM="6" BAL_FLD_DSCR="A ctual Dispersion Amount">

<SUBDEAL SUB_Deal_ID="02 342-01" />

</BAL>

</TRAN>

</TRANS>

IEnumerable<XAt tributeICOA =

(from ddList in GxmlCOA.Descend ants("BAL").Att ributes()

select ddList).Distinc t();

So the distinct bal fields should be:

1) Text = "Actual Rate Amount"

Val = 3

2) Text = "Actual Rate Amount"

Val = 2

3) Text = "Actual Dispersion Amount"

Val = 6

Unfortunately, the LINQ query isn't working.

[wisccal]

Hi

You could create your own object, which overrides Equal and
GetHashCode. Something like:

using System;
using System.Linq;
using System.Xml.Linq ;
using System.Collecti ons.Generic;

public class DistinctAttr {
public static void Main(string[] args)
{
XElement el = XElement.Load(" DistinctAttr.xm l");
var attrs =
el.Descendants( "BAL").
Select(e =>
new MyAttr
{
Num = e.Attribute("BA L_FLD_NUM").Val ue,
Dscr = e.Attribute("BA L_FLD_DSCR").Va lue
}
).Distinct();
foreach(var at in attrs)
{
Console.WriteLi ne("num: {0}, dscr: {1}", at.Num, at.Dscr);
}
}

class MyAttr
{
private string _num, _dscr;
public override bool Equals(object obj)
{
if(obj == null || !(obj is MyAttr)) return false;
MyAttr at = (MyAttr) obj;
return this._num == at.Num && this._dscr == at.Dscr;
}

public override int GetHashCode()
{
return (int) (_num.GetHashCo de() + _dscr.GetHashCo de());
}

public string Num {get{return this._num;} set{this._num = value;}}
public string Dscr {get{return this._dscr;} set{this._dscr =
value;}}
}
}

Regards
Steve

On Sep 12, 5:10*pm, rds80 <shah.rip...@gm ail.comwrote:

In the xml document below, I would like to retrieve the distinct
attributes for the element '<Bal>'. *However, I haven't had any
success. Here is what I have so far:

<TRANS>

<TRAN TRAN_DESC_CD="A CRT" TRAN_DESC="Actu al Rate">

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 11-01" />

</BAL>

<BAL BAL_FLD_NUM="3" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 13-01" />

</BAL>

<BAL BAL_FLD_NUM="2" BAL_FLD_DSCR="A ctual Rate Amount">

<SUBDEAL SUB_Deal_ID="00 112-01" />

</BAL>

<BAL BAL_FLD_NUM="6" BAL_FLD_DSCR="A ctual Dispersion Amount">

<SUBDEAL SUB_Deal_ID="02 342-01" />

</BAL>

</TRAN>

</TRANS>

IEnumerable<XAt tributeICOA =

(from ddList in GxmlCOA.Descend ants("BAL").Att ributes()

select ddList).Distinc t();

So the distinct bal fields should be:

1) Text = "Actual Rate Amount"

Val = 3

2) Text = "Actual Rate Amount"

Val = 2

3) Text = "Actual Dispersion Amount"

Val = 6

Unfortunately, the LINQ query isn't working.