xml导入数据库

最新推荐文章于 2023-12-14 10:00:00 发布

Turboooooo

最新推荐文章于 2023-12-14 10:00:00 发布

阅读量267

点赞数

分类专栏： C#学习文章标签：数据库 xml java

本文链接：https://blog.csdn.net/weixin_46533220/article/details/129725650

版权

C#学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

xml导入数据库

string xmlurl = @"D:\student.xml";
            string sqlconn = "Integrated Security=SSPI;Initial Catalog=students;Data Source=TURBO";

            XmlDocument doc = new XmlDocument();
            doc.Load(xmlurl);
            XmlElement ele = doc.DocumentElement;
            XmlNodeList list = ele.ChildNodes;

            SqlConnection conn = new SqlConnection(sqlconn);
            conn.Open();

            foreach (XmlNode node in list)
            {
                string id = node.ChildNodes[0].InnerText.ToString();
                string name = node.ChildNodes[1].InnerText.ToString();
                string sex = node.ChildNodes[2].InnerText.ToString();
                string sqlstr = "insert into 学生表 values('" + id + "','" + name + "','" + sex + "')";
                SqlCommand cmd = new SqlCommand(sqlstr, conn);
                try
                {
                    cmd.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    Console.WriteLine("操作错误");
                }
                
            }
            conn.Close();