Data Set to text file.

[{FPP}]

Hi, i use this code

 DataSet dsPubs = new DataSet();
            System.Xml.XmlDocument xdcDOC = new System.Xml.XmlDocument();
            // Read in XML from file
            dsPubs.ReadXml("http://www.nytimes.com/services/xml/rss/nyt/International.xml");
            // Bind DataSet to Data Grid
            grdData.DataMember = "item";
            grdData.DataSource = dsPubs;
            tmrDisplay.Enabled = true;

To populate a dataset with the RSS info...How could i on a click of a button save this to text file?

Like this is what i should look like:

Title: The title colum

Description - Description colum

Thanks
-FPP

[jmcilhinney]

When you say text file do you mean a CSV? All you would need to do is open StreamWriter to write the file. Use a For loop to iterate over the Columns of the table to write the headers if you want them, then nested For loops to iterate over each column of each row to write out the values. Just make sure you put the comma between each pair of fields.