How to use XML file as data set ?

[Marc Hillman]

I have a simple VB.NET Express 2008 application that works. It uses an
Access 2007 database to store its data. Data is available on a form using a
DataGridView with BindingSource and BindingNavigator.

Access 2007 is a bit of a sledgehammer to crack a peanut, and gives me
portability issues. There's only a single table and 100 records.

I'd really like to use an XML data file for simplicity. I have the data in
an XML file, and I have the associated schema file. How do I define a data
source? XML doesn't seem to be an option.

I can't see how to hook it into my project at design time. I can do it at
run time, but I'd like to do it at design time so that I can see how the
DataGridView screen will look with real columns.

Is this possible? How?

 

[Cor Ligthert[MVP]]

ds.WriteXML(Path,Options) writes dataset as XML file to disk
ds.ReadXML(Path) reads a XML file from disk.

Be so clever to add in the options the schema (is intellisence)