Import XML file using file upload control in angular VS Code

after selecting xml which i consider is easy and can do by yourself send it to web Api controller using httpclient of angular and then follow below code

create a method where you are sending your xml file then use sql bulk copy to store it in sql table

"1">
IT
New York
"2">
HR
London
"3">
Payroll
Mumbai
"1">
Mark
Male
1
"2">
John
Male
1
"3">
Mary
Female
2
"4">
Steve
Male
2
"5">
Ben
Male
3
string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/Data.xml"));
DataTable dtDept = ds.Tables["Department"];
DataTable dtEmp = ds.Tables["Employee"];
con.Open();
using (SqlBulkCopy bc = new SqlBulkCopy(con))
{
bc.DestinationTableName = "Departments";
bc.ColumnMappings.Add("ID", "ID");
bc.ColumnMappings.Add("Name", "Name");
bc.ColumnMappings.Add("Location", "Location");
bc.WriteToServer(dtDept);
}
using (SqlBulkCopy bc = new SqlBulkCopy(con))
{
bc.DestinationTableName = "Employees";
bc.ColumnMappings.Add("ID", "ID");
bc.ColumnMappings.Add("Name", "Name");
bc.ColumnMappings.Add("Gender", "Gender");
bc.ColumnMappings.Add("DepartmentId", "DepartmentId");
bc.WriteToServer(dtEmp);
}
}

1 Reply

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

Sachin Singh5y ago
after selecting xml which i consider is easy and can do by yourself send it to web Api controller using httpclient of angular and then follow below code
create a method where you are sending your xml file then use sql bulk copy to store it in sql table
  "1">
    IT
    New York

  "2">
    HR
    London

  "3">
    Payroll
    Mumbai

  "1">
    Mark
    Male
    1

  "2">
    John
    Male
    1

  "3">
    Mary
    Female
    2

  "4">
    Steve
    Male
    2

  "5">
    Ben
    Male
    3



string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;

using (SqlConnection con = new SqlConnection(cs))
{
    DataSet ds = new DataSet();
    ds.ReadXml(Server.MapPath("~/Data.xml"));

    DataTable dtDept = ds.Tables["Department"];
    DataTable dtEmp = ds.Tables["Employee"];
    con.Open();
    using (SqlBulkCopy bc = new SqlBulkCopy(con))
    {
        bc.DestinationTableName = "Departments";
        bc.ColumnMappings.Add("ID", "ID");
        bc.ColumnMappings.Add("Name", "Name");
        bc.ColumnMappings.Add("Location", "Location");
        bc.WriteToServer(dtDept);
    }

    using (SqlBulkCopy bc = new SqlBulkCopy(con))
    {
        bc.DestinationTableName = "Employees";
        bc.ColumnMappings.Add("ID", "ID");
        bc.ColumnMappings.Add("Name", "Name");
        bc.ColumnMappings.Add("Gender", "Gender");
        bc.ColumnMappings.Add("DepartmentId", "DepartmentId");
        bc.WriteToServer(dtEmp);
    }
}
0