Generate XML from Dataset

   protected void generateXML_Click(object sender, EventArgs e)

        {

            // Define Connection with connection string

            SqlConnection con = new SqlConnection("Add ConnectionString");

            // write query to retrieve data.

            SqlCommand cmd = new SqlCommand("select * from DetailMaster", con);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();   // Take Dataset

            da.Fill(ds);

            ds.WriteXml("D:/textXML.xml");  // Path to create XML

        }