sqlCsharpUlploadCols

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

namespace kurvalaci
{
    class Program
    {
        static MySqlConnection conn = new MySqlConnection(
            "Server=winsql.vereb.dc;" +
            "Database=diak52;"+
            "Uid=diak52;"+
            "Pwd=5EebEM;"
            );

        static void Main(string[] args)
        {

            /*var adapter = new MySqlDataAdapter();
            adapter.SelectCommand = new MySqlCommand("SHOW TABLES", conn);
            var reader = adapter.SelectCommand.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine(reader[0]);
            }*/
            Feltolt();

            Console.ReadKey();
        }
        private static void Feltolt()
        {

            var sr = new StreamReader("lopott_adatok.txt",Encoding.UTF8);
            conn.Open();

            string[] os = sr.ReadLine().Split('\t');
            var sql = $"INSERT INTO filmek({os[1]} , {os[2]} , {os[3]} , {os[4]}) VALUES ";
            sr.ReadLine();
            while (!sr.EndOfStream)
            {
                var t = sr.ReadLine().Split('\t');
                sql += $"('{t[1].Replace("\'","\'\' ")}','{t[2]}','{t[3]}','{t[4]}'), ";

            }
            sql = sql.TrimEnd(',', ' ') + ';';
            var adapter = new MySqlDataAdapter();
            adapter.InsertCommand = new MySqlCommand(sql, conn);
            adapter.InsertCommand.ExecuteNonQuery();
            conn.Close();
        }
    }
}