/// <summary>
/// 将Excel数据导入至数据库
/// </summary>
/// <param name="fileName">Excel文件名</param>
/// <param name="tableName">要插入数据库的表名</param>
/// <param name="CONNECTION">连接字符串</param>
public static void IOtoSQL(string fileName, string tableName, string CONNECTION)
{
SQLTool mysql = new SQLTool();
mysql.open(CONNECTION);
try
{
DataTable dt = ReadExcelToTable(fileName);
if (!checkExcel(tableName, dt))
{
throw new Exception("文件格式不符合要求\n请查看帮助信息");
}
dt.Columns.Add("autoid", typeof(int));
mysql.BatchInsert(dt, tableName);
MessageBox.Show(System.IO.Path.GetFileNameWithoutExtension(fileName) + "\n数据导入成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
mysql.close();
}
}
