string fsReadXml = savefiledialog.ToString(); int i = fsReadXml.IndexOf('\\'); if (i >= 0) fsReadXml = fsReadXml.Substring(i - 2); // here I am getting path of XML file DataSet reportData = new DataSet(); reportData.ReadXml(fsReadXml); // Xml file data is loaded in dataset //reportData.ReadXml(Server.MapPath("yourfile.xml")); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString); SqlBulkCopy sbc = new SqlBulkCopy(connection); sbc.DestinationTableName = "tblCompanyData12"; sbc.ColumnMappings.Add("Sales", "Sales"); sbc.ColumnMappings.Add("TradedSales", "TradedSales"); sbc.ColumnMappings.Add("TotalSales", "TotalSales"); sbc.ColumnMappings.Add("Taxes", "Taxes"); sbc.ColumnMappings.Add("NetSales", "NetSales"); sbc.ColumnMappings.Add("RowMaterial", "RowMaterial"); sbc.ColumnMappings.Add("Power", "Power"); sbc.ColumnMappings.Add("Consumables", "Consumables"); sbc.ColumnMappings.Add("Salaries", "Salaries"); sbc.ColumnMappings.Add("ManufacturingCost", "ManufacturingCost"); sbc.ColumnMappings.Add("OtherExpenses", "OtherExpenses"); sbc.ColumnMappings.Add("TotalCost", "TotalCost"); sbc.ColumnMappings.Add("OperatingProfit", "OperatingProfit"); sbc.ColumnMappings.Add("Depreciation", "Depreciation"); sbc.ColumnMappings.Add("Interest", "Interest"); sbc.ColumnMappings.Add("Profitpostinterest", "Profitpostinterest"); sbc.ColumnMappings.Add("IncomeTax", "IncomeTax"); sbc.ColumnMappings.Add("NetProfit", "NetProfit"); sbc.ColumnMappings.Add("ID", "ID"); label1.Text = "File Saved Successfully";
sbc.WriteToServer(reportData.Tables[0]);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)