Save DataSet to disk with schema : DataSet Xml « ADO.Net « C# / CSharp Tutorial






using System;
using System.Data;
using System.Data.SqlClient;

public class SaveDataSet
{
    private static string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI";

    public static void Main() 
    {
        string SQL = "SELECT CategoryID, CategoryName,Description FROM Categories";

        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand com = new SqlCommand(SQL, con);
        SqlDataAdapter adapter = new SqlDataAdapter(com);
        DataSet ds = new DataSet("Nortwind");

        con.Open();
        adapter.FillSchema(ds, SchemaType.Mapped, "Categories");
        adapter.Fill(ds, "Categories");
        con.Close();

        ds.WriteXmlSchema("mydata.xsd");
        ds.WriteXml("mydata.xml");

        ds.Reset();

        ds.ReadXmlSchema("mydata.xsd");
        ds.ReadXml("mydata.xml");

        Console.WriteLine(ds.GetXml());
    }
}








32.34.DataSet Xml
32.34.1.Read an xml file into a dataset
32.34.2.Persist a Dataset to an XML file
32.34.3.Adding to DataSet and output to Xml
32.34.4.Output the XSD schema for the DataSet
32.34.5.Write Xml
32.34.6.Save DataSet to disk with schema
32.34.7.Pop DataSet
32.34.8.Transform Data
32.34.9.Create DataSet and DataTable