I am loading a .xml file to a dataset and them trying to use table.select(<expression>) to query it.
xml code:
<Bytes>
<ID>0</ID>
<Name>f</Name>
<Bit>
<ID>0</ID>
<Name>g</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bit>
<ID>1</ID>
<Name>h</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bit>
<ID>2</ID>
<Name>i</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bytes>
<Bytes>
<ID>1</ID>
<Name>f</Name>
<Bit>
<ID>0</ID>
<Name>a</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bit>
<ID>1</ID>
<Name>b</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bit>
<ID>2</ID>
<Name>c</Name>
<Number>0</Number>
<Data>1</Data>
</Bit>
<Bytes>
Code:
NewDataSet dss = new NewDataSet();
string filePath = @"C:\Documents and Settings\matt\My Documents\Visual Studio Projects\TwoWayXML\XMLProject\Tway.xml";
dss.ReadXml(filePath);
DataTable dt;
dt = dss.Tables["Bytes"];
DataRow[] dr = dt.Select("ID = 0 AND Bit.ID = 0");
I want to get the row where Byte ID field that = 0 and it's child Bit ID field that = 0.
Does anyone know the expression that can do this?
Thanks
Matt
