How to prepare the XML file by using Database server

Question

Hi All I have database with some table like DNo DName Location Employees 10 IT Hyd 15 20 Sales Bangalore 29 ----------------With some more records---------------- My requirement is now i want to send this datasource to somewhere in the form of XML file. So We can't prepare again the XML file for those records Is there any alternate solutions or tool to generate the XML file by using Database/Table Can you tell me the process....

Satyapriya Nayak · Answer

Hi Siva Try this... Untitled Page Text=Save to Xml /> 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); } } Thanks If this post helps you mark it as answer

nilesh chaudhari · Answer

hi if you using the sqlserver 2005 or above you can use following query for generating xml from database select DnoDNameLocationEmployess from Tbl for xml auto; this query will automatically create the xml formated output

SIVA · Answer

Nice sharing Thank you

SIVA · Answer

Hey fine with that its working properly & is we need to copy & paste the content to another file or else Where we will get the output XML file can you tell me the path