C#我做一个，打开指定类型文件并把文件输入到Mysql中，请问我这代码哪里有问题，一直无法输进Mysql中

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace _1y8h
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private static string connString = "server=127.0.0.1;port=3306;user=root;password=123456;database=fy8h;";
        public static MySqlConnection connection = new MySqlConnection(connString);
        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();
            openFileDialog1.Filter = "文档(*.csv;*.csv|*.csv;*.csv";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if (openFileDialog1.FileName != "")
                {
                    txtFile.Text = openFileDialog1.FileName;
                }
                MessageBox.Show("添加文件成功");
            }
        }
        public void Read(string Path)
        {
            StreamReader sr = new StreamReader(Path, Encoding.UTF8);
            string line;
            while ((line = sr.ReadLine()) != null)
            {
                int i = 0;
                while (i < 1)
                {
                    if (i == 0)
                    {
                        i++;
                        continue;
                    }
                }
                Console.WriteLine(line.ToString());
                string[] strArr = line.Split(',');
                for (int ii = 0; ii < strArr.Length; ii++)
                {
                    strArr[ii] = strArr[ii].Replace('"', ' ').Trim();
                }
                if (connection.State == ConnectionState.Closed)
                    connection.Open();
                string sql = $"insert into t_plcdata (F_ID,F_Address,F_DataType,F_Len,F_Valid,F_Memo,F_Function," +
                    $"F_Form,F_DecimalNum,F_Multiple,f_alertflag,F_Index," +
                    $"F_EventFlag)value ('{strArr[0]}','{strArr[1]}','{strArr[2]}" +
                    $"','{strArr[3]}','{strArr[4]}','{strArr[5]}','{strArr[6]}'," +
                    $"'{strArr[7]}','{strArr[8]}','{strArr[9]}','{strArr[10]}','{strArr[11]}','{strArr[12]}')";

            }
        }

            private void btnSql_Click(object sender, EventArgs e)
        {
            Read(txtFile.Text);
        }


![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/756144496146191.png "#left")

你的代码不完整，还需要一个MySqlCommand对象，然后调用MySqlCommand对象的ExecuteNonQuery方法，以执行SQL脚本，如下：

比如：

以下是我写的《C#+ADO.NET实现对SQL Server数据库的写入、更新、删除数据操作》，供参考，思路是一样的：

完整的《C#+ADO.NET数据库入门教程 》，请参考：

当我按...控件 开始添加文件，然后选定指定文件后，点击导入到SQL(btnSql)，数据库就会出现我要的数据，小白求指点谢谢！