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....
Loading
Satyapriya NayakPosted Dec 29, 2011, 4:37 AM
Try this...
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
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
SIVAPosted Dec 29, 2011, 6:08 AM
Thank you
SIVAPosted Dec 29, 2011, 4:32 AM
& 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
nilesh chaudhariPosted Dec 29, 2011, 4:24 AM