第四次C#作业-MySQL数据库及C#操作MySQL数据库

作业链接：http://user.qzone.qq.com/303727350/blog/1430966678

信管1123 林少鑫 201211671312

完成目标：多表操作

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

namespace mysqlTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            
            InitializeComponent();
        }

        private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
        {

        }

        //打开文件
        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog openfile = new OpenFileDialog();
            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                if (Path.GetExtension(openFileDialog.FileName) == ".txt")
                {
                    txtToMysql(openFileDialog.FileName);
                }
                else
                {
                    DataSet da = ExcelToDS(openFileDialog.FileName);
                }
            }  
        }

        //从txt读取内容并显示，同时存到数据库
        public void txtToMysql(string path)
        {
            //mysql数据库打开
            string mycoon = "server=localhost;Database=test;Uid=root;Pwd=;Charset=utf8;";
            MySqlConnection con = new MySqlConnection(mycoon);
            con.Open();

            //打开txt
            StreamReader sr = new StreamReader(path,Encoding.Default);
            string s;
            while ((s = sr.ReadLine()) != null)
            {
                string[] str = s.Split(new char[]{' '});
                txtToMysql(con,str[1],str[2],str[3],str[4]);