How to read write data from xml to database and database to xml
If we can read data from dataset to xmlfile
...............................................................................
using System.Data;
using System.Xml;
using System.Data.SqlClient;
protected void Page_Load(object sender, EventArgs e)
{
GetEmployeeDatafromDatabase();
}
public void GetEmployeeDatafromDatabase()
{
SqlConnection con = new SqlConnection(" Data Source=192.168.200.77;Initial Catalog=pluto;User ID=sa;Password=indi123;Connection Timeout=1500;Connection Lifetime=0;Min Pool Size=1;Max Pool Size=400;Pooling=true;");
SqlDataAdapter da = new SqlDataAdapter("Select * from Employee", con);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(dt);
da.Fill(ds);
ds.WriteXml(@"D:/Sreenivas-964241153-BackUp/XmlDataSample/XmlDataSample/Data/Datatable.XML");
}
2: write data from XML file to Dataset
.........................................................................
using System.Data;
using System.Xml;
using System.Data.SqlClient;
namespace XmlDataSample
{
public partial class ConvertXml : System.Web.UI.Page
{
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.ReadXml(@"D:/Sreenivas-964241153-BackUp/XmlDataSample/XmlDataSample/Data/Datatable.XML");
gvData.DataSource = ds;
gvData.DataBind();
}
}
}
...............................................................................
using System.Data;
using System.Xml;
using System.Data.SqlClient;
protected void Page_Load(object sender, EventArgs e)
{
GetEmployeeDatafromDatabase();
}
public void GetEmployeeDatafromDatabase()
{
SqlConnection con = new SqlConnection(" Data Source=192.168.200.77;Initial Catalog=pluto;User ID=sa;Password=indi123;Connection Timeout=1500;Connection Lifetime=0;Min Pool Size=1;Max Pool Size=400;Pooling=true;");
SqlDataAdapter da = new SqlDataAdapter("Select * from Employee", con);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(dt);
da.Fill(ds);
ds.WriteXml(@"D:/Sreenivas-964241153-BackUp/XmlDataSample/XmlDataSample/Data/Datatable.XML");
}
2: write data from XML file to Dataset
.........................................................................
using System.Data;
using System.Xml;
using System.Data.SqlClient;
namespace XmlDataSample
{
public partial class ConvertXml : System.Web.UI.Page
{
protected void btnsave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.ReadXml(@"D:/Sreenivas-964241153-BackUp/XmlDataSample/XmlDataSample/Data/Datatable.XML");
gvData.DataSource = ds;
gvData.DataBind();
}
}
}
Comments
Post a Comment