Load From XML

[MikeB]

Hello all, what is the best / most efficaiant way to load data from XML into
a sqlce database? Here is what I am using to create the XML:

//Create Main Dataset
DataSet dsMain = new DataSet();

//Create Dataset to hold all DB Tables
DataSet dsTables = new DataSet();
myApp.Classes.Globals.gDB.LoadDataset("SELECT table_name FROM
information_schema.tables WHERE table_type = 'TABLE'",dsTables);

foreach(System.Data.DataRow dr in dsTables.Tables[0].Rows )
{
myApp.Classes.Globals.gDB.LoadDataset("SELECT * FROM " +
dr["table_name"].ToString(),dr["table_name"].ToString(),dsMain);
}

//Export to XML
dsMain.WriteXml(@"\SDMMC Disk\\DBBackUp.xml");

 

[Neil Cowburn]

dsMain.ReadXml(@"\SDMMC Disk\\DBBackUp.xml");

and then update your database using that dataset.

--
Neil Cowburn
Principal Partner
OpenNETCF Consulting, LLC.

Managed Code in the Embedded World

http://www.opennetcf.com/
http://www.smartdeviceframework.com/