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

Comments

Popular posts from this blog

How to write Pure java script Program?