XML Database Question

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[0].DefaultView;

How can I apply an Sql statement to the .ReadXml?

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!