create xml file from db

Posted by Murugavelmsc under C# on 2/8/2013 | Points: 10 | Views : 1942 | Status : [Member] | Replies : 4
Expert,

how to create xml file from db?


Thanks,
Murugavel S

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/



Responses

Posted by: Satyapriyanayak on: 2/9/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
Bind data to gridview from database and then export it to xml file

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!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>

</div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<asp:Button ID="btnsave" runat="server" onclick="btnsave_Click"
Text="Save to Xml" />
</form>
</body>
</html>


using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand com;
SqlDataAdapter sqlda;
DataSet ds;
string str;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
protected void BindGrid()
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "select * from employee";
com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
con.Close();
ds = new DataSet();
sqlda.Fill(ds, "employee");
GridView1.DataSource = ds;
GridView1.DataMember = "employee";
GridView1.DataBind();
}
protected void btnsave_Click(object sender, EventArgs e)
{
BindGrid();
ds.WriteXml("d:\\employee.xml");
Response.Write("Records saved as xml");
}
}


If this post helps you mark it as answer
Thanks

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kundnani.Rt on: 2/12/2013 [Member] Starter | Points: 25

Up
0
Down
Above solution is perfectly fine !!!!

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 2/28/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

muruavel

refer this url

http://ask.sqlservercentral.com/questions/30853/how-to-save-output-of-a-query-uses-for-xml-to-a-fi.html

Mark as Answer if its helpful to you

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Megan00 on: 2/28/2013 [Member] Starter | Points: 25

Up
0
Down
You can use this free data export library, you can export data from database,listview and command to xml, html, word, excel(including generate 15 types charts), pdf, csv, text,dif, etc, it has a free edition for few data export, you can give it a try:

http://exportdata.codeplex.com/

Never give up! Smile to the world!
http://excelcsharp.blog.com/

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response