c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
asp.net MVC

How to edit xml file using asp.net c# MVC?

| | ASP-NET , CSharp

In this article I will show you how to modify xml file using asp.net c# mvc. I have xml file with column fields such as id, paragraph, link etc.

I created class file for xml column fields.

public class homecontent
{
    private string mId;
    private string mHeading;
    private string mParagraph;
    private string mParagraph2;
    private string mLink;
    public string Id
    {
        get { return mId; }
        set { mId = value; }
    }

    public string Heading
    {
        get { return mHeading; }
        set { mHeading = value; }
    }
 
   public string Paragraph
    {
        get { return mParagraph; }
        set { mParagraph = value; }
    }
    public string Paragraph2
    {
        get { return mParagraph2; }
        set { mParagraph2 = value; }
    }
    public string Link
    {
        get { return mLink; }
        set { mLink = value; }
    }
}

View page:

<div class="control-group">
       <span class="custom-name-field">heading </span><span style="width: 200px">
               <input type="text" id="txtHeading" />
               <input type="hidden" id="hfdTextId" />
       </span>
</div>
<div class="control-group">
       <span class="custom-name-field">paragraph </span><span style="width: 200px">
              <textarea cols="3" rows="3" id="txtparagraph" ></textarea>
       </span>
</div>
<div class="control-group">
       <span class="custom-name-field">paragraph2 </span><span style="width: 200px">
              <textarea cols="3" rows="3" id="txtparagraph2" ></textarea>
                       
     </span>
</div>
<div class="control-group">
       <span class="custom-name-field">Link </span><span style="width: 200px">
       <input type="text" id="txtLink" />
</span>
</div>
<div id="divProgressText" class="prog" style="display: none; text-align: center">
      <img src="img/spinner.gif" height="30" width="30" align="middle" />
  </div>
<div class="modal-footer">
       <button class="btn btn-primary" aria-hidden="true" id="btnSaveText" onclick="javascript:returnSaveText();">
        Save</button>
  <button class="btn" id="btnCancelText" data-dismiss="modal">
        Cancel</button>
  </div>
<script type="text/javascript" src="//code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript">
function SaveText() {
 
        var dataObject = { Id: $("#hfdTextId").val(), Heading: $("#txtHeading").val(), Paragraph: $("#txtparagraph").val(), Paragraph2: $("#txtparagraph2").val(), Link: $("#txtLink").val() };
            dataObject =JSON.stringify(dataObject);
            $.ajax({
                url: '@Url.Action("Index", "Home", new { area = "Admin" })',
               type: 'POST',
                data: dataObject,
                contentType: 'application/json; charset=utf-8',
                dataType: 'json',
                success: function (response) {
                        $('#myModal').modal('hide');
                       // BindGrid();
                        $('.errorBlock').html(response);
                        $('.errorBlock').show();
                },
                error: function (xhr, ajaxOptions,thrownError) {
                    $(".errorBlockMain").html(xhr.responseText);
                    $(".errorBlockMain").show();
                    $('.prog').hide();
 
                }
            });
     }
 
    function openText(Id) {
 
        $(".errorBlock").hide();
        $.ajax({
            type: 'POST',
            url: '@Url.Action("EditText", "Home", new { area = "Admin" })',
            data: "{'Id' : " + Id + "}",
            contentType: 'application/json;charset=utf-8',
            dataType: 'json',
 
            success: function (response) {
                $('#myModalText').modal('show');
                $("#hfdTextId").val(response.Id);
                $("#txtHeading").val(response.Heading);
                $("#txtparagraph").val(response.Paragraph);
                $("#txtparagraph2").val(response.Paragraph2);
                $("#txtLink").val(response.Link);
             },
            error: function (xhr, ajaxOptions,thrownError) {
                $(".errorBlock").html(xhr.responseText);
                $(".errorBlock").show();
             }
        });
    }
</script>

Home Controller:

  [HttpPost]
        public ActionResult Index(homecontent homecontent)
        {
            string message = "";
            DataSet ds = new DataSet();
            ds.ReadXml(Server.MapPath("~/Areas/Admin/xmlData/Home.xml"));
            var rowsToUpdate = ds.Tables[0].AsEnumerable().Where(r =>r.Field<string>("Id") ==homecontent.Id);
            foreach (var row in rowsToUpdate)
            {
                row.SetField("heading",homecontent.Heading);
                row.SetField("paragraph",homecontent.Paragraph);
                row.SetField("paragraph2",homecontent.Paragraph2);
                row.SetField("link",homecontent.Link);
                message = "Record updated Successfully.";
            }
            ds.WriteXml(Server.MapPath("~/Areas/Admin/xmlData/Home.xml"));
             if (Request.IsAjaxRequest())
            {
                return Json(message, JsonRequestBehavior.AllowGet);
            }
            else
            {
                return RedirectToAction("Index", "Home", new { area = "Admin" });
            }
        }

       [HttpPost]
        public ActionResult EditText(string Id)
        {
            DataSet ds = new DataSet();
            ds.ReadXml(Server.MapPath("~/Areas/Admin/xmlData/Home.xml"));
            IEnumerable<DataRow> rowDetails = from DataRow row in ds.Tables[0].Rows
                                              where row.Field<string>(0) == Id
                                              select row;
            homecontent homecontent=new homecontent();
 
           homecontent.Id=Convert.ToString(rowDetails.ElementAt(0).ItemArray[0]);
           homecontent.Heading = Convert.ToString(rowDetails.ElementAt(0).ItemArray[1]);
           homecontent.Paragraph = Convert.ToString(rowDetails.ElementAt(0).ItemArray[2]);
           homecontent.Paragraph2 = Convert.ToString(rowDetails.ElementAt(0).ItemArray[3]);
           homecontent.Link = Convert.ToString(rowDetails.ElementAt(0).ItemArray[4]);
            if (Request.IsAjaxRequest())
            {
                return Json(homecontent, JsonRequestBehavior.AllowGet);
            }
            else
            {
                return RedirectToAction("Index", "Home", new { area = "Admin" });
            }
        }

Description:

When you edit the record by clicking the save button, the controller receives the objects.  You can identify which record to update xml file by finding the record using the linq by column id.

 

Output (Records updated):