XML

praveen bahubali

15y1.8k.NET

Hi,
Can you please give simple example for retrieves data from SQL Table and saves it as an XML File?

Thanks
Praveen

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak15y ago
Accepted answer
Hi Praveen,

Try this...

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

    Untitled Page










            Text="Saving data in xml format" Width="164px" />


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

    void bind()
    {

        SqlConnection con = new SqlConnection(connStr);

            try
            {
                con.Open();
                str = "select * from employee";
                com = new SqlCommand(str, con);
                sqlda = new SqlDataAdapter(com);
                ds = new DataSet();
                sqlda.Fill(ds, "employee");
                GridView1.DataSource = ds;
                GridView1.DataMember = "employee";
                GridView1.DataBind();
                con.Close();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }

    }
    protected void btn_save_Click(object sender, EventArgs e)
    {
        bind();
        ds.WriteXml("d:\\employee.xml");
        Response.Write("Records saved as xml");
    }
}

Thanks
If this post helps you mark it as answer
0
Tulasi15y ago
hi,

check the below code .

public void CreateXml()
{
SqlConnection sqlcon = new SqlConnection(connection string);
SqlDataAdapter sqldad = new SqlDataAdapter("select * from emp", sqlcon);
DataSet dsemp = new DataSet();
sqldad.Fill(dsemp, "Employee");
dsemp.Tables[0].WriteXml(Server.MapPath("XML_Files") + "/testxsl.xml");
}

Dataset have a predefined function to save table data as xml file
//specific table is converted into xml file , and it is stored at XML_Files folder
dsemp.Tables[0].WriteXml(Server.MapPath("XML_Files") + "/testxsl.xml");

Please mark the answer as Accepted if it helps you.
0
Sam Hobbs15y ago
Did you look at the articles in this web site?
0
nishant ranjan15y ago
simple xml generation on button click

StringBuilder str = new StringBuilder();
cmd = new SqlCommand()
con.Close();
        con.Open();
        SqlDataReader rd = cmd.ExecuteReader();

        if (rd.HasRows)
        {

            str.Append(string.Format("{0}", Environment.NewLine));
            str.Append(string.Format("", Environment.NewLine));
            while (rd.Read())
            {
                str.Append(string.Format("{0}{0}{1}{0}{2}{0}{3}{0}", Environment.NewLine, rd["patient_id"].ToString(), rd["patient_name"].ToString(), rd["server_id"].ToString()));


            }
            str.Append(string.Format("{0}", Environment.NewLine));
            str.Append(string.Format("{0}", Environment.NewLine));
            if (!Directory.Exists(Server.MapPath("xml")))
            {
                Directory.CreateDirectory(Server.MapPath("xml"));
            }
            File.WriteAllText(Server.MapPath("~/xml/") + loginnm + ".xml", str.ToString()); //to write in the xml file

        }
        else
        {
            str.Append(string.Format("{0}", Environment.NewLine));
            str.Append(string.Format("{0}", Environment.NewLine));
            str.Append(string.Format("No Appointment"));
            str.Append(string.Format("", Environment.NewLine));
            str.Append(string.Format("{0}", Environment.NewLine));
            if (!Directory.Exists(Server.MapPath("xml")))
            {
                Directory.CreateDirectory(Server.MapPath("xml"));
            }
            File.WriteAllText(Server.MapPath("~/xml/") + loginnm + ".xml", str.ToString()); //to write in the xml file

        }

        con.Close();
0