Need to insert data from XML to my MS ACCESS Database

Question

hello, i need to create a database in which i need to fill data from a XML file. i populated the data from XML into a data set but don't know how to fill database from this data set. Please help

Sam Hobbs · Answer

What is a "data set"? Is it a .Net DataSet class object or a file on disk or something else?

pritam hinger · Answer

Thanks SAM,i already tried this way... actually what i m looking for is "Does there exist any inbuilt function of .NET which can do this task in one shot"? like we can read complete xml data into DataSet's object using ReadXml(). Anyway my task is done but still if there exist any inbuilt function for this task then it would be great help. Thanks

Sam Hobbs · Answer

First create a table or tables in a database with the fields that you need; the same fields that are in the table(s) in the dataset. Then use the sample code I posted in Add GUIDs to new GUID column . Except you will use an InsertCommand for each table (SqlDataAdapter). Does that help?

pritam hinger · Answer

yup that is DataSet class of .NET. I created an object of DataSet and using ReadXml() function i populated data into the object. Now i need to fill this data into my ACCESS Database. Thanks for the help

Need to insert data from XML to my MS ACCESS Database

Answers (4)