I'm switching my existing app which uses an Access database to a XML database. I imported the xml, created a schema and from that let C# make a dataSet class for me. I am able to bind the XML to a dataGrid and update it and all that. So far so good.
But how can I use Sql statements when only using XML?
db = new CHECKINGTRANS(); // Create a new dataSet off of my class
db.ReadXml("CHECKINGTRANSACTIONS.xml"); // Read the XML document
then I bind the data to the grid:
dataGrid1.DataSource = db.Tables.DefaultView;
How can I apply an Sql statement to the .ReadXml?