Import XML file using file upload control in angular VS Code

Question

Hi All, Any one tell me how to import a XML file into SQL Server using Angular VS Code having one component using file upload control we can choose XML once file is selected need to import XML data into SQL Table anyone tell me how to achieve the above point using angular project VS code editor

Sachin Singh · Answer

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); } }