批量插入SQL查询，用于XML文件 [英] Bulk insert SQL query , for XML file

问题描述

如何从XML文件批量插入XML数据没有重复insert into语句，这里我用于每个循环..如何将所有数据从XML文件插入到单个执行的SQL中。



我尝试过的事情：

how to bulk insert XML data's from XML file With out Repeating the insert into statement,here i am using for each loop..how to insert all data's from XML file To SQL with single execution.

What I have tried:

<pre lang="c#">  protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"user id=sa;password=ssa;database=Mohan;data source=PCTH101\PCTH101");
            con.Open();
            XmlDocument doc = new XmlDocument();
            doc.Load("d:/mohan/CHG_829_RPT_XML_PRD_SPEC_FINAL_2015-08-17-0908.xml");
            XmlNodeList nodes = doc.DocumentElement.SelectNodes("/fsxml/report/object/FSFORMULADOC");
            string docid = "", funcode = "" ,description = "" ,formulacode = "",funlabel = "";
            foreach (XmlNode node in nodes)
            {
                docid = node.SelectSingleNode("DOC_ID").InnerText;
                funcode = node.SelectSingleNode("FUNCTION_CODE").InnerText;
                description = node.SelectSingleNode("DOC_DESCRIPTION").InnerText;
                formulacode = node.SelectSingleNode("FORMULA_CODE").InnerText;
                funlabel = node.SelectSingleNode("FUNCTION_CODE_LABEL").InnerText;
                SqlCommand cmd = new SqlCommand("Insert  INTO xml1(docid,funcode,description,formulacode,funlabel) values(@docid, @funcode,@description,@formulacode,@funlabel)", con);
                cmd.Parameters.AddWithValue("@docid", docid);
                cmd.Parameters.AddWithValue("@funcode", funcode);
                cmd.Parameters.AddWithValue("@description", description);
                cmd.Parameters.AddWithValue("@formulacode", formulacode);
                cmd.Parameters.AddWithValue("@funlabel", funlabel);

                cmd.ExecuteNonQuery();
                Label1.Text = "Uploaded Successfully,Check database for Inserted Data's";
                Label1.Visible = true;


            }

推荐答案

您是否需要自己编写代码？对此，可以快速且重复地使用名为Linx 5的工具而无需编码。您可以将XML读入工具并获取整个数据结构，然后可以将其写入您想要的任何数据库（SQL，MySQL，Oracle等）。



您可以在 Linx 5 - 欢迎 [ ^ ]

这篇关于批量插入SQL查询，用于XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！