Generating XML File From SQL Database Using C#

In this blog, we Generate XML File From SQL Database Using C#.

Creating Table in SQL Server Database

Now create a table named UserDetail with the columns UserId and UserName. The table looks like as below.

Now creating a new web application project in Visual Studio 2010. Now add the following namespace.

using System.Data.SqlClient;

using System.Data;

using System.Xml;

Now write the connection string to connect to the database.

string strConnection = "Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;";

Codebehind 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Xml;

namespace WebApplication119

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection("Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;");

            string strSQL = "Select UserId, UserName from UserDetail";

            SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);

            DataSet ds = new DataSet();

            dt.Fill (ds,"UserDetail");

            ds.WriteXml(Server.MapPath("emp_xml_file.xml"));

           LabelMessage.Text = "<a href=emp_xml_file.xml> XML file</a>";

        }    

    }

}

Now run the application and test it.

Now click on the Button link will be generate to show the XML file.

Now click on the link to show the XML file.