Load XML into a Dataset [C#/.NET]

If you’re working with XML files in .NET, the easiest thing to do is load the XML in as a DataTable:

using System.Data.SqlClient;

public DataTable ReturnDataTbl(string XmlFile)
  {
  DataSet dset = new DataSet();

  FileStream fstr = new FileStream(XmlFile, FileMode.Open, FileAccess.Read);
  dset.readXml(fstr);

  DataTable dtbl = dset.Tables[0];

  fstr.Close();
  dset.Dispose();

  return dtbl;
  }

You can now run a SELECT, UPDATE or any SQL statement on it directly.