hi,
i know how to save table content (example: select * from products) to a xml
file
the code below opens the xml file read all records.
i would like to know how i can filter the records like in a query?
can i do something like:
select * from PRODUCTS.XML where id >100 or something????
DataSet ds = new DataSet();
string myXMLfile = @"products.xml";
System.IO.FileStream fsReadXml = new System.IO.FileStream
(myXMLfile, System.IO.FileMode.Open);
try
{
ds.ReadXml(fsReadXml);
XmlReader xrdr = testCommand.ExecuteXmlReader();
xrdr.Read();
Console.WriteLine(xrdr.ReadOuterXml());
foreach (DataRow row in ds.Tables[0].Rows)
{
MessageBox.Show(row["DESCRIPTION"].ToString());
}
......