Reader Level:
Articles

Export Dataset Data To XML File

By Prabhash Chandra on February 27, 2008
This article will provides you how can you export DataSet in Asp.Net 2.0 to an XMl File.
  • 0
  • 0
  • 75387

Introduction:

In this code you have to write the file name with the extension .xml and the code will create the xml file with that name and populate it.

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
{
   
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ExportImportCS"].ConnectionString);
    protected
void Page_Load(object sender, EventArgs e)
}

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 FileStream 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();
}

protected void btnExportToXml_Click(object sender, EventArgs e)
{
   
ConnectionXML();
}

Source code Page View

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExportToXml.aspx.cs" Inherits="ExportToXml" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1 transitional.dtd">

<
html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="grdXML" runat="server">
</asp:GridView>
</div>
<asp:Button ID="btnExportToXml" runat="server" OnClick="btnExportToXml_Click" Text="EXPORT XML" />
</form>
</body>
</html>

COMMENT USING

Trending up