Click here to Skip to main content
12,299,668 members (58,364 online)
Click here to Skip to main content
Add your own
alternative version


21 bookmarked

Export DataSet to XML File

, 15 Feb 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
Export/create Dataset to Xml file.


This Article ia about Export DataSet to XMl file.This Code Snippet take a data set from the database and populate it on the .aspx page after clicking the Button. This code create afile on the current location as in this case it will be created in the C:/Inetpub/wwwroot/ExportImport/...this is Useful because it is very simple to understand and write.

Using the code

use this code into your Code behind file

First you should create a connection string in your WEB.CONFIG file.

// web.config setting
add name="ExportImportCS" connectionString="Data Source=BROAD-12\SQLEXPRESS;Initial Catalog=LibSYSDB;Integrated Security=True" providerName="System.Data.SqlClient
// C# Code

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Xml.Serialization;
using System.Xml;
using System.IO;

public partial class ExportToXml : System.Web.UI.Page
//Connection setting on .aspx page
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ExportImportCS"].ConnectionString); 
    protected void Page_Load(object sender, EventArgs e)

// Method created for populate the dataset and grid 
    public void ConnectionXML()
        SqlCommand command = new SqlCommand();
        command.CommandText = "SELECT * FROM BookIssueDetails";
        command.CommandType = CommandType.Text;
        command.Connection = con;
        SqlDataAdapter da = new SqlDataAdapter(command);
        DataSet ds = new DataSet();
        da.Fill(ds, "BookIssueDetails");
        if (ds.Tables[0].Rows.Count > 0)
            grdXML.DataSource = ds;
        // Get a StreamWriter object
        StreamWriter xmlDoc = new StreamWriter(Server.MapPath("~/FileTest/Testdo.xml"), false);
        // Apply the WriteXml method to write an XML document
    //On click of button event
    protected void btnExportToXml_Click(object sender, EventArgs e)


Remember to set the .aspx page must download the zip file.

Points of Interest

I hope i tried to explain well. If you like this code please Vote for this Article.... Please..! Thank You


I am working as a software Engineer with MNC in INDIA.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Prabhash Chandra
Software Developer
India India
I'm a software Professional having Master's in Computer Application from Dehradoon and master's in Commerce(Accounts)and working as software developer on ASP.NET(C#),MS Commerce Server 2007 and Share Point.

You may also be interested in...

Comments and Discussions

Questionxmlwrite Pin
Vinay Jade16-Dec-13 2:47
professionalVinay Jade16-Dec-13 2:47 
QuestionExport DataSet to XML File Pin
manoj4achu17-Feb-13 18:58
membermanoj4achu17-Feb-13 18:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160525.2 | Last Updated 16 Feb 2008
Article Copyright 2008 by Prabhash Chandra
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid