problem rowfilter with xml

[Phong Pham]

Hi! I need to search an xml file for a <symbol>FO</symbol> being passed from
a query string. here's my sample xml file (original xml file is generated
from a mainframe):

<stock>
<Filter>
<name>Filter1</name>
</Filter>
<Filter>
<name>Filter2</name>
</Filter>
<item>
<symbol>FO</symbol>
<comprating>91</comprating>
<epsrating>93</epsrating>
</item>
<item>
<symbol>CSL</symbol>
<comprating>81</comprating>
<epsrating>83</epsrating>
</item>
</stock>

query string ex.: http://localhost/SymbolRatings/default.aspx?s=FO
if i remove the <filter></filter> from the xml file and then load it into a
dataset, i can then use the dv.rowfilter = "symbol = 'FO'" to query the file
and display only the data that belongs to "FO" or whatever symbol is being
passed throught the query string and bind it to a datagrid.

my problem is that it doesn't work with the <filter> in at the top. =(

can anyone show me how or point me in the right direction on how i can
search the xml file without having to remove <filter></filter> because the
file needs that at the top. can it be done with the <filter> on top or do i
have to remove it because it doesn't match the <items> below?

thanks first!

phong

[gani]

hi phong, try this one:

using System;
using System.Drawing;
using System.Xml;

public class Tester
{
public static void Main()
{
string data = @"<stock>

<Filter>

<name>Filter1</name>

</Filter><Filter>

<name>Filter2</name>

</Filter>
<item>

<symbol>FO</symbol>

<comprating>91</comprating>

<epsrating>93</epsrating>

</item>
<item>

<symbol>CSL</symbol>

<comprating>81</comprating>

<epsrating>83</epsrating>

</item>
</stock>";
XmlDocument doc = new XmlDocument();
doc.LoadXml(data);
XmlNode node = doc.SelectSingleNode
("//stock/item[symbol=\"FO\"]");
if (node != null)
Console.WriteLine("Found");

Console.ReadLine();
}
}

-----Original Message-----
Hi! I need to search an xml file for a <symbol>FO</symbol> being passed froma query string. here's my sample xml file (original xml file is generatedfrom a mainframe):

<stock>
<Filter>
<name>Filter1</name>
</Filter>
<Filter>
<name>Filter2</name>
</Filter>
<item>
<symbol>FO</symbol>
<comprating>91</comprating>
<epsrating>93</epsrating>
</item>
<item>
<symbol>CSL</symbol>
<comprating>81</comprating>
<epsrating>83</epsrating>
</item>
</stock>

query string ex.: http://localhost/SymbolRatings/default.aspx?s=FO

if i remove the <filter></filter> from the xml file and then load it into adataset, i can then use the dv.rowfilter = "symbol = 'FO'" to query the fileand display only the data that belongs to "FO" or whatever symbol is beingpassed throught the query string and bind it to a datagrid.
my problem is that it doesn't work with the <filter> in at the top. =(
can anyone show me how or point me in the right direction on how i cansearch the xml file without having to remove <filter></filter> because thefile needs that at the top. can it be done with the <filter> on top or do ihave to remove it because it doesn't match the <items> below?
thanks first!

phong
.

[gani]

hi phong, try this one:

using System;
using System.Drawing;
using System.Xml;

public class Tester
{
public static void Main()
{
string data = @"<stock>

<Filter>

<name>Filter1</name>

</Filter><Filter>

<name>Filter2</name>

</Filter>
<item>

<symbol>FO</symbol>

<comprating>91</comprating>

<epsrating>93</epsrating>

</item>
<item>

<symbol>CSL</symbol>

<comprating>81</comprating>

<epsrating>83</epsrating>

</item>
</stock>";
XmlDocument doc = new XmlDocument();
doc.LoadXml(data);
XmlNode node = doc.SelectSingleNode
("//stock/item[symbol=\"FO\"]");
if (node != null)
Console.WriteLine("Found");

Console.ReadLine();
}
}

-----Original Message-----
Hi! I need to search an xml file for a <symbol>FO</symbol> being passed froma query string. here's my sample xml file (original xml file is generatedfrom a mainframe):

<stock>
<Filter>
<name>Filter1</name>
</Filter>
<Filter>
<name>Filter2</name>
</Filter>
<item>
<symbol>FO</symbol>
<comprating>91</comprating>
<epsrating>93</epsrating>
</item>
<item>
<symbol>CSL</symbol>
<comprating>81</comprating>
<epsrating>83</epsrating>
</item>
</stock>

query string ex.: http://localhost/SymbolRatings/default.aspx?s=FO

if i remove the <filter></filter> from the xml file and then load it into adataset, i can then use the dv.rowfilter = "symbol = 'FO'" to query the fileand display only the data that belongs to "FO" or whatever symbol is beingpassed throught the query string and bind it to a datagrid.
my problem is that it doesn't work with the <filter> in at the top. =(
can anyone show me how or point me in the right direction on how i cansearch the xml file without having to remove <filter></filter> because thefile needs that at the top. can it be done with the <filter> on top or do ihave to remove it because it doesn't match the <items> below?
thanks first!

phong
.