Import XML data to Database in ASP.Net

Hi Vikash21,

Please refer below sample

XML

<?xml version="1.0" encoding="utf-8" ?>
<Records>
  <Record contentId="1234" levelId="11" levelGuid="xxxx-yyyy-zzzz" moduleId="11" parentId="1">
    <Field id="111" guid="xx=xx-yy-dd" type="1">My Live Portal</Field>
    <Field id="222" guid="dddd-ff-rr-yy" type="3">22222</Field>
    <Field id="333" guid="eeee-fff-gg-yy" type="8">
      <Users>
        <User id="1111" firstName="Kumar" lastName="Vikas">Vikas</User>
      </Users>
      <Groups />
    </Field>
    <Field id="444" guid="0000-ffff-ooo" type="3">
      <ListValues>
        <ListValue id="147" displayName="In Phase">In Phase</ListValue>
      </ListValues>
    </Field>
    <Field id="555" guid="0000-880-xx" type="4">
      <ListValues>
        <ListValue id="258" displayName="In Built">In Built</ListValue>
      </ListValues>
    </Field>
    <Field id="666" guid="aa-bb-cc-dd-ee" type="4">
      <ListValues>
        <ListValue id="369" displayName="Completed">Completed</ListValue>
      </ListValues>
    </Field>
  </Record>
  <Record contentId="5678" levelId="22" levelGuid="xxxx-yyyy-zzzz" moduleId="22" parentId="2">
    <Field id="1111" guid="xx=xx-yy-dd" type="1">My Live Portal</Field>
    <Field id="2222" guid="dddd-ff-rr-yy" type="3">22222</Field>
    <Field id="3333" guid="eeee-fff-gg-yy" type="8">
      <Users>
        <User id="2222" firstName="Kumar" lastName="Surav">Surav</User>
      </Users>
      <Groups />
    </Field>
    <Field id="4444" guid="0000-ffff-ooo" type="3">
      <ListValues>
        <ListValue id="123" displayName="In Phase">In Phase</ListValue>
      </ListValues>
    </Field>
    <Field id="5555" guid="0000-880-xx" type="4">
      <ListValues>
        <ListValue id="456" displayName="In Built">In Built</ListValue>
      </ListValues>
    </Field>
    <Field id="6666" guid="aa-bb-cc-dd-ee" type="4">
      <ListValues>
        <ListValue id="789" displayName="Completed">Completed</ListValue>
      </ListValues>
    </Field>
  </Record>
</Records>

Namespace

C#

using System.Data;

Code

C#

protected void btnSubmit_Click(object sender, EventArgs e)
{
    string FilePath = Server.MapPath("~/XMLFile.xml");
    DataSet ds = new DataSet();
    ds.ReadXml(FilePath);
    DataTable dtRecords = ds.Tables["Record"];
    DataTable dtFields = ds.Tables["Field"];
    DataTable dtListValues = ds.Tables["ListValues"];
    DataTable dtListvalue = ds.Tables["ListValue"];
    DataTable dtUsers = ds.Tables["Users"];
    DataTable dtUser = ds.Tables["User"];

    var lists = (from record in dtRecords.AsEnumerable()
                    join field in dtFields.AsEnumerable() on record["Record_Id"] equals field["Record_Id"]
                    join listValues in dtListValues.AsEnumerable() on field["Field_Id"] equals listValues["Field_Id"]
                    join listValue in dtListvalue.AsEnumerable() on listValues["ListValues_Id"] equals listValue["ListValues_Id"]
                    select new { ID = field["id"], Guid = field["guid"], Type = field["type"], ParentId = record["parentId"] }).ToList();

    var userList = (from record in dtRecords.AsEnumerable()
                    join field in dtFields.AsEnumerable() on record["Record_Id"] equals field["Record_Id"]
                    join users in dtUsers.AsEnumerable() on field["Field_Id"] equals users["Field_Id"]
                    join user in dtUser.AsEnumerable() on users["Users_Id"] equals user["Users_Id"]
                    select new { ID = field["id"], Guid = field["guid"], Type = field["type"], ParentId = record["parentId"] }).ToList();

    DataTable dtUserList = new DataTable();
    dtUserList.Columns.Add("Id", typeof(int));
    dtUserList.Columns.Add("Guid", typeof(string));
    dtUserList.Columns.Add("Type", typeof(string));
    dtUserList.Columns.Add("ParentId", typeof(int));
    foreach (var rows in lists)
    {
        dtUserList.Rows.Add(rows.ID, rows.Guid, rows.Type, rows.ParentId);
    }
    foreach (var rows in userList)
    {
        dtUserList.Rows.Add(rows.ID, rows.Guid, rows.Type, rows.ParentId);
    }

    gvXML.DataSource = dtUserList;
    gvXML.DataBind();
}

Screenshot