csv2sql

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string folderPath = @"D:\test\b\";
            string[] fileNames = Directory.GetFiles(folderPath);
            string connstr = "server=.;database=test;uid=sa;pwd=dinglin";
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                foreach (string fileName in fileNames)
                {
                    string name = Path.GetFileName(fileName);
                    Console.WriteLine(name);

                    using (var reader = new StreamReader(@"D:\test\b\" + name)) // 替换为实际的CSV文件路径
                    {
                        string line;
                        int i = 0;
                        while ((line = reader.ReadLine()) != null)
                        {
                            i++;
                            if (i == 1)
                            {
                                continue;
                            }
                            using (SqlCommand cmd = new SqlCommand("insert into t_test (TradingDay,InstrumentID,LastPrice,PreClosePrice,OpenPrice,HighestPrice,LowestPrice,Volume,LowerLimitPrice,UpdateTime,ActionDay) values (@TradingDay,@InstrumentID,@LastPrice,@PreClosePrice,@OpenPrice,@HighestPrice,@LowestPrice,@Volume,@LowerLimitPrice,@UpdateTime,@ActionDay)", conn))
                            {
                                string[] fields = line.Split(','); // 如果CSV文件使用其他分隔符，可以修改此处

                                string TradingDay = fields[0];
                                string InstrumentID = fields[1];
                                string LastPrice = fields[4];
                                string PreClosePrice = fields[6];
                                string OpenPrice = fields[8];
                                string HighestPrice = fields[9];
                                string LowestPrice = fields[10];
                                string Volume = fields[11];
                                string LowerLimitPrice = fields[17];
                                string UpdateTime = fields[20];
                                string ActionDay = fields[43];

                                cmd.Parameters.AddWithValue("@TradingDay", TradingDay);
                                cmd.Parameters.AddWithValue("@InstrumentID", InstrumentID);
                                cmd.Parameters.AddWithValue("@LastPrice", LastPrice);
                                cmd.Parameters.AddWithValue("@PreClosePrice", PreClosePrice);
                                cmd.Parameters.AddWithValue("@OpenPrice", OpenPrice);
                                cmd.Parameters.AddWithValue("@HighestPrice", HighestPrice);
                                cmd.Parameters.AddWithValue("@LowestPrice", LowestPrice);
                                cmd.Parameters.AddWithValue("@Volume", Volume);
                                cmd.Parameters.AddWithValue("@LowerLimitPrice", LowerLimitPrice);
                                cmd.Parameters.AddWithValue("@UpdateTime", UpdateTime);
                                cmd.Parameters.AddWithValue("@ActionDay", ActionDay);

                                cmd.ExecuteNonQuery();
                                //Console.WriteLine("TradingDay" + fields[0]);
                                //Console.WriteLine("InstrumentID" + fields[1]);
                                //Console.WriteLine("LastPrice" + fields[4]);
                                //Console.WriteLine("PreClosePrice" + fields[6]);
                                //Console.WriteLine("OpenPrice" + fields[8]);
                                //Console.WriteLine("HighestPrice" + fields[9]);
                                //Console.WriteLine("LowestPrice" + fields[10]);
                                //Console.WriteLine("Volume" + fields[11]);
                                //Console.WriteLine("LowerLimitPrice" + fields[17]);
                                //Console.WriteLine("UpdateTime" + fields[20]);
                                //Console.WriteLine("ActionDay" + fields[43]);


                                // 处理读取的数据
                                //foreach (var field in fields)
                                //{
                                //    Console.WriteLine(field);
                                //}
                            }
                        }
                    }
                }
            }
        }
    }
}