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

1

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);
}

answered Dec 20, 2016 at 18:38

H.G. Sandhagen

8248 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dinav Ahire Over a year ago

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

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related