作业链接: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]);