5259读txt 插入sql 控制台应用

待读取的txt

执行完之后：

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;

namespace readtxttoxml
{
    internal class Program
    {
        static void Main(string[] args)
        {

            string connectionString = "Data Source=localhost;Initial Catalog=pic1;Integrated Security=True";
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            string[] lines = File.ReadAllLines(@"D:/softwaretools/vs2022/sourse/xmltxtresource/txttosql.txt");//D:/softwaretools/vs2022/sourse/xmltxtresource/txxtosql.txt
            foreach (string line in lines)
            {
                string[] fields = line.Split('，');//注意下面的sql语句的列名，表名,参数类型
                string query = "INSERT INTO student2 (name,sex,age) VALUES (@Value1, @Value2, @Value3)";
                SqlCommand command = new SqlCommand(query, connection);
              
                command.Parameters.Add("@Value1", SqlDbType.Char);
                command.Parameters["@Value1"].Value = fields[0];
                command.Parameters.Add("@Value2", SqlDbType.Char);
                command.Parameters["@Value2"].Value = fields[1];
                command.Parameters.Add("@Value3", SqlDbType.Int);
                command.Parameters["@Value3"].Value = int.Parse(fields[2]);
                int rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine($"修改了{rowsAffected}行");
            }

            connection.Close();

        }
    }
}