问题遇到的现象和发生背景
我把csv文件放在了项目的debug下
csv文件如下所示:
问题相关代码
private void btn_LoadCSV_Click(object sender, EventArgs e)
{
CreatedMysqlTable(); //创建表test
//读取CSV文件
MySqlBulkLoader bulkLoader = new MySqlBulkLoader(msc);
bulkLoader.TableName = "test"; //插入的表的名字
OpenFileDialog file = new OpenFileDialog();
file.ShowDialog();
string fullname = file.FileName;
//string path = System.IO.Path.GetDirectoryName(fullname);
//string name = System.IO.Path.GetFileName(fullname);
bulkLoader.FileName = fullname; //路径
//bulkLoader.FileName = Environment.CurrentDirectory + "\\" + "test.csv";
bulkLoader.FieldTerminator = ","; //字段间的间隔方式 This can be { comma,tab,semi colon, or other character}
bulkLoader.LineTerminator = "\n";
int count = bulkLoader.Load(); //执行
}
运行结果及报错内容
“MySql.Data.MySqlClient.MySqlException”类型的未经处理的异常在 MySql.Data.dll 中发生
File 'D:\Work\研究生\CS与MySQL\Mysql\Mysql\bin\Debug\test.csv' not found (OS errno 2 - No such file or directory)
辛苦各位帮忙解决了!