Export DataSet to XML File

create xml file from a dataset:

This code snippet show how to export DataSet to xml file.Here we have taken data from database and fill dataset.We have taken a aspx page and a button there,after clicking the button a xml file will be created at specified location.

public void CreateXml() 
   { 
     DataSet ds = new DataSet(); 
     SqlDataAdapter da = new SqlDataAdapter("usp_GetAddressDetails",con); 
     da.Fill(ds); 
     if (ds.Tables[0].Rows.Count > 0) 
      { 
       GridView1.DataSource = ds; 
       GridView1.DataBind(); 
      }

    StreamWriter objStreamWriter = new                             StreamWriter("E:\\Santosh\\Practices\\ASP\\XMLFiles\\EmpAddress.xml", false); 
     ds.WriteXml(objStreamWriter); 
     objStreamWriter.Close(); 
   }

protected void Button1_Click(object sender, EventArgs e) 
   { 
     CreateXml(); 
   }