how to write datasets to xml in asp.net

Question

I have just started learning asp.net with c# and want to know how to write datasets to XML using asp.net. Can anyone provide me any example or reference so that I can move ahead.

Thanks in Advance

Anu Sharma

Geoff Appleford · Accepted Answer · 2010-11-17 09:02:41Z

1

The WriteXml method will save the entire dataset to an xml file or stream.

myDataset.WriteXml("dataset.xml", XmlWriteMode.WriteSchema);

answered Nov 17, 2010 at 9:02

Geoff Appleford

18.9k4 gold badges66 silver badges88 bronze badges

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

Comments

Prashant Hadole · Accepted Answer · 2016-08-26 11:20:06Z

Create one empty data dataset with database name, so that this name will reflect to your converted xml document

DataSet ds = new DataSet();
ds.DataSetName = "ds";

Add your data (data tables) to this dataset with name

data.TableName = "tb";
ds.Tables.Add(data);

Create one XmlDocument & load data string into it

using (MemoryStream memoryStream = new MemoryStream())
{
    using (TextWriter streamWriter = new StreamWriter(memoryStream))
    {
        XmlSerializer xmlSerializer = new XmlSerializer(typeof(DataSet));
        xmlSerializer.Serialize(streamWriter, ds);
        result = Encoding.UTF8.GetString(memoryStream.ToArray());
    }
}

XmlDocument _doc = new XmlDocument();
_doc.LoadXml(result);

Collectives™ on Stack Overflow

how to write datasets to xml in asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related