Click here to Skip to main content
12,633,336 members (29,950 online)
Click here to Skip to main content
Add your own
alternative version

Stats

94K views
2.1K downloads
21 bookmarked
Posted

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.

Introduction

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;
            grdXML.DataBind();
        }
        // Get a StreamWriter object
        StreamWriter xmlDoc = new StreamWriter(Server.MapPath("~/FileTest/Testdo.xml"), false);
       
        // Apply the WriteXml method to write an XML document
         ds.WriteXml(xmlDoc);
         xmlDoc.Close();
     
    }
    //On click of button event
    protected void btnExportToXml_Click(object sender, EventArgs e)
    {
        ConnectionXML();

    }
}

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

History

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

License

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

Share

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 3:47
professionalVinay Jade16-Dec-13 3:47 
QuestionExport DataSet to XML File Pin
manoj4achu17-Feb-13 19:58
membermanoj4achu17-Feb-13 19:58 
Questiongenerating xml from dataSet Pin
rohith reddy vadiyala21-Nov-12 22:35
memberrohith reddy vadiyala21-Nov-12 22:35 
QuestionC# Implementation of Writing Data to XML Format using Dataset Pin
sangram3609-Mar-12 21:25
membersangram3609-Mar-12 21:25 
GeneralAll fields in 1 attribute? Pin
yaron klodovski7-Jun-11 15:11
memberyaron klodovski7-Jun-11 15:11 
GeneralRe: All fields in 1 attribute? Pin
yaron klodovski7-Jun-11 15:29
memberyaron klodovski7-Jun-11 15:29 
GeneralThanks Pin
jaffrey11015-Feb-11 22:03
memberjaffrey11015-Feb-11 22:03 
GeneralMy vote of 1 Pin
Enrico Detoma26-Sep-09 3:53
memberEnrico Detoma26-Sep-09 3:53 
GeneralYOU BAD Pin
MrGoodly15-Sep-08 8:33
memberMrGoodly15-Sep-08 8:33 
GeneralTrivial ! Pin
kalyankrishna118-Feb-08 17:38
memberkalyankrishna118-Feb-08 17:38 
GeneralRe: Trivial ! Pin
ZackJones19-Mar-08 7:32
memberZackJones19-Mar-08 7:32 
GeneralWelcome To Codeproject !!! Pin
Abhijit Jana16-Feb-08 1:51
memberAbhijit Jana16-Feb-08 1:51 
GeneralRe: Welcome To Codeproject !!! Pin
damir_tk17-Feb-08 8:38
memberdamir_tk17-Feb-08 8:38 

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.161208.2 | Last Updated 16 Feb 2008
Article Copyright 2008 by Prabhash Chandra
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid