Create write and save xml file dynamically in c# .net

Question

I want to create xml file and write data from database in it. file will be created dynamically.

I am storing data in DataTable. Query is select documentId,documentContent from tblDocument where status = 'F'

where documentContent is xml data.

I have tried following code but its not working,

foreach(DataRow dr in dt.Rows) { string filepath = ConfigurationManager.Appsetings[Constants.FailedDocuments]; string filename = "message_"+ dr["documentId"].ToString(); string content = dr["documentContent"].ToString(); XDocument xdoc = new XDocument(); xdoc.parse(content); xdoc.Load(filepath+filename); }

I am new to this and don't know how to and where to place this code correctly as i want to write content

What do you mean by "not working"

user585968
– user585968

2016-12-20 18:11:20 +00:00
Commented Dec 20, 2016 at 18:11 — user585968
– user585968, Commented Dec 20, 2016 at 18:11
Did you mean xdoc.Save instead of Load?

Crowcoder
– Crowcoder

2016-12-20 18:35:13 +00:00
Commented Dec 20, 2016 at 18:35 — Crowcoder
– Crowcoder, Commented Dec 20, 2016 at 18:35

H.G. Sandhagen · Accepted Answer · 2016-12-20 18:38:00Z

Two thing:

Please post correct code. The XDocument class has no instance method "parse", only "Parse". The XDocument class has no instance method "Load", only static method "Load".
xdoc.Parse(content) would create a XDocument from the string. XDocument.Load(filename) would return a XDocument loaded from the XML file "filename".

This would do the job:

foreach(DataRow dr in dt.Rows) { string filepath = ConfigurationManager.Appsetings[Constants.FailedDocuments]; string filename = "message_"+ dr["documentId"].ToString(); string content = dr["documentContent"].ToString(); XDocument xdoc = new XDocument(); xdoc.Parse(content); xdoc.Save(filepath+filename); }

yes this worked. only small change needed. XDocument xdoc = Xdocument.Parse(content);

Collectives™ on Stack Overflow

Create write and save xml file dynamically in c# .net

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related