Click here to Skip to main content
15,886,919 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to create xml from given excel file and then that xml data should be inserted into database. It is generating XML file and save it on given location now I have read file into data set but this dataset I want to insert into database


I am using Windows form application

What I have tried:

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";



How to Insert data of data set to sql server I have searched on google but it is using data adapter but here i can not use data adapter so would you provide solution for ny problem please
Posted
Updated 20-Feb-18 19:15pm

1 solution

Seems you have missed to write data to server after doing the mapping.
Add following line to the last and see if that works-
C#
sbc.WriteToServer(reportData.Tables[0]);


Please let me know the result.

Hope, it helps :)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900