---
title: "How to create XML file automatically when any new record is inserted in database in Asp.net MVC? Also delete and Update that XML file base on Record."
description: "How to create XML file automatically when any new record is inserted in database in Asp.net MVC? Also delete and Update that XML file base on Record."
author: "Steilla Mitchel"
published: 2021-11-29
updated: 2023-08-22
canonical: https://answers.mindstick.com/qa/94215/how-to-create-xml-file-automatically-when-any-new-record-is-inserted-in-database-in-asp-dot-net-mvc-also-delete-and-update-that-xml-file-base-on-record
category: "asp.net"
tags: ["asp.net mvc", "asp.net"]
reading_time: 16 minutes
---
# How to create XML file automatically when any new record is inserted in database in Asp.net MVC? Also delete and Update that XML file base on Record.
How to create [XML file](https://www.mindstick.com/forum/360/how-to-read-xml-file-in-php) automatically when any new record is inserted in [database in Asp.net](https://www.mindstick.com/forum/158707/what-are-the-different-methods-available-for-connecting-to-a-database-in-asp-dot-net-mvc) [MVC](https://www.mindstick.com/articles/23249/rdlc-report-in-mvc-application)? Also [delete](https://www.mindstick.com/forum/159778/what-is-the-delete-statement-in-sql-and-how-is-it-used-to-remove-data-from-a-table) and [Update](https://www.mindstick.com/forum/156355/what-is-google-pigeon-update) that XML file when Record is delete or update.
## Answers
### Answer by user
**[Asp.net MVC](https://www.mindstick.com/articles/1580/ajax-with-asp-dot-net-mvc) code for create, update and delete automatically [Xml](https://www.mindstick.com/articles/178/xml-control-in-asp-dot-net) [file](https://www.mindstick.com/articles/59/encrypting-and-decrypting-files-using-c-sharp) from folder based on Record.** Sometimes we need to create automatically xml file of every new when insert into [database](https://www.mindstick.com/articles/100/windows-service-to-update-record-from-one-database-to-another-after-certain-interval-of-time). After create xml file of every record we want to update them automatically when any user update his/her record from webpage and also delete Xml file automatically when any record is deleted from page. Lets start, all process performed in Visual Studio with SQL Sercer database connectivity. Asp.net MVC code for create Xml file when any new record is inserted. View Page code,
```
@model DemoXMLXML.Models.StudentRecordDetails
@{
ViewBag.Title = 'Student';
}
@using (Html.BeginForm('AddStudent', 'Student', FormMethod.Post))
{
@Html.TextBoxFor(x => x.stuName, new { @class = 'form-control' })
@Html.TextBoxFor(x => x.stuCourse, new { @class = 'form-control' })
@Html.TextBoxFor(x => x.stuAge, new { @class = 'form-control' })
@Html.TextBoxFor(x => x.stuMarks, new { @class = 'form-control' })
}
```
The page look like as follow, \
 \
**Model page code of this page,**
```
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
namespace DemoXMLXML.Models
{
[MetadataType(typeof(StudentRecordDetails))]
public partial class StudentRecord
{
}
public class StudentRecordDetails
{
[Required(ErrorMessage = 'Requered')]
public int stuID { get; set; }
[Required(ErrorMessage = 'Requered')]
public string stuName { get; set; }
[Required(ErrorMessage = 'Requered')]
public string stuCourse { get; set; }
[Required(ErrorMessage = 'Requered')]
public Nullable stuAge { get; set; }
[Required(ErrorMessage = 'Requered')]
public Nullable stuMarks { get; set; }
}
}
Controller page code,
Asp.net MVC code for creating automatically xml file,
//Creating new xml file of every new users
private void CreateXml()
{
XmlDocument doc = new XmlDocument();
XmlNode docNode = doc.CreateXmlDeclaration('1.0', 'UTF-8', null);
doc.AppendChild(docNode);
XmlElement studentDataNode = doc.CreateElement('StudentData');
(studentDataNode).SetAttribute('xmlns:xsd', 'https://www.mindstick.com');
doc.AppendChild(studentDataNode);
XmlNode StudentRecords = doc.CreateElement('StudentRecords');
studentDataNode.AppendChild(StudentRecords);
XmlNode StudentRecord = doc.CreateElement('Record');
StudentRecords.AppendChild(StudentRecord);
XmlNode StudentName = doc.CreateElement('StudentName');
StudentName.AppendChild(doc.CreateTextNode(stu.stuName));
StudentRecord.AppendChild(StudentName);
XmlNode StudentType = doc.CreateElement('StudentType');
StudentType.AppendChild(doc.CreateTextNode(stu.stuCourse));
StudentRecord.AppendChild(StudentType);
XmlNode studentAge = doc.CreateElement('StudentAge');
studentAge.AppendChild(doc.CreateTextNode(stu.stuAge.ToString()));
StudentRecord.AppendChild(studentAge);
XmlNode studentMarks = doc.CreateElement('StudentMarks');
studentMarks.AppendChild(doc.CreateTextNode(stu.stuMarks.ToString()));
StudentRecord.AppendChild(studentMarks);
//location of folder where xml file save.
var basepath = Path.Combine(Environment.CurrentDirectory, @'C:\Verma\C# Folder\XML Files');
// if folder is not exists then create
if (!Directory.Exists(basepath))
{
Directory.CreateDirectory(basepath);
}
//create every xml file name by student id with .xml extension
var newFile = string.Format('{0}{1}', stu.stuID.ToString(), '.xml');
string fileName = basepath + '\\' + newFile;
//save xml file
doc.Save(fileName);
}
```
**Add new record in database table StudentRecords,**
```
public ActionResult AddStudent(StudentRecordDetails model)
{
stu = new StudentRecord();
stu.stuID = model.stuID;
stu.stuName = model.stuName;
stu.stuCourse = model.stuCourse;
stu.stuAge = model.stuAge;
stu.stuMarks = model.stuMarks;
using (_db = new MyCollegeDbEntities())
{
//insert new record into database
_db.StudentRecords.Add(stu);
_db.SaveChanges();
CreateXml();
}
}
```
If any user’s data is already exist in database and want to update record/data then xml file also will update as well as database table is update.
```
public ActionResult AddStudent(StudentRecordDetails model)
{
stu = new StudentRecord();
stu.stuID = model.stuID;
stu.stuName = model.stuName;
stu.stuCourse = model.stuCourse;
stu.stuAge = model.stuAge;
stu.stuMarks = model.stuMarks;
using (_db = new MyCollegeDbEntities())
{
StudentRecord data = _db.StudentRecords.Where(x => x.stuID == stu.stuID).SingleOrDefault();
if(data == null)
{
//insert new record into database
_db.StudentRecords.Add(stu);
_db.SaveChanges();
CreateXml();
}
//update if records is already exists in database.
else
{
//udate record when user want to update data.
data.stuName = stu.stuName;
data.stuCourse = stu.stuCourse;
data.stuAge = stu.stuAge;
data.stuMarks = stu.stuMarks;
//xml file with its location
string path = @'C:\Verma\C# Folder\XML Files\'+Convert.ToString(data.stuID)+'.xml';
//if particulat xml file is exists in folder then update
if (System.IO.File.Exists(path))
{
XmlDocument doc = new XmlDocument();
//Load file in Xml document
doc.Load(path);
//select xml node(tags) where student name
XmlNode nodeName = doc.SelectSingleNode('/StudentData/StudentRecords/Record/StudentName');
//update name
nodeName.InnerText=data.stuName;
//select xml node(tags) where student Course
XmlNode nodeCourse = doc.SelectSingleNode('/StudentData/StudentRecords/Record/StudentType');
//update CourseName
nodeCourse.InnerText = data.stuCourse;
//select xml node(tags) where student Age
XmlNode nodeAge = doc.SelectSingleNode('/StudentData/StudentRecords/Record/StudentAge');
//update Age
nodeAge.InnerText = data.stuAge.ToString();
//select xml node(tags) where student Marks
XmlNode nodeMarks = doc.SelectSingleNode('/StudentData/StudentRecords/Record/StudentMarks');
//update Marks
nodeMarks.InnerText = data.stuMarks.ToString();
doc.Save(path);
_db.SaveChanges(); }
}
}
return View('Student');
}
```
Now we have create a list of all student record and show it in a view page,
```
public ActionResult StudentList()
{
using (var db = new MyCollegeDbEntities())
{
//create a list of student record from database table
List collection = db.StudentRecords.AsEnumerable().ToList();
ViewBag.data = collection;
}
return View();
}
```
View page source code is as, here all records is added one by one in list from database table.
```
@{
ViewBag.Title = 'StudentList';
}