XMLRead.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Xml;

using System.IO;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

getContent();

}

}

protected void btnsearch_Click(object sender, EventArgs e)

{

btnup.Visible = true;

btndel.Visible = true;

FileStream fs = new FileStream(@"C:\Documents and Settings\rajshree\Desktop\Library.xml", FileMode.Open, FileAccess.ReadWrite);

XmlDocument doc1 = new XmlDocument();

doc1.Load(fs);

XmlNodeList nodeList = doc1.SelectNodes("/catalog/book[@id='" + ddBookId.SelectedItem.Text + "']");

if (nodeList.Count > 0)

{

txtid.Text = ddBookId.SelectedItem.Text;

txtauthor.Text = nodeList[0].ChildNodes[0].InnerText;

txttitle.Text = nodeList[0].ChildNodes[1].InnerText;

txtgen.Text = nodeList[0].ChildNodes[2].InnerText;

txtprice.Text = nodeList[0].ChildNodes[3].InnerText;

txtpub.Text = nodeList[0].ChildNodes[4].InnerText;

txtdesc.Text = nodeList[0].ChildNodes[5].InnerText;

}

fs.Close();

}

protected void getContent()

{

//XmlTextReader xr=new XmlTextReader(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

//while (xr.Read())

//{

// if (xr.HasAttributes)

// {

// for (int i = 0; i < xr.AttributeCount; i++)

// {

// ddBookId.Items.Add(xr[i]);

// }

// ddBookId.DataBind();

// }

//}

//xr.Close();

XmlDocument doc = new XmlDocument();

doc.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNodeList nodeList = doc.SelectNodes("/catalog/book");

foreach (XmlElement book in doc.SelectNodes(@"catalog/book"))

{

ddBookId.Items.Add(book.GetAttribute("id"));

}

}

protected void btnadd_Click(object sender, EventArgs e)

{

XmlDocument doc = new XmlDocument();

doc.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlElement root = doc.CreateElement("book");

root.SetAttribute("id", txtid.Text);

XmlElement title = doc.CreateElement("title");

XmlElement author = doc.CreateElement("author");

XmlElement genre = doc.CreateElement("genre");

XmlElement price = doc.CreateElement("price");

XmlElement publish_date = doc.CreateElement("publish_date");

XmlElement description = doc.CreateElement("description");

title.InnerText = txttitle.Text;

author.InnerText = txtauthor.Text;

genre.InnerText = txtgen.Text;

price.InnerText = txtprice.Text;

publish_date.InnerText = txtpub.Text;

description.InnerText = txtdesc.Text; ;

root.AppendChild(author);

root.AppendChild(title);

root.AppendChild(genre);

root.AppendChild(price);

root.AppendChild(publish_date);

root.AppendChild(description);

doc.DocumentElement.AppendChild(root);

doc.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

lblerror.Text = "Element has been added successfully";

lblerror.Visible = true;

txtauthor.Text = "";

txttitle.Text = "";

txtdesc.Text = "";

txtgen.Text = "";

txtid.Text = "";

txtprice.Text = "";

txtpub.Text = "";

}

protected void btnup_Click(object sender, EventArgs e)

{

XmlDocument doc1 = new XmlDocument();

doc1.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNodeList nodeList = doc1.SelectNodes("/catalog/book[@id='" + ddBookId.SelectedItem.Text + "']");

nodeList[0].ChildNodes[4].InnerText = txtpub.Text;

doc1.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

lblerror.Visible = true;

lblerror.Text = "Updated Successfully";

txtauthor.Text = "";

txttitle.Text = "";

txtdesc.Text = "";

txtgen.Text = "";

txtid.Text = "";

txtprice.Text = "";

txtpub.Text = "";

}

protected void btndel_Click(object sender, EventArgs e)

{

XmlDocument doc2 = new XmlDocument();

doc2.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNode nodeList = doc2.SelectSingleNode("/catalog/book[@id='" + ddBookId.SelectedItem.Text + "']");

doc2.DocumentElement.RemoveChild(nodeList);

doc2.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

lblerror.Text = "Deleted Successfully";

lblerror.Visible = true;

txtauthor.Text = "";

txttitle.Text = "";

txtdesc.Text = "";

txtgen.Text = "";

txtid.Text = "";

txtprice.Text = "";

txtpub.Text = "";

}
}

ExWithGrid.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Xml;

using System.Data;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

getdata();

}

}

private void getdata()

{

DataSet ds = new DataSet();

ds.ReadXml(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

GridView1.DataSource = ds;

GridView1.DataBind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];

string id = row.Cells[1].Text.Trim();

XmlDocument doc2 = new XmlDocument();

doc2.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNode nodeList = doc2.SelectSingleNode("/catalog/book[@id='" + id + "']");

doc2.DocumentElement.RemoveChild(nodeList);

doc2.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

getdata();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

getdata();

}

protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)

{

getdata();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];

string pub = row.Cells[6].Text.Trim();

XmlDocument doc1 = new XmlDocument();

doc1.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNodeList nodeList = doc1.SelectNodes("/catalog/book[@id='" + row.Cells[1].Text + "']");

nodeList[0].ChildNodes[4].InnerText = pub;

doc1.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

getdata();

}

protected void GridView1_RowUpdating1(object sender, GridViewUpdateEventArgs e)

{

GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];

string pub = (row.Cells[6].Controls[0] as TextBox).Text;

string a = row.Cells[2].Text;

XmlDocument doc1 = new XmlDocument();

doc1.Load(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

XmlNodeList nodeList = doc1.SelectNodes("/catalog/book[@id='" + row.Cells[1].Text + "']");

nodeList[0].ChildNodes[4].InnerText = pub;

doc1.Save(@"C:\Documents and Settings\rajshree\Desktop\Library.xml");

getdata();

}

protected void GridView1_RowCancelingEdit1(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

getdata();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

getdata();

}

}