Add new row in xml file using asp.net c#

Hello.

I am trying to add new row in xml file but my code is not working can any guide me about my code?

my back end code is:

DataSet Xds = new DataSet();

Xds.ReadXml(Server.MapPath("~/Student_ExamPaper_xml/" + Student_Question_paper_xml + ".xml"));

DataRow Xrow = Xds.Tables[0].NewRow();

Xrow["Question_ID"] = "Question_" + question_id;

Xrow["Question_detail"] = Question_detail.Text;

Xrow["Option_1"] = Question_detail.Text;

Xrow["Option_2"] = Question_detail.Text;

Xrow["Option_3"] = Question_detail.Text;

Xrow["Option_4"] = Question_detail.Text;

Xrow["Radion_Button_index"] = Question_detail.Text;

Xds.Tables[0].Rows.Add(Xrow);

Xds.AcceptChanges();

Xds.WriteXml(Server.MapPath("~/Student_ExamPaper_xml/" + Student_Question_paper_xml + ".xml"));

and xml fomrat:

What is the capital of INDIA?

Mumbai

Ranchi

Delhi

Kanpur

-1

Please Guide me.... thanks in advance

try
{
XDocument xmlDoc = XDocument.Load(Server.MapPath("Student_Question_paper_xml.xml"));
var result = from obj in xmlDoc.Elements("Questions").Elements("Questions") select obj;
xmlDoc.Element("Questions").Add(new XElement("Questions",
new XAttribute("Question_ID",txt.Text),
new XAttribute("Question_Detail", txt.Text),
new XAttribute("Option_1", txt.Text),
new XAttribute("Option_2", txt.Text),
new XAttribute("Option_3", txt.Text),
new XAttribute("Option_4", txt.Text),
new XAttribute("Radion_Button_index", index.text)
));
xmlDoc.Save(Server.MapPath("Register.xml"));
lblMsg.Text = "Record saved Successfully";
lblMsg.Style["color"] = "green";
}
catch (Exception ex)
{
lblMsg.Text = "Error";
lblMsg.Style["color"] = "red";

Load xml to grid or datatable

1 Reply

Know the answer? Post it — somebody with the same question will find it here.