hi,
I have the following scenario: I am using SQL Server 2005 Express and Visual Studio 2008 - C#, my database has 5 tables which hold configuration settings for my application. Each client will have a different configuration settings but the same database and same table structures. What I am trying to accomplish is to update the 5 tables in my database from one XML file.
Is there anyway I can update my database with ONLY one xml file instead of having 1 xml file per table?
I know that i need an sql adapter for each table, but can i write data from different sql adapters into ONE single xml file? if so, then how can I read them back into their detination tables?
I am trying to avoid having the client to Import/Export 5 xml files
here is the code i am using to import one singe xml file into a destination table
SqlDataAdapter da = new SqlDataAdapter("Select * from Table1", sqlcon);
.....
// read the XML file
ds.ReadXml("DestinationFil
e.xml");
// update the database
da.Update(ds, "Table1");
thank you
Start Free Trial