c#xml-txt相互转换以及导入数据库

已于 2023-03-24 18:05:17 修改
阅读量307 收藏
点赞数 1
文章标签： c# 数据库 xml Powered by 金山文档
于 2023-03-24 00:16:18 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_58835361/article/details/129742266
版权 
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Xml;
using System.Xml.Serialization;

namespace Demo
{
    internal class Program
    {
             //创建连接
            SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            scsb.DataSource = "REOORO";
            scsb.UserID = "sa";
            scsb.Password = "19858184859";
            scsb.InitialCatalog = "library";
            
            //判断连接是否打开
            SqlConnection conn = new SqlConnection(scsb.ToString());//参数是连接数据库的字符串
            if(conn.State == System.Data.ConnectionState.Closed)
            {
            conn.Open();
            }

        static void Main(string[] args)
        {

            //xml to txt 并按成绩降序
            string str = File.ReadAllText("D:\研究生复试李泽平\xml\xml最终版\xml-txt\\Data.xml");
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List<Grade> grades = new List<Grade>();
            foreach (XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    Id = node.SelectSingleNode("id").InnerText,
                    Name = node.SelectSingleNode("name").InnerText,
                    Course = node.SelectSingleNode("course").InnerText,
                    Score = int.Parse(node.SelectSingleNode("score").InnerText),
                });
            }

            List<Grade> result = grades.OrderByDescending(x => x.Score).ToList();
            StringBuilder sb = new StringBuilder();
            foreach (Grade grade in result) 
            {
                sb.Append($"{grade.Id},{grade.Name},{grade.Course},{grade.Score}\n");
            }

            File.WriteAllText("D:\研究生复试李泽平\xml\xml最终版\xml-txt\\Data.txt", sb.ToString());

            
            //SqlConnection sqlConnection = new SqlConnection();
            //sqlConnection.ConnectionString = connString;
            //sqlConnection.Open();

            生成插入的sql语句
            //StringBuilder sql = new StringBuilder();
            //sql.Append("Insert Into grade values ");
            //foreach (Grade grade in result)
            //{
            //    sql.Append($"('{grade.Id}','{grade.Name}','{grade.Course}',{grade.Score}),");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0, sqlTxt.Length - 1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand sqlCommand = new SqlCommand(sqlTxt, sqlConnection);
            //var count = sqlCommand.ExecuteNonQuery();
            //sqlConnection.Close();
            

            //TXT转XML
            string[] txts = File.ReadAllLines("D:\研究生复试李泽平\xml\xml最终版\xml-txt\\Data.txt");
            List<Grade> grades1 = new List<Grade>();
            foreach (string txt in txts) 
            {
                string[] datas = txt.Split(",");
                grades1.Add(new Grade()
                {
                    Id = datas[0],
                    Name = datas[1],
                    Course = datas[2],
                    Score = int.Parse(datas[3]),
                });
            }

            MemoryStream memoryStream = new MemoryStream();
            XmlSerializer xmlSerializer = new XmlSerializer(typeof(List<Grade>),new XmlRootAttribute("Grades"));
            xmlSerializer.Serialize(memoryStream, grades1);
            memoryStream.Position = 0;
            StreamReader sr = new StreamReader(memoryStream);
            string data =sr.ReadToEnd();
            memoryStream.Close();
            File.WriteAllText("C:\\Users\\Bruce Qiu\\Desktop\\Data1.xml", data);
        }
    }

    public class Grade
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Course { get; set; }
        public int Score { get; set; }
    }
}
<?xml version="1.0"?>
<grades>
    <grade>
       <id>2019001</id>
       <name>张三</name>
       <course>机器学习</course>
       <score>85</score>
    </grade>
    <grade>
       <id>2019002</id>
       <name>李四</name>
       <course>操作系统</course>
       <score>90</score>
    </grade>
 <grade>
       <id>2019003</id>
       <name>王五</name>
       <course>数据结构</course>
       <score>95</score>
    </grade>
 <grade>
       <id>2019003</id>
       <name>刘六</name>
       <course>数据结构</course>
       <score>68</score>
    </grade>
 <grade>
       <id>2019003</id>
       <name>初七</name>
       <course>数据结构</course>
       <score>74</score>
    </grade>
 <grade>
       <id>2019003</id>
       <name>朱八</name>
       <course>数据结构</course>
       <score>100</score>
    </grade>
 <grade>
       <id>2019003</id>
       <name>李九</name>
       <course>数据结构</course>
       <score>69</score>
    </grade>
</grades>

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using static System.Net.Mime.MediaTypeNames;
using System.Diagnostics;
using System.Xml.Serialization;

namespace xml_txt
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //xml转txt
            //1.导入xml文件
            string str = File.ReadAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.xml");
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List<Grade> grades = new List<Grade>();
            foreach (XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    Id = node.SelectSingleNode("id").InnerText,
                    Name = node.SelectSingleNode("name").InnerText,
                    Crouse = node.SelectSingleNode("course").InnerText,
                    Score = int.Parse(node.SelectSingleNode("score").InnerText),
                });
            }
            List<Grade> result = grades.OrderByDescending(g => g.Score).ToList();
            StringBuilder sb = new StringBuilder();
            foreach (Grade grade in result)
            {
                sb.Append($"{grade.Id},{grade.Name},{grade.Crouse},{grade.Score}\n");
            }

            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt", sb.ToString());



            xml写入数据库
            创建连接
            //SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            //scsb.DataSource = "REOORO";
            //scsb.UserID = "sa";
            //scsb.Password = "19858184859";
            //scsb.InitialCatalog = "library";

            判断连接是否打开
            //SqlConnection conn = new SqlConnection(scsb.ToString());//参数是连接数据库的字符串
            //if (conn.State == System.Data.ConnectionState.Closed)
            //{
            //    conn.Open();
            //}

            //StringBuilder sql = new StringBuilder();
            //sql.Append("Insert into grade values");
            //foreach(Grade grade in result)
            //{
            //    sql.Append($"('{grade.Id}','{grade.Name}','{grade.Crouse}','{grade.Score}'),");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0,sqlTxt.Length-1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand sqlCommand = new SqlCommand(sqlTxt, conn);
            //sqlCommand.ExecuteNonQuery();




            //txt转xml
            //TXT转XML
            string[] txts = File.ReadAllLines("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt");
            List<Grade> grades1 = new List<Grade>();
            foreach (string txt in txts)
            {
                string[] datas = txt.Split(',');
                grades1.Add(new Grade()
                {
                    Id = datas[0],
                    Name = datas[1],
                    Crouse = datas[2],
                    Score = int.Parse(datas[3]),
                });
            }

            MemoryStream memoryStream = new MemoryStream();
            XmlSerializer xmlSerializer = new XmlSerializer(typeof(List<Grade>), new XmlRootAttribute("Grades"));
            xmlSerializer.Serialize(memoryStream, grades1);
            memoryStream.Position = 0;
            StreamReader sr = new StreamReader(memoryStream);
            string data = sr.ReadToEnd();
            memoryStream.Close();
            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data1.xml", data);
        }

    }

    public struct Grade
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Crouse { get; set; }
        public int Score { get; set; }

    }
}



using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using static System.Net.Mime.MediaTypeNames;
using System.Diagnostics;
using System.Xml.Serialization;

namespace xml_txt
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //xml转txt
            string str = File.ReadAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.xml");
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List < Grade > grades= new List<Grade>();
            foreach(XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    Id = node.SelectSingleNode("id").InnerText,
                    Name = node.SelectSingleNode("name").InnerText,
                    Crouse = node.SelectSingleNode("course").InnerText,
                    Score = int.Parse(node.SelectSingleNode("score").InnerText),
                });
            }

            //List<Grade> result = grades.OrderByDescending(g => g.Score).ToList();
            StringBuilder sb = new StringBuilder();
            foreach (Grade grade in grades)
            {
                sb.Append($"{grade.Id},{grade.Name},{grade.Crouse},{grade.Score}\n");
            }

            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt", sb.ToString());


            //xml导入数据库
            //1.连接数据库
            SqlConnectionStringBuilder scsb  = new SqlConnectionStringBuilder();
            scsb.DataSource = "REOORO";
            scsb.InitialCatalog = "library";
            scsb.UserID = "sa";
            scsb.Password = "19858184859";

            SqlConnection conn = new SqlConnection(scsb.ToString());
            if(conn.State != ConnectionState.Open)
            {
                conn.Open();
            }

            //导入数据库

            //StringBuilder sql = new StringBuilder();
            //sql.Append($"Insert into grade valuse");
            //foreach (Grade grade in grades)
            //{
            //    sql.Append ($"('{grade.Id }',)");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0,sqlTxt.Length - 1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand sc = new SqlCommand(sqlTxt, conn);
            //sc.ExecuteNonQuery();


            //txt转xml
            string[] txts = File.ReadAllLines("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt");
            List<Grade> grades1 = new List<Grade>();
            foreach(string  txt in txts)
            {
                string[] datas = txt.Split( ',' );
                grades1.Add(new Grade()
                {
                    Id = datas[0],
                    Name = datas[1],
                    Crouse = datas[2],
                    Score = int.Parse(datas[3]),

                });
            }
            MemoryStream ms = new MemoryStream();
            XmlSerializer xs = new XmlSerializer(typeof(List<Grade>),new XmlRootAttribute("Grades"));
            xs.Serialize(ms, grades1);
            ms.Position = 0;
            StreamReader sr = new StreamReader(ms);
            string data = sr.ReadToEnd();
            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data1.xml", data);


        }
    }
        

        public struct Grade
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Crouse { get; set; }
        public int Score { get; set; }

    }
 }

第四次

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using static System.Net.Mime.MediaTypeNames;
using System.Diagnostics;
using System.Xml.Serialization;

namespace xml_txt
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //xml转txt
            string str = File.ReadAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.xml");
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List<Grade> grades = new List<Grade>();
            foreach (XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    Id = node.SelectSingleNode("id").InnerText,
                    Name = node.SelectSingleNode("name").InnerText,
                    Crouse = node.SelectSingleNode("course").InnerText,
                    Score = int.Parse(node.SelectSingleNode("score").InnerText),
                }) ;
            }

            List<Grade> result = grades.OrderByDescending(g => g.Score).ToList();
            StringBuilder sb = new StringBuilder();
            foreach(Grade grade in result)
            {
                sb.Append($"{grade.Id},{grade.Name},{grade.Crouse},{grade.Score}\n");
            }

            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt",sb.ToString());

            xml导入数据库

            //SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            //scsb.DataSource = "REOORO";
            //scsb.InitialCatalog = "library";
            //scsb.UserID = "sa";
            //scsb.Password = "19858184859";

            //SqlConnection conn = new SqlConnection(scsb.ToString());
            //if (conn.State != ConnectionState.Open)
            //{
            //    conn.Open();
            //}

            //StringBuilder sql = new StringBuilder();
            //sql.Append("insert into library values");
            //foreach(Grade grade in grades)
            //{
            //    sql.Append($"('{grade.Id}','{grade.Name}','{grade.Crouse}','{grade.Score}'),");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0,sqlTxt.Length - 1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand sc = new SqlCommand(sqlTxt,conn);
            //sc.ExecuteNonQuery();

            //txt转xml
            //1.导入txt进数组
            string[] txts = File.ReadAllLines("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt");
            List<Grade> grades1 = new List<Grade>();
            foreach(string  txt in txts)
            {
                string[] data = txt.Split(',');
                grades1.Add(new Grade()
                {
                    Id = data[0],
                    Name = data[1],
                    Crouse = data[2],
                    Score = int.Parse(data[3]),

                });

                MemoryStream ms = new MemoryStream();
                XmlSerializer xs = new XmlSerializer(typeof(List<Grade>),new XmlRootAttribute("grades"));
                xs.Serialize(ms, grades1);
                ms.Position = 0;
                StreamReader sr = new StreamReader(ms);
                string datas = sr.ReadToEnd();
                File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data1.xml", datas);
            }



        }
    }

    public struct Grade
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Crouse { get; set; }
        public int Score { get; set; }

    }

}

第五次

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using static System.Net.Mime.MediaTypeNames;
using System.Diagnostics;
using System.Xml.Serialization;

namespace xml_txt
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //xml转txt
            //1.导入xml文件
            string str = File.ReadAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.xml");

            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List<Grade> grades = new List<Grade>();
            foreach (XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    Id = node.SelectSingleNode("id").InnerText,
                    Name = node.SelectSingleNode("name").InnerText,
                    Course = node.SelectSingleNode("course").InnerText,
                    Score = int.Parse(node.SelectSingleNode("score").InnerText),
                });
            }

            List<Grade> result = grades.OrderByDescending(g => g.Score).ToList();
            StringBuilder sb = new StringBuilder();
                foreach(Grade grade in result)
                {
                    sb.Append($"{grade.Id},{grade.Name},{grade.Course},{grade.Score}\n");
                }
                File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt", sb.ToString());
               

            xml导入数据库
            1.连接数据库
            //SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            //scsb.DataSource = "REOORO";
            //scsb.InitialCatalog = "library";
            //scsb.UserID = "sa";
            //scsb.Password = "19858184859";

            //SqlConnection conn = new SqlConnection(scsb.ToString());
            //if(conn.State != ConnectionState.Open)
            //{
            //    conn.Open();
            //}

            2.xml导入数据库
            //StringBuilder sql = new StringBuilder();
            //sql.Append("insert into grades values");
            //foreach (Grade grade in result)
            //{
            //    sql.Append($"('{grade.Id}','{grade.Name}','{grade.Course}','{grade.Score}'),");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0,sqlTxt.Length - 1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand sc = new SqlCommand(sqlTxt,conn);
            //sc.ExecuteNonQuery();


            //txt转xml
            //1.建一个字符串数组放txt内容
            string[] txts = File.ReadAllLines("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt"); 
            //申请一个Grade型List 
            List<Grade> grades1 = new List<Grade>();
            foreach(string  txt in txts)
            {
                string[] datas = txt.Split(',');
                grades1.Add(new Grade()
                {
                    Id = datas[0],
                    Name = datas[1],
                    Course = datas[2],
                    Score = int.Parse(datas[3]),
                });

                MemoryStream ms = new MemoryStream();
                XmlSerializer xs = new XmlSerializer(typeof(List<Grade>),new XmlRootAttribute("grades"));
                xs.Serialize(ms, grades1);
                ms.Position = 0;
                StreamReader sr = new StreamReader(ms);
                string data = sr.ReadToEnd();
                File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data1.xml", data);


            }


            }
        }
    public struct Grade
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Course { get; set; }

        public int Score { get; set; }
    }
}

第六次

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using static System.Net.Mime.MediaTypeNames;
using System.Diagnostics;
using System.Xml.Serialization;

namespace xml_txt
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //xml转txt
            string str = File.ReadAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.xml");
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(str);
            XmlNodeList nodes = xmlDoc.SelectNodes("grades//grade");
            List<Grade> grades = new List<Grade>();
            foreach (XmlNode node in nodes)
            {
                grades.Add(new Grade()
                {
                    id = node.SelectSingleNode("id").InnerText,
                    name = node.SelectSingleNode("name").InnerText,
                    course = node.SelectSingleNode("course").InnerText,
                    score = int.Parse(node.SelectSingleNode("score").InnerText),
                });
            }
            //降序
            List<Grade> result = grades.OrderByDescending(g => g.score).ToList();
            StringBuilder sb = new StringBuilder();
            foreach(Grade grade in result)
            {
                sb.Append($"{grade.id},{grade.name},{grade.course},{grade.score}\n");
            }
            File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt", sb.ToString());


            xml导入数据库
            //SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            //scsb.DataSource = "REOORO";
            //scsb.InitialCatalog = "library";
            //scsb.UserID = "sa";
            //scsb.Password = "19858184859";

            //SqlConnection conn = new SqlConnection(scsb.ToString());
            //if(conn.State != ConnectionState.Open)
            //{
            //    conn.Open();
            //}

            导入
            //StringBuilder sql = new StringBuilder();
            //sql.Append("insert into grades  values");
            //foreach(Grade grade in result)
            //{
            //    sql.Append($"'{grade.Id}','{grade.Name}',''{grade.Course},'{grade.Score}',");
            //}

            //string sqlTxt = sql.ToString();
            //sqlTxt = sqlTxt.Substring(0,sqlTxt.Length - 1);
            //sqlTxt = sqlTxt + ";";

            //SqlCommand cmd = new SqlCommand(sqlTxt, conn);
            //cmd.ExecuteNonQuery();


            //txt转xml
            string[] txts = File.ReadAllLines("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data.txt"); 
            List<Grade> grades1 = new List<Grade>();
            foreach(string txt in txts)
            {
                string[] datas = txt.Split(',');
                grades1.Add(new Grade()
                {
                    id = datas[0],
                    name = datas[1],
                    course = datas[2],
                    score = int.Parse(datas[3]),

                });

                MemoryStream ms = new MemoryStream();
                XmlSerializer xs = new XmlSerializer(typeof(List<Grade>),new XmlRootAttribute("grades"));
                xs.Serialize(ms, grades1);
                ms.Position = 0;
                StreamReader sr = new StreamReader(ms);
                string data = sr.ReadToEnd();
                File.WriteAllText("D:\\研究生复试李泽平\\xml\\xml最终版\\xml-txt\\Data1.xml", data);
            }
        }
        
    }

    public struct Grade
    {
        public string id { get; set;}
        public string name { get; set; }
        public string course { get; set; }
        public int score { get; set; }
    }
   
}
ImComingSCUT
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
C# TXT转换xml
09-26
C# TXT转换xml 源文件 有规格范例，更新目标是，直接读取网页，转成XML。希望大家多支持 多拍砖
C#中使用XML存储数据
Mengyu的博客
07-05 1861
C#中使用XML存储数据 使用微软所封装的XML方法 创建XML文档 首先引用System.Xml命名空间 1.初始化一个实例 XmlDocument xd = new XmlDocument(); 2.创建XML头文件声明 XmlDeclaration xdt = xd.CreateXmlDeclaration("1.0", "utf-8", null); xd.AppendChild(xdt); 3.创建唯一根节点 XmlElement Students = xd.CreateElement("S
如何将xml文件转txt （xml指定提取）
阿利同学的博客
10-09 5599
本文主要记录下自己将xml文件中有用的数据提取至txt的过程。在查找代码时发现，大都复制粘贴的代码，不仅冗余，而且晦涩难懂，于是自己整理了一套代码。不多说，直接图解。耐心看完保你会 #xml2txt
在C#中将xml格式的字符串转换成XmlTextReader
jianzhanger的专栏
04-06 3507
 string   s   =   "";请问如何将s－－－》XmlTextReaderstring   xmlFrag=@"   id=1//>";      //Create   the   XmlNamespaceManager.   NameTable   nt   =   new   NameTable();   XmlNamespaceManager   nsmgr   =
C#中XML、JSON、类T数据格式之间的转换
ylq1045的专栏
06-17 538
using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Xml; using System.Xml.Serialization; namespace HansForMes { /// <summary> /// XML与实例化类之间的转化 ...
xml文件转txt文件
loveking001的博客
08-02 758
【代码】xml文件转txt文件。
xml格式转txt格式
weixin_55491232的博客
08-08 626
【代码】xml格式转txt格式。
xml数据格式转txt数据格式
JulyLH的博客
11-15 357
以前标注了一批数据集是xml格式的，但是想用其他模型训练以下，然后模型需要的是txt类型的标签，那就搞段代码自己转换以下吧！！！
xml文件转成txt文件
zqq19980906_的博客
07-01 2586
xml文件转成txt文件。
xml转换txt格式代码
最新发布
qq_45874142的博客
08-29 407
只需要有一个xml文件即可直接转换为txt，简单方便又快捷，而且有进度条。默认保存路径是这个这个转换文件路径下的txt文件夹。
c#直接操作xml文件作为数据库
06-04
实现了XML文件的读写，与传统的读写方式不一样，采用的是XML序列化的读写方式，先将xml转化成List，再进行增删改，非常方便。
SQL Server中将数据导出为XML和Json方法分享
12-15
 在SQL Server 2005之后提供了一个for xml子句在关系数据库中原生支持XML。通过该命令可以将二维关系结果集转换为XML，通过BCP就可以将数据存为XML了。 例如下面的数据：    我们可以通过如下BCP命令（注意不能...
JsonToDB2 Json数据导入DB2工具 v2.0官方版
11-04
JsonToDB2是一款专业实用的Json数据导入DB2工具，软件能够帮助用户将需要使用的json数据快捷的导入到使用的aceess数据库上面，并且简单的操作方式，使用你的鼠标就可以完成所有的相关操作，而且转换的速度快。...
C#基类库大全下载--苏飞版
01-08
使用C#实现对Sql数据库的操作，执行存储过程，Sql语句，返回影响行数，返回DateTable,DataSet,DataReader,以及表集等方法。实现多个数据库的切换功能。功能强大，希望大家喜欢 2.一个操作Sql2005数据库的类（备份...
C#入门——面向对象等，代码+注释
12-10
第5天 00随机数 05数组 06数组的运用 06数组的运用：冒泡程序 07方法 01枚举 04结构 02枚举和int以及sting类型之间的转换 03枚举练习 第6天 01方法调用 判断是否为整数 yes或no 02方法练习求数组的和 03方法 out...
明日科技C#开发入门及项目实战
04-19
实例140 将access数据库导入excel文件中 第13章 水晶报表与打印 实例141 设计带有背景图的水晶报表 实例142 设置水晶报表的打印日期与时间 实例143 设置水晶报表中节的背景图片 实例144 打印窗体中的数据 实例145 ...
C# XML文本的输出
xiaoshuang_的博客
01-11 1102
其中文本文件的内容为： 1 烤鸡腿 100 2 驴肉火烧 200 3 爆炸丸子 300 主要的代码： 1 using System; 2 using System.Collections.Generic; 3 using Syst
C# 转换Text和Xml文件的encoding编码方式
蓝色范思哲的专栏
04-24 2491
在编程过程中经常会遇到Xml中的中文解析出错，成了乱码，原因是由于Xml文件的encoding编码方式不支持中文，比如encoding="ISO-8859-1"，如果将encoding改成"utf-8"即可正常解析中文，主要过程如下： /// /// 转换Xml文件的encoding编码方式 /// /// 转换前Xml文件路径 /// 转换后Xml文件路径 public void
C#实现XML大批量数据插入数据库
HerryDong的博客
11-10 1100
现有一XML文件，其中包含443676条信息，主要用于记录点的XY坐标。XML文件如下图所示： 现在需要将XML文件中的坐标信息导入SqlServer，数据表[TPoint]如下图所示，其中Id为自增主键，X和Y为float类型字段： 实现代码如下： using System; using System.Collections.Generic; using System.ComponentMo...
C# 实现XML和Excel相互转换
07-15
你可以使用 C# 中的 `OpenXML` 库来实现 XML 和 Excel 文件之间的相互转换。下面是一个简单的示例代码，演示了如何将 XML 数据导出到 Excel 文件，并将 Excel 文件导入为 XML 数据。 首先，你需要添加对 `...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值